Get JSON Document Data Step

Use the Get JSON Document Data step after the Create JSON Document step to obtain data from a document formatted with JSON. This step needs a JSON Document as an input and then uses JSON path expressions to parse the content and extract data elements. Use Create JSON Document to create a JSON document.

The extracted data elements can be of the type:

  • int

  • int[]

  • short

  • short[]

  • long

  • long[]

  • float

  • float[]

  • double

  • double[]

  • boolean

  • boolean[]

  • string

  • string[]

  • Document (instance of JSON Document)

  • Document [] (Array of JSON Document instances)

If the document is a valid document, but either the parsing fails due to an invalid JSON path or JSON path expression does not return a value, then the following is the return value:

  • For all array types, it will be an empty array.

  • For all other types, it will be null.

Note

JSON Path is a query language for selecting fields from a JSON document similar to how XPath is used for selecting nodes from an XML document.

The following table describes the properties of the Get JSON Document Data customizer window:

Get JSON Document Data Step Properties

Property

Description

Document

Document variable created as the Result Document in a preceding Create JSON Document step.

JSON Path

JSON path that defines a specific field or value in a JSON document.

Result Data

Document variable that contains the JSON data.