I would like to get API data in excel using VBA code and output the results to an excel sheet but am unsure how to do this as I am new to getting API data into Excel. I have tried to use the Data From Web option but cannot get it to recognise the API Link.
If possible I also want to be able to query the url's from the first sheet and output the results to another sheet.
First Sheet looks like this:
The first API Link is: https://api.goformz.com/v2/templates/6c6fc77d-6902-4278-b96e-a471004a331c/formz?sort=name&name=&status=complete&pagesize=500
The url' s i need to query from the first sheet are in column "B" and I need them to output to a second sheet called sheet 2
I am told that i can use a JSON module to customise the output / get the data but again unsure where to start.
I have also attached a copy of the Excel Sheet and XML data