Skip to Content

Scripting example in Jitterbit App Builder - JSON

This example demonstrates how to generate JSON using an action. A cell is updated with the generated JSON for use by a later action. The example leverages the JSON.Net library included with App Builder.

Table schema

Column Data Type Primary Key Auto-generate Nullable
CustomerId GUID Yes Yes No
CompanyName NVARCHAR(100) No No No
Address INTEGER No No Yes
City NVARCHAR(100) No No Yes
Region NVARCHAR(2) No No Yes
PostalCode NVARCHAR(50) No No Yes
AddressJson NVARCHAR(500) No No Yes

Note that the AddressJson column does not need to be defined on the table: it can be defined on the business object.

Script

#r "Newtonsoft.Json.dll"

using Newtonsoft.Json.Linq;

var address = new JObject(
    new JProperty("address", Row["Address"].Value),
    new JProperty("city", Row["City"].Value),
    new JProperty("region", Row["Region"].Value),
    new JProperty("postalCode", Row["PostalCode"].Value)
);

Row["AddressJson"].Value = address.ToString();