Quick and easy installation in just minutes. Combine your data automatically in the background and benefit of better insights and greater revenues.
Asana Integration
Asana data can be integrated and synchronized codeless with various external systems,
Learn on this page how the data integration of Asana is working with the Layer2 Cloud Connector by using the step-by-step screenshot tutorial and reading our important advice and frequently asked questions. Make use of the benefits and features of this data integration tool by trying it out yourself: Free Trial Registration
ASANA INTEGRATION - HOW IT WORKS
In fact, you only need to do the 5 following steps to get your Asana data integration started.
- Setup your connection as required: in this case one-way.
- Setup your data source, in this case Asana database.
- Setup your target– for example Office 365 or a SharePoint list or library.
- Setup your mapping.
- Start your project!
Asana step-by-step data integration via the Layer2 Cloud Connector
Use this step-by-step-instruction to get through the whole product and data integration configuration easily. Some steps require a copy-paste task of code snippets. Please follow the recommendations in this instruction closely.
Specific Connection String for your Asana integration
Please copy and paste this connection string and the "Select Statement" into the designated field like described
DSN=AsanaJason;
Please enter the following SQL query into the "Select Statement" as well and adjust the placeholder.
SELECT * FROM data WHERE id IS NOT NULL
Here are some good hints for your data integration
- URI: is the URL to your project, users, or the data you want to get.
- Callback URL: must be identical to your Redirect URL from the Asana app you created. Don’t forget the port.
- OAuth Client ID and Secret are the data you got from your Asana app.
- Once you are there don’t click on Test Connection. A browser should pop up and the connection should be created successfully.
- NOTE: You may restart the service Layer2 Cloud Connector Service under services.msc to see the provider in the Data Provider box from the Cloud Connector.
Benefits of using the Layer2 Cloud Connector for your Asana data integration
Known limitations and workarounds
Please take into account our
URL Issue: You must specify the URI you want to get the data from in your ODBC connection. You will only get the data from this URL. If you want other data, you may change the URL in the ODBC driver.
Some relevant URL's are:
- https://app.asana.com/api/1.0/projects/li>
- https://app.asana.com/api/1.0/users/li>
Read the Asana api documentation for more information:
- https://asana.com/developers/documentation/examples-tutorials/overview
- https://asana.com/developers/api-reference/users
Find YOUR Destination pages here
Take your next steps