Data Export#

Data can be exported in JSON format and as MS Excel spreadsheets.

The system JSON file format is used to Export and Import various operations on model instances. The operations available via JSON files are: Add, Modify, Delete. This Import and Export task is carried out from the Admin Portal or API using the file Export and Import functionality.

The JSON file format for the different operations is available when you Export a specific model and choose JSON as the export format. The API provides a request URL and parameter for this task - refer to the API documentation. The export file format is a compressed JSON file. The import filename and format can be <filename>.JSON, <filename>.JSON.zip or <filename>.JSON.gz.

The Excel file format for data export of selected items can be carried out in the list or instance view of a model.

Commands can be exported from the Admin Portal by choosing Export and then selecting either Excel or Excel (formatted) as the export format. The API provides a request URL and parameter for this task - refer to the API documentation. The export file format is a MS Excel XLSX file.

The Field Display Policy that applies to a menu item from which an Excel (formatted) export of data is carried out, is reflected in the Excel (formatted) exported sheet as follows:

  • Titles of attributes

  • Sequence of the attributes

  • Group names

  • Hidden fields, with the exception of mandatory fields.