Get information from API using VBA

[K1600]

I am trying to pull information from an API but I can't work out how to do the coding.

I have been provided the below in relation to the API and I have my API key to add in but would appreciate it if someone could assist with how I need to code it.

curl -H "Accept: application/json" -H "x-api-key: your_api_key" \https://beta.check-mot.service.gov.uk/trade/vehicles/mot-tests\?registration=XX10ABC

Once I have managed to master this bit it is my intention to integrate this into my existing code in order to pull the registration number out from a table and then return the MOT test date from the API which appears to be referenced as "completedDate".

Thanks in advance.

 

[John_w]

Sorry, I was thinking of leading and trailing spaces. Change the Trim(rngColVRM.cells(r).Value) to Replace(rngColVRM.cells(r).Value, " ", "")

 

[K1600]

Sorry, I was thinking of leading and trailing spaces. Change the Trim(rngColVRM.cells(r).Value) to Replace(rngColVRM.cells(r).Value, " ", "")

No need to apologise. I tried to fathom a way of using trim but didn't manage anything but errors!

That works perfectly now though. Thank you again for your assistance. I'll leave you in peace now.