Export to JSON File¶
The Export to JSON File task allows users to export datasets or other data structures to JSON files.
The Export to Excel task is divided into two tabs:
the Options Tab (please refer to the page Export Overview for further information).
the Export Options Tab, whose characteristics and description will be explained in the next section.
The Options Tab¶
As mentioned in the Export Overview page, the Options tab contains:
the Location Controller, whose description is provided in the Export Overview page.
the File options, which contains all the same options for all export tasks, except for the File basename, whose details are provided below.
File basename
In the File basename pane, users will be able to set and configure the following options:
File basename: in this edit box, users can enter a name for the name that will be given to their exported file.
Add current date and time as prefix: if selected, the date and timestamp will be added to the start of the file basename as a prefix.
Add current date and time as suffix: if selected, the date and timestamp will be added to the start of the file basename as a suffix.
The Export Options tab¶
The Export Options tab is divided into one pane: the Dataset Structure pane.
Dataset Structure
In the Dataset structure pane, users will be able to set and configure the following options:
- File format: through the drop-down list, users can choose the format in which they want to export their file.
Available options are:
flat
nested
group
Key for types: in this text box, users can specify the attribute which defines the data type.
Remove missing value: if selected, missing records are removed from the exported file.
Example¶
Drag an Export to JSON File task onto the stage and link it to the task containing the data to export to it.
Configure the selected task as explained in the sections above.
Please check that the dataset has been saved correctly in the selected folder with the correct name.
According to the selected JSON File and the selected configuration options, your Export to JSON File task should look like the example provided below.
