Skip to main content

JSON to different table transform method

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.