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

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.


(...)


Nth-Item string
The nth-JSON item to save in the file.


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


Nth-Value
The nth-value to save in the file.