Create Json Object

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.

Input

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

Sample Input

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”}