Skip to main content

JSON to table transform



Use cases

The primary use case for extracting values from JSON properties and putting them in table fields is to enable SQL queries to use the collected data.


The "jsonPropertiesToExternalFields" transform action can be used to take specified properties from a JSON object in one table and store them as separate fields in a record in a separate table.


These tutorials detail how to create and manage the JSON-to-table transform.

API reference

The API reference outlines and defines the properties used to utilize the JSON-to-table transform.