Automate Datasette
HumDay reads Datasette’s own published API description and derives 1 operations from it. Describe the outcome you want in plain words — you get a program that is written, proven on real data, and run for you.
What Datasette is
Execute SQL queries against a Datasette database and return the results as JSON
API host: datasette.local
What HumDay can read from Datasette
These are the operations a schedule or a trigger can watch.
- GETExecute a SQLite SQL query against the content database
/content.json
How automating Datasette works
- Describe the outcome. Say what you want to happen, in your own words. No node graphs, no field mapping.
- Approve the contract. HumDay writes down exactly what it will do, what it will touch, and what it will never do. You approve it before anything is built.
- See it proven. The program runs and shows you the result before it is allowed near your live Datasette account.
- Grant access, then go live. You approve the specific Datasette operations it may use — and only those.
Automate Datasette with these
- OData for namespace microsoft.graph11412 operations
- GitHub811 operations
- Atlassian The Jira Cloud platform474 operations
- Gitlab358 operations
- JIRA 7.6.1324 operations
- Appcenter App Center Client323 operations
- Gitea .321 operations
- Bitbucket292 operations
- Keycloak Admin281 operations
- Apple App Store Connect251 operations
- Files.com222 operations
- Vmware vRealize Network Insight Reference161 operations
Categories
Questions about Datasette automation
- Can HumDay connect to Datasette?
- Yes. HumDay reads Datasette's own published API description and derives the operations from it, so there is no hand-built connector to wait for. 1 operations are documented.
- Do I need to write code to automate Datasette?
- No. You describe the outcome you want in plain words. HumDay agrees a contract with you, writes the program, and shows you a test run before anything touches your Datasette account.
- What can HumDay do in Datasette?
- 0 of the 1 documented operations change something in Datasette, and 1 read from it. HumDay only ever uses the specific operations your approved contract needs.
- Is my Datasette account safe?
- Your credentials are stored encrypted and are never shown in chat, code, or logs. Every run is limited to the operations you explicitly approved, and anything that writes to Datasette is held behind that approval.
Where this came from
The operations above are read from a published API description for Datasette at datasette.io/-/chatgpt-openapi-schema.yml. Descriptions are the provider’s own words, not ours. Last published 2023-04-01.