Enrich a CSV with data from a JSON API
Add columns to a spreadsheet by calling a JSON API once per row. This example looks up the city, state and coordinates of postal codes from a public API and keeps only the fields you name, but the same setup works with any REST API: put {{column}} in the URL, map response fields to output columns, and export the result as CSV or Excel.
Input
Output fields
Sign up on Apify or log in
The Bulk HTTP Requests — API Calls for Clay, n8n, CSV & Datasets Actor is ready to run with the inputs already set for "Enrich a CSV with data from a JSON API". Sign up or log in and you'll land in Apify Console with a copy of this exact task.
Start the "Enrich a CSV with data from a JSON API" task
The Bulk HTTP Requests — API Calls for Clay, n8n, CSV & Datasets Actor will start running based on the input automatically. You can also change all the input fields, like URL template, method, and more, to match your specific use case.
Receive the "Enrich a CSV with data from a JSON API" output
Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as #, method, URL, and more.
Integrate into your workflow
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Enrich a CSV with data from a JSON API" task via API.
