SQL examples for ODBC
The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Asana.
- Download attachment to local disk
- Download multiple attachments to local disk
- List first-level subtasks (default project)
- List first-level subtasks for a project
- List memberships for a portfolio
- List memberships for a project
- List portfolios by owner
- List portfolios by owner and workspace
- List project goals
- List projects
- List subtasks for a parent task
- List tasks (default project)
- List tasks for a project
- List team goals
- List time entries for a task
- List workspace goals
- List workspace tasks (all projects)
- List workspaces
- Search tasks (advanced filters)