The JSONPath of an array element that defines the separation of rows.

Data Type

string

Default Value

""

Remarks

The connector automatically finds the object arrays in the document and models them as rows. This parameter allows you to explicitly define the object arrays using XPaths.

Multiple paths can be specified using a semicolon-separated list. The DataModel property governs how the nested object arrays are modeled as tables.

Automatically Detecting Object Arrays

If JSONPath is left empty, the connector will determine the JSONPaths by parsing the JSON document and identifying the object arrays. The DataModel and RowScanDepth properties configure the row scan; see Automatic Schema Discovery for more information.

This property will be used to generate the schema definition when a schema file is not present (see Customizing Schemas).

JSONPath Examples

Example JSONPath for the people example in Raw Data: $.people.vehicles.maintenance

A wildcard JSONPath can also be used and is helpful in the case that the JSONPaths are all at the same height but contain different names:

<rsb:set  attr="JSONPath" value="/feed/*" />