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