Integracion RC (Recurso Confiable) toptainer
https://csv.webfleet.com/extern?lang=en&account=toptainer&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig
con error:
update integracion_rc_vehiculos set numero='013' , patente=upper('SWWD82'), nombre='SWWD82' where nro='1-838083-466046635F' and empresa='toptainer'
Excepción capturada: Duplicate entry '1-838083-466046635F' for key 'PRIMARY'
[{"objectno":"013","objectname":"SWWD82","licenseplatenumber":"SWWD82","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-466046635F","fueltanksize":200,"obu_btaddress":"E8:B4:70:32:E5:7C","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"020","objectname":"SGDG65","licenseplatenumber":"SGDG65","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F433041","fueltanksize":400,"obu_btaddress":"E8:B4:70:34:9D:55","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"014","objectname":"SWWD80","licenseplatenumber":"SWWD80","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E251358","fueltanksize":400,"obu_btaddress":"E8:B4:70:34:9C:B3","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"019","objectname":"VLZT85","licenseplatenumber":"VLZT85","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E251341","obu_btaddress":"E8:B4:70:34:9D:39","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"029","objectname":"TPRG20","licenseplatenumber":"TPRG20","vehicletype":"truck","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-050355B500","fuelreference":2,"accelerationvehicletype":"light_weight"}]
url:https://csv.webfleet.com/extern?lang=en&account=toptainer&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig
Vacio
NOK
OK.
Total OK.