Get Rows as JSON Activity
The Get Rows as JSON activity enables the conversion of specific dataset rows into a JSON-formatted variable. This functionality facilitates data manipulation and integration by structuring tabular data into a standard machine-readable format.
| Field | Description | Requirement |
|---|---|---|
| Dataset name | Specifies the reference name of the target dataset. | Required |
| Rows | Defines the index range of the rows to be retrieved from the dataset. | Required |
| Result variable name | Designates the name of the variable where the JSON output will be stored. | Optional |
Action Types & Examples
JSON Data Extraction
- Format: string (JSON)
- Example Result: "[{"Column1": "Value1", "Column2": "Value2"}]"
Implementation Examples
Field Setup - Dataset name: newDS - Rows: 0:3
Execution Parameters - Result variable name: getJSON
Technical Notes
The row index uses a range-based notation; for example, "0:3" retrieves the first three rows of the dataset. Ensure that the dataset name provided matches the reference name established in the initialization phase of the workflow.