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

[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…