This tutorial shows how to transform CSV data into JSON and add GUID values in Advanced ETL Processor. Use it when each output record needs a stable generated identifier before the JSON file is passed to another system. CSV rows rarely arrive with perfect identifiers. That would be suspiciously helpful.
What You Will Learn
- Read CSV data and prepare the fields for JSON output.
- Generate GUID values during the transformation.
- Write the transformed records to a JSON target.
- Choose the JSON structure expected by the receiving 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 Writer Docs
This tutorial uses the JSON writer to create JSON output from transformed CSV records. The GUID step gives each record an identifier before the writer saves the final data.
The JSON writer docs explain what JSON is and how to change writer properties. Review those settings before running the transformation, especially the target file and format options.
The examples show JSON output without a root node and with a root node. Pick the structure your next system expects. APIs and importers can be very particular about brackets, which is fair, but still annoying.
Related transformation references include Writer, Writer Targets, JSON transformation functions, and Fields Values.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.