The JSON Reader step instructs Synatic to process the incoming data in JSON notation. The image below shows a flow where the JSON Reader step is used.
Adding a JSON Reader Step
To use a JSON reader step in your flow, follow these instructions:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for a reader step to pull out the source data. Click on the Reader tab and select JSON as shown in the image below.
Configuring the JSON step
The JSON reader step is generally used with the current configuration. However, there are a few settings can be applied, if necessary.
String Encoding
Synatic currently only applies the UTF8 encoding. This cannot be changed.
For more information on UTF8, click on the link below.
Buffer Checkbox
Select this option to buffer the response before reading the data from the source. This will enforce that all the data comes in first and then process the entire batch.
Path (Force Buffer)
Add the path of the buffer to force Synatic to use the Buffer. If there is a path in a record that is not JSON, this option will transform the inputted path to JSON.
Using a JSON Reader Step
1. Uploading Data
This example shows how to use the JSON Reader step by uploading data.
The image below shows data that will be processed by the JSON Reader Step. This is a Text file stored on a local machine.
To view the data returning from the JSON Reader step, follow the below steps:
1. Click on the play button on the JSON reader step as highlighted in the image below:
2. Click the outlined area in the image below to upload an existing file OR type the JSON code in the area shown below. If a file is uploaded, the option to type will not become unavailable.
3. Click the Test button as shown in the image below.
Illustrated in the below page is the output of the data after it has been processed by the JSON Reader Step.
2. Retrieving Data
This example shows how to use the JSON Reader step by retrieving data.
In the image below, the JSON reader step is used to read data coming from an HTTP Service Source step and stored in a Buffer destination step.
To process data using the JSON Reader step, follow the instructions below:
1. Click on the play button on the JSON step as highlighted in the above image.
2. Click the Test button as shown on the page below.
Illustrated in the image below shows the data after it has been processed by the JSON Reader Step.
