# JSON Export from Table

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

Action available for the following operating systems:

![](https://3821468174-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTlA1suFa5N48x_83N%2F-MAlPVpH3WRwBy16c7JY%2F-MAlQBZuuTnc6hyzKSVQ%2Fimage.png?alt=media\&token=5c9534b7-ca05-4ac4-b408-2207cd5a5295)

### 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. 

{% hint style="info" %}
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.
{% endhint %}

* **Database Profile** - The name of the Database Profile defined.
* **SQL** - The SQL code to define the Database Table.

{% hint style="info" %}
For sub-queries, you can use function **COL\_EXPORT**(tableIndex, colIndex) for accessing parent Tables columns to use as filter in your SQL query.
{% endhint %}

* **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.

{% hint style="info" %}
In Unicode UTF-16 LE, the BOM (Byte Order Mark) 0xFEFF will be added to the beginning of the file.
{% endhint %}

{% hint style="info" %}
In Unicode UTF-8, no BOM (Byte Order Mark) will be added.
{% endhint %}

{% hint style="info" %}
The actions [File Open](https://docs.sysdevmobile.com/kalipso50/action_99.htm) and [File Close](https://docs.sysdevmobile.com/kalipso50/action_104.htm) don't need to be used.
{% endhint %}