JSON Export from Table

Kalipso - Form - Actions - Actions Description - Group Code - JSON Export from Table

Exports from a Database Table to text or a JSON file.

Action available for the following operating systems:

Parameters

General

• Target type - Defines the type of the target. It can be one of:

  • 1. Yes

  • 2. No

• Encoding - Indicates the file encoding to use. It can be one of:

  • 1. Unicode UTF-16 LE (each character uses 2 bytes)

  • 2. ANSI/BINARY (each character uses 1 byte)

  • 3. Unicode UTF-8 (each character uses 1 byte to 4 bytes)

• Target File - The name of the target.

User must define a control or a variable to be a target. Also is possible to save in a file, by defining the complete path and name to the file.

• Database Profile - The name of the Database Profile defined.

• SQL - The SQL code to define the Database Table.

• JSON Prefix string - The JSON Prefix to each JSON item.

• JSON Suffix string - The JSON Sufix to each JSON item.

Column List

• Array/Item Name string - The JSON item to save in the file.

• Export as - The type of export to be made. It can be one of:

  • Array of Objects

  • Array of Values

  • Single Element

• Item - The JSON item to save in the file.

• Type - The type of the JSON item to save in the file.

• Value - The value to save in the file.

In Unicode UTF-16 LE, the BOM (Byte Order Mark) 0xFEFF will be added to the beginning of the file.

In Unicode UTF-8, no BOM (Byte Order Mark) will be added.

The actions File Open and File Close don't need to be used.