How Do I Map Nested JSON Data in an Integration?
Last updated: November 17, 2026
When your JSON has objects inside objects, the JSON Transformer on the Data Format page pulls out the parts you need so they can be mapped like a flat file. It only appears after you select JSON as the data format.
Required permissions:
The Integrations: Edit permission is required to set up the JSON Transformer.
Build Field Mappings from a Sample File
Open the integration, click on Data Format in the side menu, and select JSON.
Under JSON Transformer, click on View Schema Builder.
Select a file you've already sent from the Uploads drop-down menu.
Select the fields you want, then click on Add Fields. They'll be added to the Field Mappings table.
Choose the Nested Objects to Use
Under JSON Mapping (optional), enter the path to the data in the Source Object field using dot notation, such as "body.records".
Optional: Click on Add Source for each additional object. When you use more than one source, keep them in the same order in every file, because objects are matched by their order.
Optional: Enter a new name in the Destination Object (optional) field to rename a section, which helps when two sources share field names.
Set the Parsed JSON Format toggle to Flatten to JSON Dot Notation to flatten nested fields, or leave it on Raw.
Click on Save Data Format.