Example
Product catalogue: from CSV to API
Show live prices and stock on a website or app without a database.
In short
Use 5 columns with "sku" as the key column and name, category as searchable fields; upload the CSV, check the inferred types, create an API key and query rows over HTTPS.
Example CSV
sku,name,price,stock,category
ABC-001,"Waxed tote",65.00,12,bags
Columns and types
| Column | Type | Example |
|---|---|---|
| sku | text | ABC-001 |
| name | text | Waxed tote |
| price | number | 65.00 |
| stock | number | 12 |
| category | text | bags |
Key column: sku (unique per row). Searchable: name, category.
Example query
GET /v1/data/datasets/{id}/records?filter[category]=bags&limit=20
Authorization: Bearer <your API key>
Your dataset page shows the exact URL.
Step by step
- Upload. Product catalogue CSV.
- Schema. Key: sku.
- Query. Create a key, call it.
Questions and answers
How do I refresh the product catalogue?
Upload the new file to the same dataset.
Who can read the product catalogue API?
Only callers with a key you created.