Query JSON
Use a JSONPath query to extract specific information from JSON data stored in a variable and place it into a new or existing variable.
What is JSONPATH?
JSONPath (similar to XPath for XML) is a syntax or language used for finding elements in a JSON document.
Try it out: To test your JSONPath query while developing your wizard, simply click the jsonpath TESTER link from within QUERY json command.
-
Enter the name of the variable containing the JSON data from which to extract information.
-
Enter your JSONPath query.
-
Choose whether to retrieve the first matching result, the last result, or all results.
-
When choosing to retrieve all results, enter the delimiter to use to separate each result
-
-
Enter the name of the variable into which to place the results.
-
Instruct the wizard how to handle any errors encountered. Read more about error handling.