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.

  1. Enter the name of the variable containing the JSON data from which to extract information.

  2. Enter your JSONPath query.

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

  4. Enter the name of the variable into which to place the results.

  5. Instruct the wizard how to handle any errors encountered. Read more about error handling.