Each element/endpoint on the canvas must have a data layout defined to be linked and able to transfer data. Data layout defines the type and structure of the incoming or outgoing data.
Accessing Element’s Data Layout
To access element’s data layout settings, select the element on the canvas, and choose either ‘New’, ‘Select’, or ‘Edit’ existing data layout in the right sidebar.
Tip: double-click an element on the canvas to quickly access its data layout.
DSYNC can work with the following data types: JSON, XML, CSV (delimited – any symbol, not just comma), XLS, XLSX, ODS, and TXT.
JSON/XML are object orientated structures which allow you to model objects (parent-child relationship). All other data types are tabular - row based layout where each row represents one object.
Data structure can be modelled by adding and positioning fields on the data layout page. Depending on the Data Type selected you can either model flat data structure (tabular format such as CSV, XLS, ODS) or complex data structure with objects and arrays (JSON, XML). All fields on the data layout are draggable.
Drag-n-drop a field vertically to change its position within the data layout.
Drag-n-drop a field horizontally to nest fields (create parent-child relationships). Horizontal dragging is only available underneath fields of type ‘object’.
Objects are available only with data type JSON and XML. Arrays can be configured using field’s attribute ‘Multiple’.