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

Input Columns

Examples

SSIS

Use Asana Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Asana

Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.

Asana

Search Tasks (Advanced Filter)

Optional Parameters
Fields
Workspace Id
Text
Projects (NOT)
Projects (ALL)
Projects (ANY)
Sections (NOT)
Sections (ALL)
Sections (ANY)
Tags (NOT)
Tags (ALL)
Tags (ANY)
Assigned By (NOT)
Assigned By (ALL)
Assigned By (ANY)
Portfolios (ANY)
Teams (ANY)
Due On
Due On Before
Due On After
Due On (Null)
Start On
Start On Before
Start On After
Start On (Null)
Created On
Created On Before
Created On After
Created On (Null)
Modified On
Modified On Before
Modified On After
Modified On (Null)
Completed On
Completed On Before
Completed On After
Completed On (Null)
Due At
Due At Before
Due At After
Start At
Start At Before
Start At After
Created At
Created At Before
Created At After
Modified At
Modified At Before
Modified At After
Completed At
Completed At Before
Completed At After
Is Blocked
Is Blocking
Is Subtask
Has Attachment
Completed
Sort By
Sort Ascending
Continue On 404 Error (When record not found)	False

API Destination

API Destination - Asana

Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.

Asana

Search Tasks (Advanced Filter)

Optional Parameters
Fields
Workspace Id
Text
Projects (NOT)
Projects (ALL)
Projects (ANY)
Sections (NOT)
Sections (ALL)
Sections (ANY)
Tags (NOT)
Tags (ALL)
Tags (ANY)
Assigned By (NOT)
Assigned By (ALL)
Assigned By (ANY)
Portfolios (ANY)
Teams (ANY)
Due On
Due On Before
Due On After
Due On (Null)
Start On
Start On Before
Start On After
Start On (Null)
Created On
Created On Before
Created On After
Created On (Null)
Modified On
Modified On Before
Modified On After
Modified On (Null)
Completed On
Completed On Before
Completed On After
Completed On (Null)
Due At
Due At Before
Due At After
Start At
Start At Before
Start At After
Created At
Created At Before
Created At After
Modified At
Modified At Before
Modified At After
Completed At
Completed At Before
Completed At After
Is Blocked
Is Blocking
Is Subtask
Has Attachment
Completed
Sort By
Sort Ascending
Continue On 404 Error (When record not found)	False

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 [LS_TO_ASANA_IN_GATEWAY];