JSON Extract

image_pdfimage_print

You can use the JSON extract to read data from JSON files and Web Services. To use it, you need a JsonFile connection type. The extract definition uses JSONPath language, which is a standard query language for selecting nodes from a JSON document. You can find more information on JSONPath at http://goessner.net/articles/JsonPath/.

The location is a JSONPath expression that defines the root or anchor element of the JSON document under which the data are read. You can define as many JSONPath expressions as you want. Each expression defines a column of the extract output. For each column, a name and a default value can be defined. All space, multiple space, or null values will be mapped to this default value.

Under Advanced Settings, you have the option to use caching for none (default), memory, or disk. See Caching in Extracts for more information.

Sample JSON Extract

You can take a look at the Jedox Integrator sample “sampleJSON”:

Result:

If you want to access data fields from an array, you must specify in the JSONPath the position of the element in the element in the array. For example, to display only the first element of the array in the json above set the path to $.store.book[0]. Only the first element is displayed in the Data Preview:

image_pdfimage_print