This tutorial shows how to submit JSON to a web API from an Advanced ETL Processor package. Use it when ETL output must be pushed into another system instead of written only to a file or database. APIs are picky about request format, which is their way of keeping us humble.
What You Will Learn
- Prepare JSON output for an API request.
- Submit JSON data to a web API endpoint.
- Use API submission inside a repeatable workflow.
- Connect file, transformation, and API steps.
Before You Start
Have a test API endpoint ready before building the workflow. Production APIs are not the best place to discover that a comma is missing.
HTTP Action Docs
This tutorial uses the HTTP action to send JSON to a Web API endpoint. In practice, check the URL, method, request body, headers, and authentication before putting the package on a schedule.
The HTTP Action docs cover the request tab, including request body, headers, and authentication. For JSON submissions, the body and `Content-Type` header usually decide whether the API accepts the request or gives you a deeply unhelpful error message.
Use HTTP request debugging, response headers, and the raw response view while testing. The variables tab is useful when later package steps need values returned by the API.
Related package references include debugging actions, working with variables, and dynamic package actions.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.