Description
The Create Json Object activity nests multiple column values into a single JSON object under a new column. This transformation is useful when preparing data for APIs or JSON-based storage systems by grouping related fields together.
- You define the columns to combine using Column Names.
- The resulting JSON object will be stored under the name provided in Output Column.
- You can choose to retain or discard the original columns using Include Original.
Use case: When sending address or contact information to an API, you may want to combine fields like Street, City, and Zip into a single structured JSON object called Address. This helps in keeping the data compact and grouped logically for downstream systems.
- Data – Required
Requires tabular input data with columns to be nested.
Output
| Output Type | Format | Description |
|---|
| Data | Tabular | Data with selected columns nested as a JSON object column. |
Configuration Fields
| Field Name | Description |
|---|
| Column Names | List of columns to combine into a JSON object. |
| Output Column | The column name where the resulting JSON object will be stored. |
| Include Original | If true, the original columns are kept in the output. If false, they are removed. |
| Name | Age | Street | City | Zip |
|---|
| Alice | 30 | 123 Maple Ave | New York | 10001 |
| Bob | 40 | 456 Oak Street | Chicago | 60601 |
Sample Configuration
| Column Names | ["Street", "City", "Zip"] |
| Output Column | Address |
| Include Original | false |
Sample Output
| Address |
|---|
| {“Street”:“123 Maple Ave”,“City”:“New York”,“Zip”:“10001”} |
| {“Street”:“456 Oak Street”,“City”:“Chicago”,“Zip”:“60601”} |
