ToDos
Retrieve ToDos on Basecamp.
Table Specific Information
Select
The following are columns supported as search criteria by Basecamp:
- ProjectId
- ToDoListId
- Id
- Completed
- Remaining
- Trashed
- DueAt
- DueOn
DueAt and DueOn can be used with the '>' or'>=' operators.
The following query retrieves only completed ToDos belonging to a certain Project.
SELECT * FROM ToDos WHERE ProjectId = '11111111' AND Completed = True
The following query filters ToDos that are due since a certain date.
SELECT * FROM ToDos WHERE ProjectId = '11111111' AND DueAt > '2016-01-01'
The following query lists the remaining ToDos that belong to a ToDo list.
SELECT * FROM ToDos WHERE ProjectId = '11111111' AND ToDoListId = '123456789' AND Remaining = true
Columns
Name | Type | References | Description |
Id [KEY] | String | The unique identifier of the topic. | |
AppUrl | String | The app URL. | |
AssigneeId | String | Id of the person assigned to. | |
AssigneeName | String | Name of the person assigned to. | |
AssigneeType | String | Type of assignee. | |
CommentsCount | Integer | Number of comments on this to-do. | |
Completed | Boolean | Whether the to-do is completed. | |
Content | String | Description of the to-do. | |
CreatedAt | Datetime | The date and time when the record was created. | |
CreatorAvatarUrl | String | Creator Avatar URL. | |
CreatorFullsizeAvatarUrl | String | Creator full-size avatar URL. | |
CreatorId | String | The Id of the creator. | |
CreatorName | String | The name of the creator. | |
DueAt | Datetime | The date and time when the to-do is set due. | |
DueOn | Datetime | The date and time when the to-do is set due. | |
Position | Integer | Position number of the current to-do on the list. | |
Private | Boolean | Whether this to-do is private. | |
Remaining | Boolean | Boolean value for remaining to-dos. | |
SubscribersId | String | The Id of the subscriber. | |
SubscribersName | String | The name of the subscriber. | |
ToDoList | String | To-do list. | |
ToDoListId | String | The to-do list Id. | |
Trashed | Boolean | Boolean value for deleted to-dos. | |
UpdatedAt | Datetime | The date and time when the record was last updated. | |
URL | String | The URL of the to-do. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description | |
ProjectId | String | The Id of the Project associated with the to-do. |