Integracion Wirtrack echeverria<br><br><br>https://csv.webfleet.com/extern?lang=en&account=echeverria&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>con error:<br><br>update integracion_wirtrack_vehiculos set numero='50' , patente=upper('KHJB50'), nombre='KHJB50' where nro='1-838083-3234212307' and empresa='echeverria' <br>Excepción capturada: Duplicate entry '1-838083-3234212307' for key 'PRIMARY'
[{"objectno":"50","objectname":"KHJB50","licenseplatenumber":"KHJB50","vehicletype":"light_truck_pallet","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-3234212307","obu_btaddress":"E8:B4:70:32:00:EA","fuelreference":0,"accelerationvehicletype":"light_weight"},{"objectno":"42","objectname":"JZYF42","licenseplatenumber":"JZYF42","vehicletype":"light_truck_pallet","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-721402F470","obu_btaddress":"E8:B4:70:32:03:5C","fuelreference":0,"accelerationvehicletype":"light_weight"},{"objectno":"007","objectname":"CJFR18","licenseplatenumber":"CJFR18 ","vehicletype":"heavyweight_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-466077D11C","obu_btaddress":"E8:B4:70:32:04:C2","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"82","objectname":"KDXX94","licenseplatenumber":"KDXX94","vehicletype":"dump_truck","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-050314B0F5","obu_btaddress":"E8:B4:70:32:08:4E","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"005","objectname":"KPYR13","licenseplatenumber":"KPYR13 ","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","description":"274.265 km","objectuid":"1-838083-880E14A131","obu_btaddress":"E4:04:39:C9:F1:28","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"015","objectname":"PBRJ95","licenseplatenumber":"PBRJ95","vehicletype":"van","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":120,"objectuid":"1-838083-299F87D3BF","fueltanksize":53,"obu_btaddress":"E8:B4:70:32:02:19","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"001","objectname":"KBWF77","licenseplatenumber":"KBWF77","vehicletype":"truck","identnumber":"9BVRG10C9JE850193","ep_avgfuelusage":33453,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-95938FA364","obu_btaddress":"E8:B4:70:32:02:B0","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"011","objectname":"HSKP12 ","licenseplatenumber":"HSKP12 ","vehicletype":"truck","ep_avgfuelusage":35506,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299F87D346","obu_btaddress":"E8:B4:70:32:02:C5","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"003","objectname":"PRLT47","licenseplatenumber":"PRLT47 ","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-323420E326","obu_btaddress":"E8:B4:70:32:00:43","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"012","objectname":"RCRY88","licenseplatenumber":"RCRY88","vehicletype":"heavy_truck","ep_avgfuelusage":32635,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E14A10E","obu_btaddress":"E8:B4:70:32:06:EF","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"010","objectname":"RZWX58","licenseplatenumber":"RZWX58","vehicletype":"truck","ep_avgfuelusage":32320,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-666076D365","obu_btaddress":"E8:B4:70:32:08:A0","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"004","objectname":"PZZF99","licenseplatenumber":"PZZF99","vehicletype":"medium_truck","ep_avgfuelusage":26416,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-530515F600","obu_btaddress":"E8:B4:70:32:04:25","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"002","objectname":"JJHS49","licenseplatenumber":"JJHS49","vehicletype":"pallet_truck","ep_avgfuelusage":25043,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299F87D375","obu_btaddress":"E8:B4:70:32:03:A9","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"006","objectname":"PKDX18","licenseplatenumber":"PKDX18 ","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","description":"Cuentakilómetros\n115.052 km","objectuid":"1-838083-299F87D364","obu_btaddress":"E8:B4:70:35:5B:82","fuelreference":0,"accelerationvehicletype":"medium_weight"},{"objectno":"61","objectname":"PLJB61 ","licenseplatenumber":"PLJB61","vehicletype":"sprinter","ep_avgfuelusage":8078,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-5305146675","obu_btaddress":"E8:B4:70:32:B8:AF","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"H11","objectname":"HDKK11","licenseplatenumber":"HDKK11","vehicletype":"light_truck_pallet","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-3234214541","obu_btaddress":"E8:B4:70:32:06:D3","fuelreference":0},{"objectno":"21","objectname":"XK2921","licenseplatenumber":"XK2921","vehicletype":"truck","vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F729F02","obu_btaddress":"E8:B4:70:31:FC:21","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"96","objectname":"HWFB96","licenseplatenumber":"HWFB96","vehicletype":"light_truck_pallet","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-466076775D","obu_btaddress":"E8:B4:70:32:02:E4","fuelreference":0,"accelerationvehicletype":"light_weight"},{"objectno":"018","objectname":"RZWX59","licenseplatenumber":"RZWX59","vehicletype":"truck","ep_avgfuelusage":34537,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F729085","obu_btaddress":"E8:B4:70:32:00:F6","fuelreference":2},{"objectno":"87","objectname":"DFYR87","licenseplatenumber":"DFYR87","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-466076414D","obu_btaddress":"E8:B4:70:32:02:6A","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"016","objectname":"HCHB33","licenseplatenumber":"HCHB33","vehicletype":"truck","ep_avgfuelusage":25030,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-72140306E3","obu_btaddress":"E8:B4:70:32:02:63","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"92","objectname":"HRPB92","licenseplatenumber":"HRPB92","vehicletype":"light_truck_pallet","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-050315467F","obu_btaddress":"E8:B4:70:32:00:DC","fuelreference":0,"accelerationvehicletype":"medium_weight"},{"objectno":"008","objectname":"RCRY89 ","licenseplatenumber":"RCRY89 ","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E14A120","obu_btaddress":"E8:B4:70:32:02:3D","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"013","objectname":"KVDT-20 ","licenseplatenumber":"KVDT20 ","vehicletype":"truck","ep_avgfuelusage":32918,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-323420E3E2","obu_btaddress":"E8:B4:70:32:04:4C","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"19","objectname":"PKDX19","licenseplatenumber":"PKDX19","vehicletype":"medium_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F737004","obu_btaddress":"E8:B4:70:31:EE:F2","fuelreference":0,"accelerationvehicletype":"light_weight"},{"objectno":"009","objectname":"LXDZ11","licenseplatenumber":"LXDZ11","vehicletype":"medium_truck","ep_avgfuelusage":25305,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299F87D357","obu_btaddress":"E8:B4:70:32:02:E6","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"017","objectname":"DRTT71","licenseplatenumber":" DRTT71","vehicletype":"trailer","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F728297","fueltanksize":200,"obu_btaddress":"E8:B4:70:32:03:5D","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"014","objectname":"LJSC58","licenseplatenumber":"LJSC58","vehicletype":"medium_truck","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E14A1FD","obu_btaddress":"E8:B4:70:32:B8:2D","fuelreference":0,"accelerationvehicletype":"light_weight"},{"objectno":"029","objectname":"TVTF30","licenseplatenumber":"TVTF30","vehicletype":"dump_truck","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-323447111B","obu_btaddress":"E4:04:39:60:CD:86","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"032","objectname":"RVFL91","licenseplatenumber":"RVFL91","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-721481CA21","obu_btaddress":"E8:B4:70:39:03:99","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"031","objectname":"TFLC81","licenseplatenumber":"TFLC81","vehicletype":"pickup","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-05039637F4","obu_btaddress":"E8:B4:70:39:06:02","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"030","objectname":"RXHV36","licenseplatenumber":"RXHV36","vehicletype":"truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E962C0D","obu_btaddress":"E8:B4:70:39:03:16","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"034","objectname":"JKXW68","licenseplatenumber":"JKXW68","vehicletype":"trailer","fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-6660F60159","obu_btaddress":"E8:B4:70:39:05:7A","fuelreference":2},{"objectno":"033","objectname":"SCCF18","licenseplatenumber":"SCCF18","vehicletype":"dump_truck","vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E96B550","obu_btaddress":"E8:B4:70:35:53:91","fuelreference":2,"accelerationvehicletype":"heavy_weight"}]<br><br>url:https://csv.webfleet.com/extern?lang=en&account=echeverria&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br>contents:[]<br><br>Vacio<br>https://csv.webfleet.com/extern?lang=en&account=echeverria&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=ackQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>$data[0][action]=ackQueueMessagesExtern<br>$data[0][result]=1<br>$data[0][acknowledgedMessages]=0<br>$data[0][outstandingMessages]=0<br><br><br><br>Termino Proceso OK.<br><br>