Get Row as JSON Activity
The Get Row as JSON activity enables the conversion of a specific row within a dataset into a JSON-formatted string variable. This functionality allows for the structured extraction of data for use in downstream automation processes and API integrations.
| Field | Description | Requirement |
|---|---|---|
| Dataset name | The reference name of the target dataset. | Required |
| Row | The index of the specific row to be retrieved. | Required |
| Result variable name | The name of the variable that will store the returned JSON value. | Optional |
Action Types & Examples
JSON Extraction
- Format: string
- Example Result: "{"id": 1, "status": "active", "user": "admin"}"
Implementation Examples
Field Setup - Dataset name: newDS - Row: 0
Execution Parameters - Result variable name: getJSON
Technical Notes
The row index utilizes a zero-based numbering system, where "0" represents the first record in the dataset. Users must ensure the dataset is properly initialized and the specified index exists within the dataset range to prevent runtime exceptions.