Example
Warehouse inventory: from CSV to API
Let a picking app or partner check stock by SKU without database access.
In short
Use 5 columns with "location" as the key column and sku as searchable fields; upload the CSV, check the inferred types, create an API key and query rows over HTTPS.
Example CSV
location,sku,qty,updated,warehouse
A-03-2,ABC-001,40,2026-11-16T18:00,North
Columns and types
| Column | Type | Example |
|---|---|---|
| location | text | A-03-2 |
| sku | text | ABC-001 |
| qty | number | 40 |
| updated | datetime | 2026-11-16T18:00 |
| warehouse | text | North |
Key column: location (unique per row). Searchable: sku.
Example query
GET /v1/data/datasets/{id}/records?filter[sku]=ABC-001
Authorization: Bearer <your API key>
Your dataset page shows the exact URL.
Step by step
- Upload. Warehouse inventory CSV.
- Schema. Key: location.
- Query. Create a key, call it.
Questions and answers
How do I refresh the warehouse inventory?
Upload the new file to the same dataset.
Who can read the warehouse inventory API?
Only callers with a key you created.