Extracting Data using REST API from Excel VBA

[dhancy]

Hello,

This is a bit out of my league so I apologize in advance if I am not using the right jargon here.

We have a system which, as I understand it, has data that can only be retrieved externally using REST APIs. I have written VBA scripts many times to extract Oracle data using SQL, but I have no experience using REST APIs. I therefore, have many how to questions about this. But for starters, is it possible to use REST API calls from Excel VBA? And if so, can someone give me a high level overview of how to start? Perhaps a simple example of this would help me get me started. I suspect there will have to be some means of connecting to a web site or server, and perhaps a user ID and password would have to be supplied as well. Once that connection is made, I suspect I'd code a simple query whose results can be written to a spreadsheet.

Any suggestions you can provide will be greatly appreciated.

Thank you!

Dennis

 

[John_w]

I think you're referring to sending GET, POST etc. requests to a http URL and handling the response. This can be done from VBA using the XMLHTTP object. See this example for the Google Directions API:

Use VBA to get step polylines from Google Directions API xml file

Hi all, I currently use VBA to extract the 'overview polyline' returned from the Google Directions API, and paste it into a spreadsheet. However, I need more accurate polylines. I can get better accuracy if I can stitch together the child node polylines within each step. How do I convert my...

www.mrexcel.com