(PowerBuilder) UK Vehicle Data VRM Lookup

Demonstrates how to query the UK Vehicle Data VRM online API's. (See https://ukvehicledata.co.uk/)

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Rest
integer li_BAutoReconnect
integer li_Success
string ls_JsonResponseStr
oleobject loo_Json
integer li_NumBatteries
integer i

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

loo_Rest = create oleobject
// Use "Chilkat_9_5_0.Rest" for versions of Chilkat < 10.0.0
li_rc = loo_Rest.ConnectToNewObject("Chilkat.Rest")
if li_rc < 0 then
    destroy loo_Rest
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// Connect using TLS.
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("uk1.ukvehicledata.co.uk",443,1,li_BAutoReconnect)
if li_Success <> 1 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    return
end if

// Replace UKVD-API-KEY with your actual API KEY,
// which looks something like "abcdb1234-0abc-1235-abcf-1234c3d1abcd"
loo_Rest.Authorization = "ukvd-ipwhitelist UKVD-API-KEY"

// Replace "ABCDE" with a real VRM...
loo_Rest.AddQueryParam("key_vrm","ABCDE")

// Add the Content-Type HTTP request header.
// success = rest.AddHeader("Content-Type","application/json; charset=UTF-8");

// This request gets vehicle data.
// See below for a request to get battery data.
ls_JsonResponseStr = loo_Rest.FullRequestNoBody("GET","/api/datapackage/vehicledata")
if loo_Rest.LastMethodSuccess <> 1 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    return
end if

if loo_Rest.ResponseStatusCode <> 200 then
    Write-Debug "Response Status Code = " + string(loo_Rest.ResponseStatusCode)
    Write-Debug ls_JsonResponseStr
    destroy loo_Rest
    return
end if

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.Load(ls_JsonResponseStr)
loo_Json.EmitCompact = 0

// Show the JSON response.
Write-Debug loo_Json.Emit()

// A sample vehicledata response will be as shown below.
// To get a few bits of data from the response:
Write-Debug "RequestGuid: " + loo_Json.StringOf("RequestGuid")
Write-Debug "EngineNumber: " + loo_Json.StringOf("DataItems.EngineNumber")
Write-Debug "Vrm: " + loo_Json.StringOf("DataKeys.Vrm")

// {
//   "RequestGuid": "xxxxxxxx-cc72-4b63-xxxxxxxxxxxx",
//   "StatusCode": 0,
//   "StatusMessage": "Success",
//   "PackageId": "xxxxxxxx-a4bc-4a84-af22-xxxxxxxxxxxx",
//   "PackageVersion": 1,
//   "DataKeys": {
//     "Vrm": "ABCDE"
//   },
//   "DataItems": {
//     "DriveAxle": "4x2",
//     "Exported": "False",
//     "DriverSeatPosition": "RHD",
//     "EngineNumber": "LN910940728622",
//     "Class": "Sport",
//     "ImportedNorthernIreland": "False",
//     "HistoryPreviousKeeperAcquisitionDate": "2013-01-12",
//     "RoadFundLicenseSixMonth": "�126.50",
//     "EnginePowerBhp": "262",
//     "SpecDateRangeFrom": "1987-10-01",
//     "RegistrationDateUK": "1994-08-03",
//     "SoundLevelDriveBy": "0",
//     "RoadFundLicenseTwelveMonth": "�235.00",
//     "RoadFundLicenseBand": "Not available",
//     "Vrm": "J5YVK",
//     "TrimCode": "BA",
//     "Derivative": "S4",
//     "EngineSizeCc": "2174",
//     "EngineCylinderCount": "4",
//     "HistoryLatestV5cIssueDate": "2015-05-12",
//     "Category": "Car",
//     "HistoryPreviousKeeperCount": "9",
//     "ConditionScrapped": "False",
//     "EngineValveCount": "16",
//     "WeightUnladen": "0",
//     "RoadFundLicenseRenewalDate": "2017-04-01",
//     "Model": "Esprit",
//     "SpecDateRangeTo": "2003-06-01",
//     "RoadFundLicenseCurrentStatus": "Tax not due",
//     "BuildYear": "1994",
//     "BuildDate": "1994-12-31",
//     "VinLast4": "1448",
//     "GearCount": "5",
//     "SeatCount": "2",
//     "Make": "Lotus",
//     "Vin": "SCC082910RHA61448",
//     "ColourChangeCount": "0",
//     "DriveType": "Rear Wheel Drive",
//     "WeightGross": "0",
//     "EngineCode": "N/A",
//     "EnginePowerKw": "193",
//     "SoundLevelEngineSpeed": "0",
//     "ConditionUnscrapped": "False",
//     "HistoryPreviousKeeperDisposalDate": "2014-04-26",
//     "EngineAlignment": "Longitudinal",
//     "Imported": "False",
//     "BodyType": "Coupe",
//     "EnginePosition": "Mid",
//     "TransmissionType": "Manual",
//     "WeightFullyLaden": "0",
//     "SoundLevelStationary": "0",
//     "FuelType": "Petrol",
//     "Colour": "YELLOW",
//     "EngineSizeLitre": "2.2",
//     "RegistrationDate": "1994-08-03",
//     "Co2Emissions": "000",
//     "WeightMaxTowingUnbraked": "0",
//     "HistoryCurrentKeeperAcquisitionDate": "2015-04-25",
//     "WeightMaxTowingBraked": "0",
//     "DoorCount": "2",
//     "EngineCylinderConfig": "Inline",
//     "EngineFuelDelivery": "Turbo Injection"
//   }
// }

