Projects Export File Format

This article describes the projects export file format (file extension .json).

Spec

The outmost level is a json object with Project property containing array of #Project objects:

Project

The Project objects have following properties:

• Name (String): String representing the project name. (Required)
• Description (String): String describing the project.
• Configuration (Object): Project configuration object.
• Datatables (Datatable*): Array of datatable objects describing the project's datatables.
• Models (Model*): Array of nodel objects describing the project's models.
• Dashboards (Dashboard*): Array of dashboard objects describing the project's dashboards.
• Scripts (Script*): Array of ccript objects describing the project's scripts.

Datatable

Datatable objects has following properties:

• Name (String): Datatble name. (required)
• Description (String): Datatable description text.
• Configuration (Object): Datatable configuration object.

Model

Model objects has following properties:

• Name (String): Model name. (required)
• Description (String): Model description text.
• Configuration (Object): Model configuration object.
• Attributes (ModelAttribute*): Array of #Model_attribute objects describing the model's attributes.

Model attribute

Model attributes are currently used to store the design diagrams of the model. Model attribute objects has following properties:

• Type (String): Attribute type. The only supported value is Diagram. (required)
• Name (String): Attribute name (diagram name). (required)
• Description (String): Attribute description text.
• Content (Object): Attribute content. (required)

Dashboard

Dashboard objects has following properties:

• Name (String): Dashboard name. (required)
• Description (String): Dashboard description text.
• Identifier (String): Dashboard identifier.
• Content (Object): Dashboard content as object. (required)

Script

Script objects has following properties:

• Name (String): Script name. (required)
• Description (String): Script description text.
• Code (String): Script code.
• Language (String): Script language, either Expression or SQL. (required)

Examples

let result = ScriptById(123).Run(#{
  "parameter1": "value1",
  "parameter2": false,
  "parameter2": 123.45
})