Pull Vehicle data from DVLA to Excel. Possibe?

Hi all,

First off, I'm not even sure if this is possible, but I'm sure you guys can tell me either way.

I'm want to be able to input a vehicle registration in a cell, and have a cell called 'Year' pull the date of manufacture from the DVLA API. I have an Api key.

The DVLA API website says:

To call the API, make a HTTP POST request to the following URL:

*API address but I'm not allowed to post it.*

and include the following in the request body:

{ "registrationNumber": "TE57VRN" }

You must also include a mandatory x-api-key header with each request you send. This must contain the API key which you have been issued with.

-------

There is an example but nothing that is applicable to Excel, hence why I'm not sure if it can even be done.

Again, very much appreciate any help that

Can confirm the above works as expected (I do have an API key), you probably want to change this:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Though

Hi guys,

Thank you for this.

I'm embarrassed because I'm still stuck. I imported the JSON converter and added the code, but when I run it, it's just blank. I put the code in the sheet VB, and I'm just pressing play macro to test, so maybe there's more to it than that.

Also, is there a way to have the reg, "registrationNumber"": ""TE57VRN", change based on the value in a cell, or does it need to be manually written in new code all the time.

Again, sorry for being a noob.

Thanks again.

Hi,

I am trying to do the same thing. Ive followed all instructions but am getting a compile error in the JSON code :/

Any ideas where Ive gone wrong please?
Thanks

Screenshot 2023-08-03 155410.png