Pulling full Asana tables or fields into Excel through VBA or export

[Kimberly_Dalen]

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.

[Phil_Seeman]

Hi @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:

Creating project in Excel VBA

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: [image] 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…

[Kimberly_Dalen]

Thanks Phil,
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?
Thanks!
Kimberly

[Phil_Seeman]

No further thoughts, sorry. I’m a little surprised about that limitation, but so be it.