VES API

[Kayleigh]

I am looking to find a simple way to integrate the Vehicle Enquiry Service API into a database. Can this be done without third-party software?

If anyone can suggest any leads on how this or a similar process can be done.

Thanks for your help

 

[theDBguy]

Hi. I believe you can use VBA in Access to interface with that API. If I find a link to an example, I'll let you know.

 

[The_Doc_Man]

What will matter, Kayleigh, is whether you have an appropriate module available to make automation calls with a mapped library, or perhaps you have documentation on the protocols required to make those calls. The protocol documentation would tell you how to exercise every option of the service. It IS possible in theory to write code that would work with the API. From the looks of it, you have a returned value in JSON format, and that HAS been discussed in this forum many times. You should be able to find it via a JSON keyword search. I am not familiar with it as I have not emphasized web interactions but there HAVE been several such posts within the last few years.