Example
Member directory: from CSV to API
Run a searchable directory of businesses who agreed to be listed.
In short
Use 5 columns with "member_id" as the key column and business, category as searchable fields; upload the CSV, check the inferred types, create an API key and query rows over HTTPS.
Example CSV
member_id,business,category,website,city
D-88,"Fernhill Supply",Wholesale,https://example.com,"Example City"
Columns and types
| Column | Type | Example |
|---|---|---|
| member_id | text | D-88 |
| business | text | Fernhill Supply |
| category | text | Wholesale |
| website | text | https://example.com |
| city | text | Example City |
Key column: member_id (unique per row). Searchable: business, category.
Example query
GET /v1/data/datasets/{id}/records?filter[category]=Wholesale
Authorization: Bearer <your API key>
Your dataset page shows the exact URL.
Step by step
- Upload. Member directory CSV.
- Schema. Key: member_id.
- Query. Create a key, call it.
Questions and answers
How do I refresh the member directory?
Upload the new file to the same dataset.
Who can read the member directory API?
Only callers with a key you created.