Asana Connector

Read Workspaces    [ Read more... ]

Read all workspaces

SELECT * FROM Workspaces

Read Projects    [ Read more... ]

Read all projects

SELECT * FROM Projects

Read Tasks (default project)    [ Read more... ]

Read all tasks (default project)

SELECT * FROM Tasks

Read Tasks for a specific project    [ Read more... ]

Read all tasks for a specified project

SELECT * FROM Tasks WITH (ProjectId='1200652735638082')

Read Sub Tasks - First Level (default project)    [ Read more... ]

Read all first level sub tasks for default project. If you sub tasks for 3rd, 4th level deep then this wont capture.

SELECT * FROM SubTasks

Read Sub Tasks - First Level for specified project    [ Read more... ]

Read all first level sub tasks for a specified project id. If you sub tasks for 3rd, 4th level deep then this wont capture.

SELECT * FROM SubTasks WITH (ProjectId='1200652735638082')

Read Sub Tasks for a specified parent task    [ Read more... ]

SELECT * FROM SubTasks  WITH(QueryBy='task', TaskId='1207150838176996')

Read Workspace Tasks (All Projects)    [ Read more... ]

SELECT * FROM WorkspaceTasks

Search Tasks (Advanced Filters - Just like Asana Search UI)    [ Read more... ]

--//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')

Download Attachment to Local Disk    [ Read more... ]

Download Attachment to Local Disk File.

SELECT * FROM download_attachment 
WITH (
   AttachmentId='1208216218258030'
 , TargetFilePath='c:\temp\1208216218258030_AWS-refund-request.png' 
 , FileOverwriteMode=0 --0=AlwaysOverwrite, 1=FailIfExists, 2=SkipIfExists
)

Download Multiple Attachments to Local Disk    [ Read more... ]

Download Multiple Attachments for a specified Parent (e.g. Task, Project, ProjectBrief) to Local Disk Folder. Saved file name syntax is {AttachmentId}_{FileName}.

SELECT * FROM download_attachments
WITH (
   ParentId='1206673375982078' --Id of Task , Project or ProjectBrief
 , SaveFolder='c:\temp' 
 , OverwriteFile=1
)

Read Portfolios for a specified Owner    [ Read more... ]

Read Portfolios for a specified Owner (Default Workspace).

SELECT * FROM Portfolios WITH(OwnerId='1200442904128317')

Read Portfolios for a specified Owner and Workspace    [ Read more... ]

Read Portfolios for a specified Owner Id and Workspace id.

SELECT * FROM Portfolios WITH(OwnerId='1200442904128317', WorkspaceId='1200442900140748')

Read Project Goals    [ Read more... ]

Read Goals for a specified Project Id.

SELECT * FROM Goals WITH(Project='1206673375982078')

Read Workspace Goals    [ Read more... ]

Read Goals for a specified Workspace Id.

SELECT * FROM Goals WITH(Workspace='1200442900140748')

Read Team Goals    [ Read more... ]

Read Goals for a specified Team Id.

SELECT * FROM Goals WITH(Team='1200442900140748')

Read Memberships for a project    [ Read more... ]

Read Memberships for a specific project.

SELECT * FROM Memberships WITH(ProjectId=1206673375982078)

Read Memberships for a project    [ Read more... ]

Read Memberships for a specific project.

SELECT * FROM Memberships WITH(PortfolioId=1206673375982077)

Read Time Entries for a Task    [ Read more... ]

Read Time Entries for a specific task.

SELECT * FROM TimeTrackingEntries WITH(TaskId=1207150837043133)