Need a Rest API request URL converted to Excel using VBA

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

I have a single request URL from a Rest API. If I paste the URL into a browser, I can see all the data in the form of JSON (I don't know what that means, but that's what it says in the top left corner). I need a macro written that imports ALL the information from this API. I would like all the parameters as headers in a single worksheet, with all the data listed in the rows below. I should be able to hit the macro button and have this updated. I can't use any outside libraries for this - I need to be able to send the file to anyone else and have them run it.

I cannot share the URL I have. I need you to work with an example URL, and I will paste mine in the macro to test it.

Excel Excel VBA RESTful API JSON

Project ID: #23998828

About the project

9 proposals Remote project Active 4 years ago