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':
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!!
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':
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!!