Illustrated in the below image is a flow where the JSON Sax Reader step is used to filter from large data sets. The Super Mapper step is used to link source fields to the required destination fields. A Buffer destination step to store the data in.
Adding a JSON Sax Reader Step
To add a JSON Sax Reader step in a flow, follow the below 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 Sax as shown in the image below.
Configuring a JSON Sax Reader Step
Illustrated in the below image is the configuration that is available in the JSON Sax Reader step.
String Encoding Field – Synatic currently only applies the UTF8 encoding. This cannot be changed.
For more information on UTF8, click on the link below.
Filter Field– The field to filter the data on.
Expect Once Checkbox – This will set the filter to appear at least once when the checkbox is selected. The checkbox is not selected by default when the JSON Sax Reader step is added.
Using a JSON Sax Reader step
To use a JSON Sax Reader step, follow the instructions below:
1. Click on the play button on the JSON Sax step as highlighted in the image below:
2. Click the highlighted are in the image below to upload a file.
3. Click the Test button as shown in the image below.