JSON data type

JSON data type

When setting a connector to ingest nested data as JSON data type, Panoply will ingest the entire object or JSON string as JSON. Any additional deeper nested fields will be part of the Panoply JSON field and will not be handled in any other way.

For example, the following record contains a nested location object:

{id:1, location: {city: 'San Francisco', state: 'CA', country: 'USA'}}

It would be ingested into the table in the following format:

Note that ingesting as JSON data type is applicable for nested objects only, not for nested lists. For example, the following record cannot be ingested as JSON data type:

{locations: [ 'one', 'two', 'three' ]}

The nested data behavior exists directly in the data sources. Either change the default behavior or enter specific field paths and set their nested behavior to ingest as JSON data type.