JSON to fields

FairCom Edge's transform method for converting JSON properties to fields in the current integration table

Abstract

FairCom Edge's transform method for converting JSON properties to fields in the current integration table

The "jsonToTableFields" transform method extracts one or more properties from a JSON document and writes property values to fields in the current integration table. You map JSON properties to specific fields in the table.

Section	Description
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.
Concepts	The `"jsonToTableFields"` transform action can be used to take specified properties from a JSON object in one table and store them in fields.
Tutorials	These tutorials detail how to create and manage the JSON-to-field transform.
API reference	The API reference outlines and defines the properties used to utilize the JSON-to-field transform.