[AccessD] Calling API's from VBA

[Gustav Brock]

Hi David

Oh, right. That was another example.

/gustav

-----Oprindelig meddelelse-----
Fra: newsgrps at dalyn.co.nz <newsgrps at dalyn.co.nz> 
Sendt: 10. september 2020 08:07
Til: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Emne: RE: [AccessD] Calling API's from VBA

Thanks Gustav,

I was able to modify your code from the recent Random Number generator.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand



-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Gustav Brock via AccessD
Sent: Thursday, 10 September 2020 5:46 pm
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] Calling API's from VBA

Hi David

It depends on how data are going to be pushed. 
Is it a regular upload, a POST, or is it by extending the URL with parameters?

For the latter, you can find a lot of examples in my project
VBA.CurrencyExchange:

https://github.com/GustavBrock/VBA.CurrencyExchange

You don't mention the format of the data that will be pulled. My project demonstrates three methods.

/gustav

-----Oprindelig meddelelse-----
On Sun, Aug 9, 2020, 23:05 <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>
> I have a client that wants to be able to call a web api to push data and then call another one to pull data back again.
>
> Does anyone know of resources that can give me guidance as how to do this in Access?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand