API2 Export Invoices to Excel through VBA
I would like to export our invoices to Excel trough API, as I need country, TAX info, deleted invoices to do a proper administration.
Can someone send me an example how to connect to WA through VBA using API v2?
Carla Nagel
shared this idea
-
Dragan
commented
Hello all.
I need to retrieve events and members list from WI using Access VBA. If it's not possible through API v2, is it possible through API v1?
And question for Geoff - can you please send us the VBA code (that you used for retrieving your lists?
Thanks in advance. -
Hi Geoff,
Yes, I'm sure. You can get data from API in XML format and parse it with MSXML, but oAuth service works only with JSON.
-
Geoff Temple
commented
Dmitry, are you sure? I retrieve events and registrants with VBA referencing the MSXML2 dll.
-
Hi Carla,
API v2 requires oAuth authentication. oAuth authentication service returns data in JSON format. But VBA does not contain builtin tools to work with json.
For me it looks like VBA is not a best choice for working with API. But fortunately microsoft has a javascript API for office. It is described here https://msdn.microsoft.com/en-us/library/office/fp160953.aspx
