Asana Connector for Azure Data Factory (SSIS) : Get workspace (single)

Name: SSIS PowerPack
Rating: 4.8 (107 reviews)
Author: ZappySys

Integrate Azure Data Factory (SSIS) and Asana

Learn how to get workspace (single) using the Asana Connector for Azure Data Factory (SSIS). This connector enables you to read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required. We'll walk you through the exact setup.

Let's dive in!

Asana Connector

Powering this integration

Low-code / No-code
High performance
Bidirectional
Easy to use

Built on the ZappySys API Connector Framework, the Asana Connector for SSIS is a high-performance, low-code / no-code solution. It enables you to read and write Asana data without any programming right in your SSIS package. Part of the SSIS PowerPack.

Documentation

Prerequisites

Before we begin, make sure the following prerequisites are met:

SSIS designer installed. Sometimes it is referred as BIDS or SSDT (download it from Microsoft).
Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.
SSIS PowerPack is installed (if you are new to SSIS PowerPack, then get started!).

Get workspace in SSIS

Open Visual Studio and click Create a new project.
Select Integration Services Project. Enter a name and location for your project, then click OK.
From the SSIS Toolbox, drag and drop a Data Flow Task onto the Control Flow surface, and double-click it:
Make sure you are in the Data Flow Task designer:
From the SSIS toolbox drag and API Source (Predefined Templates) on the data flow designer surface, and double click on it to edit it:
Select New Connection to create a new connection:
Use a preinstalled Asana Connector from Popular Connector List or press Search Online radio button to download Asana Connector. Once downloaded simply use it in the configuration:

Asana

Select your authentication scenario below to expand connection configuration steps to:

Configure the authentication in Asana.
Enter those details into the API Connection Manager configuration.

Personal Access Token

Asana authentication

Here is how to obtain a Personal Access Token (PAT) in Asana:

Open My apps in Asana portal and click Create new token button:
Once a popup opens, name your new token:
Then click Copy button to copy the token:
Now go to SSIS package or ODBC data source and use this token in Personal Access Token authentication configuration.
Choose Default Workspace and Default Project to work with.
Click Test Connection to confirm the connection is working.
Done! Now you are ready to use Asana Connector!

API Connection Manager configuration

Just perform these simple steps to finish authentication configuration:

Set Authentication Type to Personal Access Token [Http]
Optional step. Modify API Base URL if needed (in most cases default will work).
Fill in all the required parameters and set optional parameters if needed.
Finally, hit OK button:

Asana

Personal Access Token [Http]

https://app.asana.com/api/1.0

Required Parameters
Enter Token (Personal Access Token - PAT)	Fill-in the parameter...
Default Workspace	Fill-in the parameter...
Default Project	Fill-in the parameter...
Optional Parameters
RetryMode	RetryWhenStatusCodeMatch
RetryStatusCodeList	429
RetryCountMax	5
RetryMultiplyWaitTime	True

Find full details in the Asana Connector authentication reference.

OAuth app

Asana authentication

Here is how to register an OAuth app in Asana:

Open My apps in Asana portal and click Create new app button:
Once a popup opens, name your app and check two options, and click Create app button:
Then copy Client ID and Client secret and save them in a file (we will need them for authentication):
Continue by selecting OAuth menu item on your left and click Add redirect URL button (you can have your own or use https://zappysys.com/oauth):
Proceed by clicking on the Manage distribution section on your left.
Then specify workspaces your app needs to access (use Any workspace to access them all):
Once you do that, click Save changes button.
Now go to SSIS package or ODBC data source and use Client ID, Client Secret, and Redirect URL in OAuth app authentication configuration.
When you are done with that, click Generate Token button to generate Access and Refresh Tokens.
Choose Default Workspace and Default Project to work with.
Click Test Connection to confirm the connection is working.
Done! Now you are ready to use Asana Connector!

API Connection Manager configuration

Just perform these simple steps to finish authentication configuration:

Set Authentication Type to OAuth app [OAuth]
Optional step. Modify API Base URL if needed (in most cases default will work).
Fill in all the required parameters and set optional parameters if needed.
Press Generate Token button to generate the tokens.
Finally, hit OK button:

Asana

OAuth app [OAuth]

https://app.asana.com/api/1.0

Required Parameters
ClientId	Fill-in the parameter...
Client Secret	Fill-in the parameter...
Default Workspace ( Select after Token is generated )	Fill-in the parameter...
Default Project ( Select after Token is generated )	Fill-in the parameter...
Optional Parameters
Permissions	default
Redirect URL	https://zappysys.com/oauth
RetryMode	RetryWhenStatusCodeMatch
RetryStatusCodeList	429
RetryCountMax	5
RetryMultiplyWaitTime	True

Find full details in the Asana Connector authentication reference.

Select Workspaces table from the dropdown and hit Preview Data:

API Source - Asana

Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.

Asana

Workspaces

Required Parameters
Workspace Id	Fill-in the parameter...
Optional Parameters
Continue On 404 Error (When record not found)	False

SSIS API Source - Read from table or endpoint

That's it! We are done! Just in a few clicks we configured the call to Asana using Asana Connector.

You can load the source data into your desired destination using the Upsert Destination , which supports SQL Server, PostgreSQL, and Amazon Redshift. We also offer other destinations such as CSV , Excel , Azure Table , Salesforce , and more . You can check out our SSIS PowerPack Tasks and components for more options. (*loaded in Trash Destination)

Deploy SSIS package to Azure Data Factory (ADF)

Once your SSIS package is complete, deploy it to the Azure-SSIS runtime within Azure Data Factory. The setup process requires you to upload the SSIS PowerPack installer to Azure Blob Storage and then customize the runtime configuration using the main.cmd file. For a complete walkthrough of these steps, see our detailed guide on the Azure Data Factory (SSIS) and Asana integration.

Conclusion

And there you have it — a complete guide on how to get workspace (single) in Azure Data Factory (SSIS) without writing complex code. All of this was powered by Asana Connector, which handled the REST API pagination and authentication for us automatically.

Download the trial now or ping us via chat if you have any questions or are looking for a specific feature (you can also reach out to us by submitting a ticket):

Download Chat

More actions supported by Asana Connector

Got another use case in mind? We've documented the exact setups for a variety of essential Asana operations directly in Azure Data Factory (SSIS), so you can skip the trial and error. Find your next step-by-step guide below: