I am looking for the ability to pull Asana data points and/or full tables into Excel. I have hit the Asana CSV export size limit, so it is slowing messing up my exports.
I am not familiar with JSON but am willing to learn if that is what it takes. I can code VBA. Would prefer to link the table / I don’t need to update Asana, only need it to flow one way.
@Kimberly_Dalen and welcome to the forum,
If you’re open to using a 3rd party tool, I would look at something like Unito for this purpose.
The Asana API is not the easiest to work with if you’ve not done API-type work previously; having said that, take a look at this thread for some relevant info and code that might get you on your way:
I have been writing code in VBA to get data from Asana for a couple weeks now. Below is the code for how I have been getting data from Asana:
I am transitioning to a point where I need to be able to create projects and tasks in Asana from my code in VBA. I know I will have to use the “POST” instead of “GET” and I assume I will have to attach some JSON code as well in my request. I was wondering if someone knew the syntax I would need to use in VBA to create a project/task? Thanks for a…
I’ll take a look. As an organization we actually are looking at Unito - the only issue being it requires you to save the Excel file in a SharePoint/OneDrive location. I am expecting to have some files in Box and do not see that as an option, so thought pulling directly would be best.
Any thoughts on this?
No further thoughts, sorry. I’m a little surprised about that limitation, but so be it.