Skip to main content

Data

Data Structure​

The Data Structure Editor is a web-based tool to view, edit, and format data. It shows your data side by side in a clear, editable tree view and a code editor.

The Data Structure allows you to have a schema of the local variables that are sent by each record. If you configure your Data Structure, then you will be able to use any variables from your data inside workflows, contents, conditions or apps.tions,...

These variables will look like @data.var@.

The Editor​

The Editor is a web-based tool to view, edit, and format data. It shows your data side by side in a clear, editable tree view and a code editor.

The editor is divided into two areas:

The toolbar​

The toolbar menu contains the following buttons:

TypeUsage
Expand all Expand allExpand all fields
Compact Compact allCollapse all fields
Code/TreeViewThis option displays the JSON data in an editable tree, or if it is more suitable for you, then you can modify manually. The editor makes it easy to create, duplicate, remove fields, and to edit the contents of the fields
SearchboxThis search input field allows you to find any field inside your data. Search results will be highlighted and can be iterated by repeatedly pressing Enter or Shift+Enter. The right side of the search box will have two buttons to go to the next or previous search result
ImportThere is two way to place your data: pasting directly into the editor or importing from one of the following formats: JSON, XML or CSV

The Editor Canvas​

Canvas is the place where the data is placed.

How does the Tree View work​

The Tree editor displays the JSON data in an editable tree. The field values in the editor are editable input fields, can be dragged up and down using the drag area on the left side of the fields.

If the field that we want to modify is inside an Array or Object, it can also be dragged and moved up, down and out or in of the Array or Object.

Right next to the drag area there is a button to open the actions menu. Depending on the type of field, the following functionalities may be available in the actions menu:

  • Type. Change the type of the field. Choose from:

    TypeUsage
    BooleanThe field type is a conditional field that can be true or false
    ObjectAn unordered set of key/value pairs
    NumberA number field
    ArrayAn ordered collection of values
    StringField type is not determined from the value but always returned as string
  • Sort. Sorts the child nodes of an array or object. For an array, the values of the child nodes will be sorted. In case of an object, the child nodes will be sorted by key. Arrays and Objects can be sorted ascending or descending.

  • Insert. Inserts a new field before the current field. Available types are auto (default), object, array, and string.

  • Append. Inserts a new field after the current field. Available types are the same as the Insert action.

  • Duplicate. Duplicates the field, including all child nodes.

  • Remove. Removes the field, including all child nodes.

Shortcut keys​

The tree editor supports shortcut keys for all available actions. The following shortcut keys are available:

ShortcutUsage
Alt+ArrowsMoves the caret up/down/left/right between fields
Ctrl+Shift+Arrow Up/DownSelects multiple fields
Shift+Alt+ArrowsMoves field up/down/left/right
Ctrl+DDuplicates field
Ctrl+DelRemoves field
Ctrl+EnterOpens link when on a field containing an URL
Ctrl+InsInserts a new field with type auto
Ctrl+Shift+InsAppends a new field with type auto
Ctrl+EExpands or collapse field
Alt+EndMoves the caret to the last field
Ctrl+FFinds
Ctrl+GFinds next
Ctrl+Shift+GFinds previous
Alt+HomeMoves the caret to the first field
Ctrl+MShows actions menu
Ctrl+ZUndoes the last action
Ctrl+Shift+ZRedoes