JSON to table mapping in Jitterbit App Builder

Overview

Data in App Builder is modeled using relational tables. Most REST APIs use JSON to communicate. To process the JSON data within App Builder, a transformation must occur to map the JSON data to relational tables. This mapping occurs as follows:

JSON objects and their nested children objects are flattened into a single table.
JSON arrays create new tables.

Examples

Simple object

JSON

{
  "name": "Thomas Magnum",
  "occupation": "Private Eye"
}

Relational Table

Table "endpoint"

name	occupation
Thomas Magnum	Private Eye

Nested object

JSON

{
  "name": "Thomas Magnum",
  "occupation": "Private Eye",
  "bestCar": {
    "model": "Ferrari 308 GTS",
    "year": "1978"
  }
}

Relational Table

Table "endpoint"

name	occupation	bestCar/model	bestCar/year
Thomas Magnum	Private Eye	Ferrari 308 GTS	1978

Arrays

JSON

{
  "name": "Thomas Magnum",
  "occupation": "Private Eye",
  "ferraris": [
    { "model": "308 GTS", "year": "1978" },
    { "model": "308 GTSi", "year": "1980" },
    { "model": "308 GTSi Quattrovalvole", "year": "1984" },
  ]
}

Relational Tables

Table "endpoint"

name	occupation
Thomas Magnum	Private Eye

Table "endpoint/ferraris"

model	year
308 GTS	1978
308 GTSi	1980
308 GTSi Quattrovalvole	1984