EndPoint Search Tasks (Advanced Filter)
Name
search_tasks
Description
Search tasks with in a specified workspace (or default workspace) using advanced server side filters.
Parameters
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| ActualTimeMinutes |
DT_I4
|
int
|
False |
||
| ApprovalStatus |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| AssigneeStatus |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Completed |
DT_BOOL
|
bit
|
False |
||
| CompletedAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| CompletedById |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| CompletedByName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| CreatedAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| CreatedById |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| CreatedByName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Dependencies |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| Dependents |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| Subtasks |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
| DueAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| DueOn |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| ExternalData |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
| ExternalId |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Hearted |
DT_BOOL
|
bit
|
False |
||
| Hearts |
DT_WSTR
|
nvarchar(1000)
|
1000 | False |
|
| HtmlNotes |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
| IsRenderedAsSeparator |
DT_BOOL
|
bit
|
False |
||
| Liked |
DT_BOOL
|
bit
|
False |
||
| Likes |
DT_WSTR
|
nvarchar(1000)
|
1000 | False |
|
| Memberships |
DT_WSTR
|
nvarchar(1000)
|
1000 | False |
|
| ModifiedAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| Notes |
DT_WSTR
|
nvarchar(2000)
|
2000 | False |
|
| NumHearts |
DT_I4
|
int
|
False |
||
| NumLikes |
DT_I4
|
int
|
False |
||
| NumSubtasks |
DT_I4
|
int
|
False |
||
| ResourceSubtype |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| StartAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| StartOn |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| AssigneeId |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| AssigneeName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| AssigneeSectionId |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| AssigneeSectionName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| CustomFields |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
| Followers |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| ParentId |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| ParentName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| ParentCreatedBy |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| ParentResourceSubtype |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| PermalinkUrl |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| Projects |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| Projects1Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Projects1Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Projects2Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Projects2Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Projects3Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Projects3Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Tags |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| Tags1Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Tags1Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Tags2Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Tags2Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Tags3Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Tags3Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Tags4Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Tags4Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| Tags5Id |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| Tags5Name |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| WorkspaceId |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| WorkspaceName |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
| [Dynamic Column] |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Asana Connector in API Source component to read data or in API Destination component to read/write data:
Search Tasks (Advanced Filter) using API Source
Asana
Search Tasks (Advanced Filter)
Search Tasks (Advanced Filter) using API Destination
Asana
Search Tasks (Advanced Filter)
ODBC application
Use these SQL queries in your ODBC application data source:
Search Tasks (Advanced Filters - Just like Asana Search UI)
--//search text in task title or description
SELECT * FROM search_tasks WITH(Text='Hotfix')
--//search text in all tasks from any projects listed below
SELECT * FROM search_tasks WITH(Text='Hotfix', ProjectsAny='1200652735638082,1206028542305053')
--//list all tasks from any projects listed below
SELECT * FROM search_tasks WITH(Text='Hotfix', ProjectsAny='1200652735638082,1206028542305053')
--//list all tasks due on specified date (same way you can use CreatedOn, CompletedOn ...)
SELECT * FROM search_tasks WITH(DueOn='2024-12-21')
--//list all tasks with due date after specified date (same way you can use CreatedOnAfter, CompletedOnAfter ...)
SELECT * FROM search_tasks WITH(DueOnAfter='2024-12-21')
SELECT * FROM search_tasks WITH(DueOnAfter='yearstart+1d')
--//list all tasks with due date after specified date (same way you can use CreatedOnBefore, CompletedOnBefore ...)
SELECT * FROM search_tasks WITH(DueOnBefore='2024-12-21')
SELECT * FROM search_tasks WITH(DueOnBefore='monthstart-5d')
--//list all tasks with due date after specified datetime (same way you can use CreatedAtBefore, CompletedAtBefore ...)
SELECT * FROM search_tasks WITH(DueAtBefore='2024-12-21T23:59:59')
SELECT * FROM search_tasks WITH(DueAtBefore='now-10h')
--//list all tasks with attachment
SELECT * FROM search_tasks WITH(HasAttachment='true')SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Search Tasks (Advanced Filters - Just like Asana Search UI)
DECLARE @MyQuery NVARCHAR(MAX) = '--//search text in task title or description
SELECT * FROM search_tasks WITH(Text=''Hotfix'')
--//search text in all tasks from any projects listed below
SELECT * FROM search_tasks WITH(Text=''Hotfix'', ProjectsAny=''1200652735638082,1206028542305053'')
--//list all tasks from any projects listed below
SELECT * FROM search_tasks WITH(Text=''Hotfix'', ProjectsAny=''1200652735638082,1206028542305053'')
--//list all tasks due on specified date (same way you can use CreatedOn, CompletedOn ...)
SELECT * FROM search_tasks WITH(DueOn=''2024-12-21'')
--//list all tasks with due date after specified date (same way you can use CreatedOnAfter, CompletedOnAfter ...)
SELECT * FROM search_tasks WITH(DueOnAfter=''2024-12-21'')
SELECT * FROM search_tasks WITH(DueOnAfter=''yearstart+1d'')
--//list all tasks with due date after specified date (same way you can use CreatedOnBefore, CompletedOnBefore ...)
SELECT * FROM search_tasks WITH(DueOnBefore=''2024-12-21'')
SELECT * FROM search_tasks WITH(DueOnBefore=''monthstart-5d'')
--//list all tasks with due date after specified datetime (same way you can use CreatedAtBefore, CompletedAtBefore ...)
SELECT * FROM search_tasks WITH(DueAtBefore=''2024-12-21T23:59:59'')
SELECT * FROM search_tasks WITH(DueAtBefore=''now-10h'')
--//list all tasks with attachment
SELECT * FROM search_tasks WITH(HasAttachment=''true'')';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_ASANA_IN_DATA_GATEWAY];