Output format

You can configure format of output that is produced by AnySQL modeler.

You can use these format variants:

  • JSON (newline-delimited). This format is also known as nd-JSON, JSON Streaming or JSON Lines and used for exchanging object data between systems.
  • JSON (array). Usually known as JSON and a standard JSON format used in most systems.

See Infor ION Development Guide.

You can select the Enable Improved Data Type Normalization check box. It ensures that the output document contains just these data types, independent on source DB driver or data type:

  • Integer
  • Decimal
  • Date in format: "YYYY-MM-DD"
  • Date time in format: "YYYY-MM-DDTHH:MM:SS.SSSZ"
  • Time in format: "HH:mm:ss.SSS"
  • Boolean as true or false
  • String

The check box is selected by default for all new AnySQL Models.

When the output format is changed, you must regenerate metadata.

Changing output format:

  1. Click the gear icon in the AnySQL Modeler.
  2. Select the appropriate output format.
  3. Click UPDATE to return to the Modeler screen.