# JSON Export from Table

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

Action available for the following operating systems:

![](/files/-MAlQBZuuTnc6hyzKSVQ)

### 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-code-flow/json-export-from-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.