jsonExtractValuesByPaths (JSON Creation & Manipulation)
Compatible with:
- Purpose
- This command is used to retrieve data selected from the parts of the document matched by the
patharguments. - If the number of values returned are more than the columns in the dataset, command fails with error "The Number of columns returned are more than the number of attributes in the data definition
- Syntax
- jsonExtractValuesByPaths({Json/VariableName} || path(, path),datasetName)
- Multiple paths can be provided seperated by comma.
- Target
- {Json/VariableName} || path(, path)
- Value
- datasetName/VariableName
- Return Value
- Data retrieved from the JSON document is bound to the dataset or a variable. If multiple values are returned, and if the value is a dataset they are added as multiple columns or if the value is variable then they are added as comma separated values.
Example(s):
Click here to see the example