Dataset to JSON
Export rows from a dataset to JSON format. Each row of the dataset is exported as a JSON object. You can download this system service from Grexx Marketplace.
Only dataset columns with an external reference are included. By default, columns containing attributes inherit the external reference from the attribute (if set). For more information, see Configure datasets.
Input
Use a casetype activity to add inputs to the Start dataset to JSON form.
| Attribute | Data type | Mandatory? | Description |
|---|---|---|---|
| Dataset | Case ID | Yes | The case ID of the dataset to export. |
| Caseid | Case ID | Yes | The case ID that is used as the current case in the dataset filter. |
| Separator* | String | No | The character included in the external reference that delimits a parent key from a child key. Use this option to group related columns under the parent key in the resulting JSON. For example, columns with the external references case.id and case.created will be nested under case. |
* The seperator option was added in June 2025. To upgrade to the latest version, download the system service from Grexx Marketplace again and re-import the product to your Studio.
To view the case ID of a dataset, open the Datasets list, click Columns and enable the caseid column.
Output
Outputs are added to the Result dataset to JSON form when the Dataset to JSON case is closed.
| Attribute | Data type | Mandatory? | Description |
|---|---|---|---|
| Output | JSON (multivalue) | Yes | List of the resulting JSON objects. |