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:
Type | Usage |
---|---|
Expand all | Expand all fields |
Compact | Collapse all fields |
Code/TreeView | This 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 |
Searchbox | This 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 |
Import | There 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:
Type Usage Boolean The field type is a conditional field that can be true or false Object An unordered set of key/value pairs Number A number field Array An ordered collection of values String Field 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:
Shortcut | Usage |
---|---|
Alt+Arrows | Moves the caret up/down/left/right between fields |
Ctrl+Shift+Arrow Up/Down | Selects multiple fields |
Shift+Alt+Arrows | Moves field up/down/left/right |
Ctrl+D | Duplicates field |
Ctrl+Del | Removes field |
Ctrl+Enter | Opens link when on a field containing an URL |
Ctrl+Ins | Inserts a new field with type auto |
Ctrl+Shift+Ins | Appends a new field with type auto |
Ctrl+E | Expands or collapse field |
Alt+End | Moves the caret to the last field |
Ctrl+F | Finds |
Ctrl+G | Finds next |
Ctrl+Shift+G | Finds previous |
Alt+Home | Moves the caret to the first field |
Ctrl+M | Shows actions menu |
Ctrl+Z | Undoes the last action |
Ctrl+Shift+Z | Redoes |