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.

Last updated