Working with XML and JSON

Overview

Team Edition supports XML and JSON column types (in relational databases) by using standard JDBC interfaces. This feature was added in JDBC4 so you will need JDBC4 compliant driver for your database.

Editing XML and JSON data

You can interact with XML/JSON data directly in the Data Editor.

Editing JSON data

You can edit JSON data directly in the cell. For more complex or large JSON datasets, use the full-size editor:

1. Click a cell containing JSON data.
2. Press Shift+Enter to open the full-size editor in a new tab.

Tip: Use Auto Format to adjust spacing and indentation for better readability. Shortcut: Ctrl+Shift+F.

Editing XML data

To work with XML data, switch to the XML tab available on the left side of the Data Editor. You can edit XML content directly within this tab.

Working with XML and JSON data in the Value panel

You can also interact with XML/JSON data using the Value panel, which provides tools for formatting, uploading, saving, and switching formats.

Note: The Value panel isn't available when working in the XML tab.

For more details, see Panels.

Formatting options

Through the context menu (right-click within the Value panel), you can access the following features to improve readability and manage text display:

Action	Description	Shortcut
Auto Format	Adjust spacing and indentation for better readability.	Ctrl+Shift+F (⌃⇧F for macOS)
Toggle Word Wrap	Enable or disable word wrapping within the editor.