Go to example tasks
Update records by ID from a CSV or Google Sheet
Created by
Adam Pearce
Reads rows from a public CSV, Excel file or Google Sheet link and sends one PUT per row to a per-record URL built from that row's own ID, which is how most APIs do an update or upsert. Runs as a dry run against a sample public CSV so you can see the resolved URLs.
Dataset to REST API (Sync Rows to Any API)nerolabs/dataset-to-rest-api
Row
Email
Result
HTTP
+6 fieldsTextNumberBooleanListObject
Input
File URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv
Maximum input rows:5
Endpoint URL(required):https://api.example.com/v1/countries/{{ISO3166-1-Alpha-2}}
HTTP method:PUT
Request body:template
Body template (JSON)
Authentication:apiKeyHeader
Header or parameter name (API key only):X-API-Key
Dry run (plan only, send nothing):true
Output fields
Row
Email
Result
HTTP
Method
URL
Attempts
ms
Error
Response
Sign up on Apify01
Create your Apify account to access the Dataset to REST API (Sync Rows to Any API).
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
