Developer

Andy Brown

<div>
Note that the above requires a reference be set to one of the Microsoft XML lib's. &nbsp; That gives you the ability to do the POST/GET.<br />
<br />
&nbsp;Also might want to look at:<br />
<br />
<a href="https://github.com/VBA-tools/VBA-Web" rel="ugc">https://github.com/VBA-tools/VBA-Web</a><br />
<br />
&nbsp;Which is a utility for working with web sites.<br />
<br />
Jim.
</div>


Note that the above requires a reference be set to one of the Microsoft XML lib's.   That gives you the ability to do the POST/GET.

 Also might want to look at:

https://github.com/VBA-tools/VBA-Web [https://github.com/VBA-tools/VBA-Web]

 Which is a utility for working with web sites.

Jim.

<div>
Jim - as always - thank you. &nbsp;You've really made my life easier and as mentioned before, if you're ever in Hamburg (Germany), I owe you several beers.
</div>


Jim - as always - thank you.  You've really made my life easier and as mentioned before, if you're ever in Hamburg (Germany), I owe you several beers.

<div>
No problem and glad it helps you out.<br />
<br />
One &quot;gotcha&quot; I should have mentioned that you need to watch out for; always use POST. &nbsp; &nbsp;GET can be cached, giving you erroneous results for a call. &nbsp; Learned that one the hard way&lt;g&gt;<br />
<br />
Also the format for the strings being sent/received is whatever they web site wants and are documented in their API. &nbsp; There is no standards for any of that. &nbsp; Probably obvious, but I thought I should mention it.<br />
<br />
Jim.
</div>


No problem and glad it helps you out.

One "gotcha" I should have mentioned that you need to watch out for; always use POST.    GET can be cached, giving you erroneous results for a call.   Learned that one the hard way<g>

Also the format for the strings being sent/received is whatever they web site wants and are documented in their API.   There is no standards for any of that.   Probably obvious, but I thought I should mention it.

Jim.

<div>
Thanks Jim - good to know.<br />
<br />
Take care....
</div>


Thanks Jim - good to know.

Take care....

<div>
<i>&quot;Also the format for the strings being sent/received is whatever they web site wants and are documented in their API. &nbsp; There is no standards for any of that. &nbsp; Probably obvious, but I thought I should mention it.&quot;</i><br />
<br />
And, unfortunately, is subject to change at any time, without announcement.
</div>


"Also the format for the strings being sent/received is whatever they web site wants and are documented in their API.   There is no standards for any of that.   Probably obvious, but I thought I should mention it."

And, unfortunately, is subject to change at any time, without announcement.

<div>
Nice point Dale - thanks for your help again.
</div>


Nice point Dale - thanks for your help again.

<div>
<div class="content wysiwyg-content">
I have an MS Access / VBA application running on an RDP server. &nbsp;I have been asked to interface with a phone system via REST API. &nbsp;I haven't done this before, so could do with some help in relation go GET/POST commands. &nbsp;However, I am also concerned about memory/processor overhead for each user.<br />
<br />
So....I could really do with some advice.
</div>
</div>


I have an MS Access / VBA application running on an RDP server.  I have been asked to interface with a phone system via REST API.  I haven't done this before, so could do with some help in relation go GET/POST commands.  However, I am also concerned about memory/processor overhead for each user.

So....I could really do with some advice.

How to make POST/GET REST API calls from VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.