Example
Restaurant menu: from CSV to API
Update the menu on the website, ordering screen and app at once.
In short
Use 5 columns with "item_id" as the key column and dish as searchable fields; upload the CSV, check the inferred types, create an API key and query rows over HTTPS.
Example CSV
item_id,dish,price,allergens,available
M7,"Slow-roasted lamb",24,milk,true
Columns and types
| Column | Type | Example |
|---|---|---|
| item_id | text | M7 |
| dish | text | Slow-roasted lamb |
| price | number | 24 |
| allergens | text | milk |
| available | boolean | true |
Key column: item_id (unique per row). Searchable: dish.
Example query
GET /v1/data/datasets/{id}/records?filter[available]=true
Authorization: Bearer <your API key>
Your dataset page shows the exact URL.
Step by step
- Upload. Restaurant menu CSV.
- Schema. Key: item_id.
- Query. Create a key, call it.
Questions and answers
How do I refresh the restaurant menu?
Upload the new file to the same dataset.
Who can read the restaurant menu API?
Only callers with a key you created.