Specifies the JSONPath expression that defines which array elements are modeled as rows.

Data Type

string

Default Value

""

Remarks

When this property is not set, the add-in automatically detects object arrays in the JSON document and models them as rows.

When this property is set, the add-in uses the specified JSONPath expression to identify which arrays are represented as tables. Multiple paths can be defined by providing a semicolon-separated list.

The DataModel property determines how nested object arrays defined by this path are modeled as tables. The RowScanDepth property controls how many rows are scanned when detecting schema information.

Automatically Detecting Object Arrays

If JSONPath is left empty, the add-in scans the JSON document to determine which object arrays to use as tables. The DataModel and RowScanDepth properties configure this behavior. See Automatic Schema Discovery for details.

This property is also used to generate the schema definition when a schema file is not present. See Customizing Schemas for more information.

Examples

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

A wildcard JSONPath can also be used when arrays exist at the same level but have different names:

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

This property is useful for explicitly defining which arrays in a JSON document should be modeled as tables.