Built-in apps
JSON

10min
﻿
With the JSON app in ﻿, you can process data or create new content in JSON format.
You do not need to establish a connection to use the JSON app.
JSON modules
You can use the following modules to build your ﻿. 
Aggregators
Aggregate to JSON
Converts the multiple output bundles to a single bundle.
You need to attach this aggregator module to the source module whose output you want to convert to a single module; for example, the Parse JSON modules give the output in multiple bundles.
After selecting the source module, select the data structure, and the remaining fields are populated from the source module.
﻿
Save the ﻿ and run it. The output is only one bundle.
﻿
Transformers
Convert JSON to XML
Converts the given JSON data to XML format.
﻿
Create JSON
This module helps you create JSON. The fields in this module depends on your data structure.
The data structure describes how the JSON data is organized and enables mapping individual JSON items to other modules in your ﻿.
﻿
Select the data structure and enter the field details to create JSON. The data provided in the module returns in the JSON format in the output.
﻿
Parse JSON
Data structure
The data structure describes how the JSON data is organized and enables mapping individual JSON items to other modules in your ﻿. If you don't provide the Data structure, you may manually run the module and ﻿ will build the structure from the provided JSON:
1
Fill the JSON string field in the Parse JSON module.
2
Do not yet connect the modules that follow. Since ﻿ doesn't know the structure of the JSON data, it will not be possible to map data from the Parse JSON module to other modules in your ﻿.
3
Manually run the ﻿. The Parse JSON module will identify the JSON structure from your provided JSON.
4
You can now connect the modules that follow. The items from the Parse JSON module will now be available for mapping.
Collection vs. Array
JSON string field can contain a collection.
Text
{ ... }
{ "name" : "Peter", "ID" : 1}
{ ... }
{ "name" : "Peter", "ID" : 1}
﻿
In which case, the output will be a single bundle containing the items of the collection:
Or it can contain an array.
Text
[ ... ]
:
[ { "name" : "Peter", "ID" : 1 }, { "name" : "Mike", "ID" : 2 }]
[ ... ]
:
[ { "name" : "Peter", "ID" : 1 }, { "name" : "Mike", "ID" : 2 }]
﻿
In which case the output will be a series of bundles, each bundle containing one array's item.
﻿﻿ allows you to use the data from the existing module to test your ﻿. You can run this operation using the Parse JSON module.
1
Run the module whose output data you want to copy using the Parse JSON module.
2
Click the resulting output above the module.
3
Click Download output bundles from the dropdown menu.
A window containing the original module's output bundles in JSON format pops up.
﻿
4
Copy the window's content and click Close.
﻿
5
Insert the Tools > Parse JSON module after the original module, open its configuration, and paste the copied JSON data in Step 4 into the JSON string field.
﻿
6
Unlink the original module from the ﻿.
Do not delete the original module.
﻿
7
Execute the mock-up JSON module and use its output instead of the original module's output in your ﻿.
8
Build and test your ﻿.
Once you are done with the testing, change the mapping from the mock-up module to the original module across the whole ﻿ with the DevTool's Remap Source tool.
Put the original module back before the mock-up JSON module and remove the JSON module.
﻿
In the Remap Source section, it is not necessary to fill the Module to Edit field unless you do not want to remap all values from the original module in the whole ﻿.
Transform to JSON
Transforms any object to JSON.
Let us assume that the data records you wish to transform to JSON format are in a Google spreadsheet. Here is the procedure on how to transform the data records to JSON format:
1
Place the Google Sheets > Select rows module in your ﻿ to get the data. Set up the module to retrieve rows from your Google spreadsheet and set the Maximum number of returned rows to a small number but larger than one for testing purposes (e.g., three). Run the Google Sheets module (right-click it and choose "Run this module only") and verify its output.
2
Connect the Array Aggregator module after the Google Sheets module. In the module's setup, choose the Google Sheets module in the Source node field. Leave the other fields as they are for the moment.
3
Connect the JSON > Create JSON module after the Array Aggregator module. The module's setup requires a data structure that describes the JSON format. Click the Add button to open the Data structure setup. The easiest way to create this Data structure is to generate it automatically from a JSON sample. Click the Generator button and paste your JSON sample to the Sample data field:
Text
{ "books": [ { "id": "ID", "title": "Title", "author": "Author" } ]}
{ "books": [ { "id": "ID", "title": "Title", "author": "Author" } ]}
﻿
﻿
4
Click Save. The Specification field in the Data structure setup should now contain the generated structure.
5
Change the name of your Data structure to something more specific (e.g., "Books") and click Save. A field corresponding to the root array attribute should appear mappable in the JSON module's setup.
6
Click the Map button next to the field and map the Array[] item output from the Array aggregator module.
﻿
7
Click OK to close the JSON module's setup.
8
Open the setup of the Array Aggregator module. Change the Target structure from Custom to the JSON module's field corresponding to the root array attribute. Map items output from the Google Sheets module to the appropriate fields.
﻿
9
Click OK to close the Array Aggregator module's setup.
10
Run the ﻿. The JSON module should output the correct JSON format. Open the setup of the Google Sheets module and increase the Maximum number of returned rows number to be larger than the number of rows in your spreadsheet to process all the data. The resulting JSON can then be used as a body of an HTTP request, returned as a Webhook's response, etc.
ISO
Markdown