List Tasks
task.readList tasks. For 'my tasks' / 'my open tasks' / 'what's due', call this with NO assigneeUserId — it defaults to the CURRENT authenticated user, so you never need an id. Only set assigneeUserId to look up a specific other person whose numeric userId you already have. Filter completion with state ('open' = not done, 'completed' = done) and use overdue: true for past-due, not-completed tasks. Also filterable by due-date window and sheet. limit caps the result count (default 25). Returns task objects with assigneeName, reporterName, sheetName (and their *Id FKs for follow-up tools) — prefer the *Name fields in prose.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| state | No | Completion filter via the task stage: 'open' = not completed (stage != Complete), 'completed' = done, 'all' = no filter. Omit to include all stages. | |
| overdue | No | When true, return ONLY tasks past their due date that are not completed (overdue). Overrides `state` and the due window. | |
| sheetId | No | Restrict to tasks attached to this sheet | |
| dueAfter | No | ISO datetime — tasks whose due date is after this | |
| dueBefore | No | ISO datetime — tasks whose due date is before this | |
| assigneeUserId | No | OMIT for the current user's own tasks ('my tasks', 'my open tasks') — the caller is inferred from auth. Never guess this. Only set it when the user explicitly asks about a specific OTHER person AND you already hold their numeric userId from a prior tool result. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tasks | Yes | Tasks matching the filters; prefer the *Name fields in prose, the *Id fields are FKs | |
| truncated | Yes | True when more tasks may exist than `limit` returned |