Todoist plugin
A plugin to explore your tasks on Todoist with SQL.
Setup
anyquery install todoist
The plugin will ask you to pass a token to authenticate with Todoist. You can create a token at https://app.todoist.com/app/settings/integrations/developer. Select the developer tab and copy the the API key. Paste it in the anyquery form.
Tables
todoist_active_tasks
List all your active tasks. The table supports insert/delete and select operations. When deleting a task, it'll close the task on Todoist.
Schema
| Column index | Column name | type |
|---|---|---|
| 0 | id | TEXT |
| 1 | assigner_id | TEXT |
| 2 | assignee_id | TEXT |
| 3 | project_id | TEXT |
| 4 | section_id | TEXT |
| 5 | parent_id | TEXT |
| 6 | order | INTEGER |
| 7 | content | TEXT |
| 8 | description | TEXT |
| 9 | is_completed | INTEGER |
| 10 | labels | TEXT |
| 11 | priority | INTEGER |
| 12 | comment_count | INTEGER |
| 13 | creator_id | TEXT |
| 14 | created_at | TEXT |
| 15 | due | TEXT |
| 16 | url | TEXT |
Caveats
- The plugin does not support updating tasks.
- The plugin does not do any caching and fetches the tasks every time you run a query. To avoid rate limiting, you can insert your tasks into a table and query that table instead. For example,
INSERT INTO my_tasks SELECT * FROM todoist_active_tasksand thenSELECT * FROM my_tasks. - The plugin is subject to the rate limits of the Todoist API (1000 requests per 15 minutes). If you hit the rate limit, you can wait for 15 minutes or use the cache method mentioned above. Therefore, you cannot insert/delete tasks more than 1000 times in 15 minutes.
- Due date resolution is only per day and not per hour. I don't have a premium account to test the exact behavior of the API. If you have a premium account and can help me test, please reach out to me.
