Advanced ETL Processor can automate ChatGPT-style requests by using the HTTP Action. The package action sends an HTTP request with the URL, method, headers, authentication, and JSON body, then stores or logs the response for the next package step.
What You Will Learn
- Configure an HTTP Action for an API endpoint.
- Send a JSON request body from a package.
- Set request headers and bearer authentication.
- Inspect raw response data and execution logs after the request runs.
Before You Start
Use a test API key and a small prompt first. API calls can cost money, fail because of rate limits, or return text that is technically valid and still not what you wanted.
HTTP Action Docs
The HTTP Dynamic Action documentation explains how Advanced ETL Processor sends HTTP requests from a package and receives responses from web services and APIs.
Use the Parameters tab for the values used during package execution. Use the Request tab to define request parameters, body, headers, authentication, and debugging details.
For ChatGPT-style API calls, the most relevant sections are Body, Headers, and Authentication. Bearer authentication is normally the pattern used for token-based APIs.
Use the Variables tab when later package steps need values from the request or response. After running the request, check the Execution log tab, Response Headers, and Raw Response.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.