JSON to different table transform method

FairCom Edge's transform method for converting JSON properties to fields in a different integration table

Abstract

FairCom Edge's transform method for converting JSON properties to fields in a different integration table

The "jsonToDifferentTableFields" transform method extracts one or more properties from a JSON document and writes property values to fields in a table. You specify the target table and 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 `"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.
Tutorials	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.