This tutorial shows how to create JSON files in Advanced ETL Processor. Use it when transformed data needs to be saved in a structured text format for an API, import process, or another system. JSON is fussy about commas and quotes. It has standards, apparently.
What You Will Learn
- Prepare transformed data for JSON output.
- Create a JSON file from an Advanced ETL Processor workflow.
- Use JSON functions when values need encoding or decoding.
- Check the generated file before handing it to another system.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
JSON Transformation Function Docs
This tutorial creates JSON files from transformed data. The JSON transformation functions help when fields need to be encoded, decoded, or converted before the final file is written.
Use Encode JSON String when text values contain quotes, slashes, or other characters that must be escaped. Use Encode JSON Pair, Encode JSON Object, and Encode JSON Array when building structured output from separate fields.
The same section also covers Decode JSON String, Decode JSON Object, and Decode JSON Array. These are useful when the source data already contains JSON and needs cleaning before it joins the rest of the workflow.
Related references include the JSON writer, writer targets, and JSON to XML conversion.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.