Asana Connector

ZappySys Asana Connector provide read / write capability inside your app (see list below), using these drag and drop , high performance connector you can perform many Asana operations without any coding. You can use this connector to integrate Asana data inside apps like SSIS, SQL Server or popular ETL Platforms / BI Tools/ Reporting Apps / Programming languages (i.e. Informatica, Power BI, SSRS, Excel, C#, JAVA, Python)

Download for SSIS Download for Other Apps Documentation

Click on your App below to get started with Asana Integration

Choose your App / Scenario for which you like to integrate Asana

SSIS

SQL Server

Power BI

SSRS

Informatica

MS Access

MS Excel

SSAS

Python

JAVA

Tableau

SAP Crystal Reports

Azure Data Factory (Pipeline)

Azure Data Factory (SSIS)

Talend Studio

UiPath

PowerShell

ODBC

Actions supported by Asana Connector

Asana Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.

Get Workspaces

[Read more...]

Get Workspace (Single)

[Read more...]

Parameter	Description
Workspace Id

Get Projects

[Read more...]

Parameter	Description
Workspace Id
Team Id

Get Project (Single)

[Read more...]

Parameter	Description
Project Id

Get Tasks

[Read more...]

Parameter

Description

QueryBy

Option	Value
project	project
tag	tag
section	section
user_task_list	user_task_list
assignee_and_workspace	assignee_and_workspace

Project Id

The project to filter tasks on.

Workspace Id

The workspace to filter tasks on. Note: If you specify workspace, you must also specify the assignee to filter on.

Assignee Id

The assignee to filter tasks on. If searching for unassigned tasks, assignee.any = null can be specified. Note: If you specify assignee, you must also specify the workspace to filter on.

Section Id

The section to filter tasks on.

Tag Id

UserTaskListId

Completed Since

Only return tasks that are either incomplete or that have been completed since this time.

Option	Value
2023-12-31	2023-12-31
2023-12-31T00:00:00	2023-12-31T00:00:00
now	now
now-24h	now-24h
today	today
yesterday	yesterday
yearstart-10y	yearstart-10y
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
monthend+1d-1y	monthend+1d-1y

Modified Since

Only return tasks that have been modified since the given time. Note: A task is considered “modified” if any of its properties change, or associations between it and other objects are modified (e.g. a task being added to a project). A task is not considered modified just because another object it is associated with (e.g. a subtask) is modified. Actions that count as modifying the task include assigning, renaming, completing, and adding stories.

Option	Value
2023-12-31	2023-12-31
2023-12-31T00:00:00	2023-12-31T00:00:00
now	now
now-24h	now-24h
today	today
yesterday	yesterday
yearstart-10y	yearstart-10y
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
monthend+1d-1y	monthend+1d-1y

Get Task (Single)

[Read more...]

Parameter	Description
TaskId

Get Workspace Teams

Returns records for all teams in the workspace visible to the authorized user. [Read more...]

Parameter	Description
Workspace Id

Get Project Sections

[Read more...]

Parameter	Description
Project Id

Get Project Section

[Read more...]

Parameter	Description
Project Id
Section Id

Get Users

[Read more...]

Get User (Single)

[Read more...]

Parameter	Description
User Id

Get Allocations

[Read more...]

Parameter	Description
Workspace Id
Project Id
User Id

Get Attachments

There are three possible parent values for this request: project, project_brief, and task. For a project, an attachment refers to a file uploaded to the [Key resources] section in the project Overview. For a project brief, an attachment refers to inline files in the project brief itself. For a task, an attachment refers to a file directly associated to that task. Note that within the Asana app, inline images in the task description do not appear in the index of image thumbnails nor as stories in the task. However, requests made to GET /attachments for a task will return all of the images in the task, including inline images. [Read more...]

Parameter	Description
Parent Id (e.g. Id of Project, Task or ProjectBrief)	Globally unique identifier for object to fetch statuses from. Must be a GID for a project, project_brief, or task.

Download Attachment

Download a specific attachment by Id. [Read more...]

Parameter

Description

Attachment ID

The attachment Id for the attachment to get.

Fields

Option	Value
name	name
resource_subtype	resource_subtype
connected_to_app	connected_to_app
created_at	created_at
download_url	download_url
host	host
parent	parent
parent.name	parent.name
parent.resource_subtype	parent.resource_subtype
permanent_url	permanent_url
size	size
view_url	view_url

Download Multiple Attachments

Download Multiple Attachments for a specified parent.There are three possible parent values for this request: project, project_brief, and task. For a project, an attachment refers to a file uploaded to the [Key resources] section in the project Overview. For a project brief, an attachment refers to inline files in the project brief itself. For a task, an attachment refers to a file directly associated to that task. Note that within the Asana app, inline images in the task description do not appear in the index of image thumbnails nor as stories in the task. However, requests made to GET /attachments for a task will return all of the images in the task, including inline images. [Read more...]

Parameter

Description

Parent Id (e.g. Id of Project, Task or ProjectBrief)

Globally unique identifier for object to fetch statuses from. Must be a GID for a project, project_brief, or task.

OverwriteFile

Option	Value
True	True
False	False

SaveFolder

Specify a disk folder path to save file(s) to

Fields

Option	Value
name	name
resource_subtype	resource_subtype
connected_to_app	connected_to_app
created_at	created_at
download_url	download_url
host	host
parent	parent
parent.name	parent.name
parent.resource_subtype	parent.resource_subtype
permanent_url	permanent_url
size	size
view_url	view_url

Get Portfolios

[Read more...]

Parameter	Description
Workspace Id
Owner Id

Get Goals

[Read more...]

Parameter

Description

Workspace Id

Project Id

Portfolio Id

Team Id

Is Workspace Level

Option	Value
true	true
false	false

Time Periods (e.g. Id1,Id2)

Get Workspace Custom Fields

[Read more...]

Parameter	Description
Workspace Id

Get Project Custom Fields

[Read more...]

Parameter	Description
Project Id

Get Portfolio Custom Fields

[Read more...]

Parameter	Description
Portfolio Id

Get User Task Lists

[Read more...]

Parameter	Description
User Id
Workspace Id

Get Memberships

[Read more...]

Parameter	Description
Project Id
PortfolioId
GoalId
Member or Team Id (Use with Project OR Portfolio OR Goal)

Get Tags

[Read more...]

Get Time Tracking Entries

[Read more...]

Parameter	Description
Task Id

Generic Request

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL. [Read more...]

Parameter	Description
Url	API URL goes here. You can enter full URL or Partial URL relative to Base URL. If it is full URL then domain name must be part of ServiceURL or part of TrustedDomains
Body	Request Body content goes here
IsMultiPart	Set this option if you want to upload file(s) (i.e. POST RAW file data) or send data using Multi-Part encoding method (i.e. Content-Type: multipart/form-data). Multi-Part request allows you to mix key/value and upload files in same request. On the other hand raw upload allows only single file upload (without any key/value) ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload single file in raw mode check this option and specify full file path starting with @ sign in the Body (e.g. @c:\data\myfile.zip ) ==== Form-Data / Multipart Upload (Content-Type: multipart/form-data) ===== To treat your Request data as multi part fields you must specify key/value pairs separated by new lines into RequestData field (i.e. Body). Each key value pair is entered on new-line and key/value are separated using equal sign (=). Preceding and trailing spaces are ignored also blank lines are ignored. If field value has some any special character(s) then use escape sequence (e.g. For NewLine: \r\n, For Tab: \t, For at (@): \@). When value of any field starts with at sign (@) its automatically treated as File you want to upload. By default file content type is determined based on extension however you can supply content type manually for any field using this way [ YourFileFieldName.Content-Type=some-content-type ]. By default File Upload Field always includes Content-Type in the request (non file fields do not have content-type by default unless you supply manually). For some reason if you dont want to use Content-Type header in your request then supply blank Content-Type to exclude this header altogather [e.g. SomeFieldName.Content-Type= ]. In below example we have supplied Content-Type for file2 and SomeField1, all other fields are using default content-type. See below Example of uploading multiple files along with additional fields. If some API requires you to pass Content-Type: multipart/form-data rather than multipart/form-data then manually set Request Header => Content-Type: multipart/mixed (it must starts with multipart/ else will be ignored). file1=@c:\data\Myfile1.txt file2=@c:\data\Myfile2.json file2.Content-Type=application/json SomeField1=aaaaaaa SomeField1.Content-Type=text/plain SomeField2=12345 SomeFieldWithNewLineAndTab=This is line1\r\nThis is line2\r\nThis is \ttab \ttab \ttab SomeFieldStartingWithAtSign=\@MyTwitterHandle
Filter	Enter filter to extract array from response. Example: $.rows[] --OR-- $.customers[].orders[*]. Check your response document and find out hierarchy you like to extract
Headers	Headers for Request. To enter multiple headers use double pipe or new line after each {header-name}:{value} pair

Asana Connector Examples (For ODBC PowerPack)

This page offers a collection of SQL examples designed for seamless integration with the ZappySys API ODBC Driver under ODBC Data Source (36/64) or ZappySys Data Gateway, enhancing your ability to connect and interact with Prebuilt Connectors effectively.

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

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)

Download for SSIS Download for Other Apps