REST JSON arrays (drill downs) in Jitterbit App Builder

Introduction

App Builder can send complex JSON Arrays by making use of a new option, Drill Down.

You can specify the drill down table from the root API Call, and work your way down the JSON structure.

JSON arrays - GET example

Customer has multiple addresses.

Example record from the Customer table of a Customer with an ID, Name, and an array of 2 Addresses:

On the REST side, if we were to GET from that table it would create:

1. A Root table where the ID and Name are:

   

2. An Address table with 2 records:

   

JSON arrays - POST example

Post a local customer record

1. A simple Customer table with 1 record that contains an ID and Name:

   

2. An Address table with 2 records that are both linked to that Customer record by the CustomerID:

   

JSON arrays - POST endpoint

Set up our POST endpoint as usual

This example shows some sample JSON, which includes our record and our address tables.

• This generates the Tables for the REST Endpoint.

JSON arrays - API call

Top level API call rule

This rule is inserting the CustomerID and the Name. It is targeting the root table, which is customers (post). It is selecting id and name from the CustomerTest table.

JSON arrays - API call

Address API call rule

This rule is inserting into customers (post)/addresses. It is selecting the Address and ID info from the CustomerAddressTest table.

JSON arrays - drill down

Select address as a 'drill down' on top level API call (edge case settings)

Now that we have set up those two API Call rules we can tie them together, on the root API Call rule there is an Advanced Setting option called Drill Downs.

This allows us to specify sub-rules to run. In this case, we call Customer_Address_POST, which writes into that Address REST Endpoint table. We also configure the Binding.

JSON arrays - result

This works with multiple nested tables, and supports simple arrays.

• Edge Case Setting on REST Endpoint table.

• "Array Of Primitives".