This tutorial shows how to create complex JSON objects in Advanced ETL Processor using Transformation steps. The example prepares structured data for submission to the Luminovo API endpoint, where commas, quotes, arrays, and nested objects all need to behave themselves. JSON is excellent until it starts nesting like Russian dolls.
What You Will Learn
- Prepare source data for complex JSON output.
- Use Transformation steps to build nested JSON objects.
- Format the generated payload for the Luminovo API endpoint.
- Check the final JSON before submitting it to an API.
Before You Start
Use sample data and a test API endpoint first. Production APIs are not the place to discover that one bracket has gone on holiday.
Prepare JSON For The Luminovo API Endpoint
This example prepares data for submission to the Luminovo API endpoint. The important part is not only creating valid JSON, but creating JSON that matches the receiving API structure.
Use this pattern when a destination API expects nested objects, arrays, calculated values, or fields assembled from several source columns. The Transformation stage gives you a controlled place to build that payload before the workflow sends it onward.
Related JSON And Transformation Documentation
For the building blocks, review the JSON transformation functions, including Encode JSON Object, Encode JSON Array, and Encode JSON Pair.
For sending the prepared payload, use the HTTP action. The request body, headers, authentication, and debugging views matter when an API rejects a request with the traditional developer-friendly message: something went wrong.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.