// -----------------------------------------------------------------------------------
// Now get battery data...
ls_JsonResponseStr = loo_Rest.FullRequestNoBody("GET","/api/datapackage/batterydata")
if loo_Rest.LastMethodSuccess <> 1 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    destroy loo_Json
    return
end if

if loo_Rest.ResponseStatusCode <> 200 then
    Write-Debug "Response Status Code = " + string(loo_Rest.ResponseStatusCode)
    Write-Debug ls_JsonResponseStr
    destroy loo_Rest
    destroy loo_Json
    return
end if

loo_Json.Load(ls_JsonResponseStr)

// Show the JSON response containing battery data.
Write-Debug loo_Json.Emit()

// To get a few pieces of information out of the response...
li_NumBatteries = loo_Json.SizeOfArray("DataItems.BatteryList")
i = 0
do while (i < li_NumBatteries)
    loo_Json.I = i
    Write-Debug "---- Battery " + string(i) + ":"
    Write-Debug "  Type = " + loo_Json.StringOf("DataItems.BatteryList[I].Type")
    Write-Debug "  LayoutImage = " + loo_Json.StringOf("DataItems.BatteryList[I].LayoutImage")
    Write-Debug "  TerminalCode = " + loo_Json.StringOf("DataItems.BatteryList[I].TerminalCode")
    i = i + 1
loop

// The battery data looks like this:
// {
//   "RequestGuid": "xxxxxxxx-5030-4b3d-a2ed-xxxxxxxxxxxx",
//   "StatusCode": 0,
//   "StatusMessage": "Success",
//   "PackageId": "xxxxxxxx-9ec2-4fd3-9247-xxxxxxxxxxxx",
//   "PackageVersion": 1,
//   "DataKeys": {
//     "Vrm": "ABCDE"
//   },
//   "DataItems": {
//     "BatteryList": [
//       {
//         "Type": "Primary",
//         "UkRef": "075",
//         "LayoutCode": "0",
//         "LayoutImage": "http://cdn.ukvehicledata.co.uk/battery/layout/0.png",
//         "TerminalCode": "T1",
//         "TerminalImage": "http://cdn.ukvehicledata.co.uk/battery/terminal/T1.png",
//         "HoldDownCode": "B13",
//         "HoldDownImage": "http://cdn.ukvehicledata.co.uk/battery/holddown/B13.png"
//       }
//     ],
//     "BatteryCount": "1"
//   }
// }


destroy loo_Rest
destroy loo_Json