VBA to pass GET to API

[yits05]

Hello,

I know this question has been asked before, but I still find myself lost. In short, I would like help with creating VBA code that passes the following GET request to an API, and returns the JSON results in 'Sheet2':

https://api.sampleurl.com/item/enrich?pretty=true&api_key=12345678910abcdefghi&profile=www.linkedin.com/in/abcde

Ideal state, I would love for the code to loop through a list of parameters in column A, attaching each to the end of the above HTTP request, send the request, and then return the JSON in one row next to the parameter. Ideally each datapoint would be in its own column, but if it easier it can all be in one field. An example result (dummy data)

Many thanks!!

 

[Dan_W]

Have you come across the VBA-JSON Library yet? You can download it at VBA Tools (Github). It's in the library JsonConverter.bas that you will need to import into your project, and there are instructions on how to use it. In terms of the project you're envisaging, I'd say it's entirely doable. Let me know if you have any questions.