ToDo
Query and create to-do items.
Select
The 本製品 will use the Garoon API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- Id supports the '=' operator and is required for querying.
For example, the following query is processed server side:
SELECT * FROM ToDo WHERE Id = 3
Insert
To create a ToDo item, you must specify the Subject field.
INSERT INTO ToDo (Subject) VALUES ('New task')
ToDo with category, due date, priority, and notes:
INSERT INTO ToDo (Subject, CategoryId, DueDate, Priority, Notes) VALUES ('New task', 1, '2026-12-31T17:00:00Z', 2, 'Follow up before EOY')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | True |
ID of the to-do item. |
| Status | String | True |
Status of the to-do. One of: Completed, Uncompleted. |
| CategoryId | Int | False |
ID of the category. |
| Subject | String | False |
Subject of the to-do item. |
| HasDueDate | Boolean | True |
Whether a due date is set. |
| DueDate | Datetime | False |
Due date of the to-do item. |
| Priority | Int | False |
Priority of the to-do item. One of: 1, 2, 3. |
| Notes | String | False |
Notes for the to-do item. |