Reading Evenfs and Members lists using API v1
Hello.
THe reason I'm asking about this is that I need to retrieve data from Events and Members lists into a MS Access database. As per what I've read
in another post, API v2 returns data in Json only, and Access VBA doesn't have adequate tools for processing Json lists. But when I try to read events information from my application (similar way I read the Contacts list), I get the error message "Forbidden".
If it's not possible to access this data using API v1, can anyone please send the piece of code for authenticating and further reading data using API v2 from Access VBA?
While API v1 is still supported, all new features are added to later versions only.
-
Hi Dragan,
Actually API v2 supports both JSON and XML formats. The main challenge while working from API v2 from VBA is to obtain security token. So if you are able to manually parse server response with oauth token, then you can use it to access API v2.
Dmitry,
API and mobile developer at WildApricot