Integracion geoaustral (ZenWare) cacciuttolo<br><br><br>https://csv.webfleet.com/extern?lang=en&account=cacciuttolo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>insert into integracion_geoaustral_vehiculos (nro,numero,patente, nombre, empresa) values ('1-838083-7215129001','194',upper('RKCR97'),'RKCR-97 (CAMARA)','cacciuttolo') <br>Excepción capturada: Duplicate entry '1-838083-7215129001' for key 'PRIMARY'
[{"objectno":"194","objectname":"RKCR-97 (CAMARA)","licenseplatenumber":"RKCR97","vehicletype":"ecoPLUS","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-7215129001","fuelreference":2},{"objectno":"035","objectname":"RSPC-26 (740)","licenseplatenumber":"RSPC-26","identnumber":"3AKJHPD","registrationdate":"2023-03-19","ep_avgfuelusage":15089,"fl_avgfuelusage":40000,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-196F636077","fueltanksize":760,"obu_btaddress":"E8:B4:70:31:EE:6C","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"080","objectname":"RRWL-64 (740)","licenseplatenumber":"RRWL-64","ep_avgfuelusage":7071,"fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593A93015","fueltanksize":75,"obu_btaddress":"E8:B4:70:33:24:D0","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"102","objectname":"JXZJ-55 (530)","licenseplatenumber":"JXZJ-55","vehicletype":"truck","registrationdate":"2023-08-30","fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-0503366421","fueltanksize":900,"obu_btaddress":"E4:04:39:56:CA:73","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"090","objectname":"RKCR-98 (530)","licenseplatenumber":"RKCR-98","vehicletype":"truck","identnumber":"W1T964414N0529554","ep_avgfuelusage":34965,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-05033172E7","fueltanksize":660,"obu_btaddress":"E4:04:39:E6:EB:13","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"104","objectname":"RLGK-80 (530)","licenseplatenumber":"RLGK-80","vehicletype":"truck","identnumber":"WDB963424K0294336","registrationdate":"2023-08-29","ep_avgfuelusage":38240,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-721421CA05","fueltanksize":304,"obu_btaddress":"E4:04:39:C8:3A:53","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"124","objectname":"LZZB-84 (530)","licenseplatenumber":"LZZB-84","vehicletype":"truck","identnumber":"WDB964414L0376796","registrationdate":"2023-09-03","ep_avgfuelusage":39954,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-5305372AD6","fueltanksize":660,"obu_btaddress":"E4:04:39:DF:CE:F8","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"107","objectname":"RKCR-97  (530)","licenseplatenumber":"RKCR-97","vehicletype":"truck","identnumber":"3AKJHPDV8NSMY9911","registrationdate":"2023-08-30","ep_avgfuelusage":43476,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-05033677F2","fueltanksize":304,"obu_btaddress":"E4:04:39:9B:21:88","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"116","objectname":"RXFF-49 (530)","licenseplatenumber":"RXFF-49","vehicletype":"truck","identnumber":"W1T964414P0568217","ep_avgfuelusage":45056,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-53053726C3","fueltanksize":660,"obu_btaddress":"E4:04:39:87:88:62","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"113","objectname":"SDWZ-89 (530)","licenseplatenumber":"SDWZ-89","vehicletype":"heavyweight_truck","registrationdate":"2023-09-02","ep_avgfuelusage":64509,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-6660540340","fueltanksize":900,"obu_btaddress":"E4:04:39:9A:FF:38","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"108","objectname":"RKHT-20 (530)","licenseplatenumber":"RKHT-20","vehicletype":"trailer","identnumber":"W1T964414N0542763","registrationdate":"2023-08-29","ep_avgfuelusage":41838,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-5305372241","fueltanksize":660,"obu_btaddress":"E4:04:39:54:58:35","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"106","objectname":"LZZB-88 (530)","licenseplatenumber":"LZZB-88","vehicletype":"truck","registrationdate":"2023-08-30","ep_avgfuelusage":41503,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-9593AD7642","fueltanksize":660,"obu_btaddress":"E4:04:39:A0:D2:37","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"109","objectname":"JYJK-61 (530)","licenseplatenumber":"JYJK-61","vehicletype":"truck","registrationdate":"2023-08-29","fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-466055057B","fueltanksize":540,"obu_btaddress":"E4:04:39:DF:CE:C6","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"094","objectname":"SGYV-58 (530)","licenseplatenumber":"SGYV-58","vehicletype":"truck","identnumber":"W1T964414P0605003","registrationdate":"2023-08-25","ep_avgfuelusage":39402,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-5305373105","fueltanksize":660,"obu_btaddress":"E4:04:39:E7:00:A3","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"096","objectname":"SGYV-59 (530)","licenseplatenumber":"SGYV-59","vehicletype":"truck","identnumber":"W1T964414P0605008","registrationdate":"2023-08-26","ep_avgfuelusage":42086,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-6660541499","fueltanksize":660,"obu_btaddress":"E4:04:39:56:CE:32","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"117","objectname":"PXWT-96 (530)","licenseplatenumber":"PXWT-96","vehicletype":"van","registrationdate":"2023-09-03","ep_avgfuelusage":48814,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593AD73AD","fueltanksize":660,"obu_btaddress":"E4:04:39:A9:4B:51","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"112","objectname":"PFST-71 (530)","licenseplatenumber":"PFST-71","vehicletype":"pickup","power":"113","identnumber":"MMBJJKL10LH033580","registrationdate":"2023-09-03","ep_avgfuelusage":3860,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"enginesize":2000,"ep_btaddress":"E4:04:39:D6:7D:39","vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-0503367271","obu_btaddress":"E4:04:39:87:80:10","ep_type":2,"fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"122","objectname":"PFTT-53 (530)","licenseplatenumber":"PFTT-53","vehicletype":"truck","registrationdate":"2023-09-03","ep_avgfuelusage":41715,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-721421DA04","fueltanksize":660,"obu_btaddress":"E4:04:39:66:44:87","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"120","objectname":"VXXB-77 (530)","licenseplatenumber":"VXXB-77","vehicletype":"pickup","registrationdate":"2023-08-31","fl_avgfuelusage":40000,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"red","speedlimit":120,"objectuid":"1-838083-6660540F46","obu_btaddress":"E4:04:39:C8:3A:45","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"019","objectname":"PXWT-95 (740)","licenseplatenumber":"PXWT-95","vehicletype":"truck","identnumber":"W1T964414N0506181","ep_avgfuelusage":41607,"fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-466066344C","fueltanksize":660,"obu_btaddress":"E8:B4:70:33:22:31","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"020","objectname":"KCTH-70 (740)","licenseplatenumber":"KCTH-70","vehicletype":"van","identnumber":"MMBJJKL10HH048574","registrationdate":"2023-03-13","ep_avgfuelusage":27321,"fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-880E05446F","fueltanksize":700,"obu_btaddress":"E8:B4:70:33:05:18","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"050","objectname":"SBZX-51 (740)","licenseplatenumber":"SBZX-51","vehicletype":"truck","registrationdate":"2023-03-27","ep_avgfuelusage":33394,"fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-95939EA564","fueltanksize":700,"obu_btaddress":"E8:B4:70:33:23:B2","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"008","objectname":"RFZV-42 (740)","licenseplatenumber":"RFZV-42 ","vehicletype":"dump_truck_open","registrationdate":"2023-03-16","ep_avgfuelusage":80451,"fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-530504255F","fueltanksize":300,"obu_btaddress":"E8:B4:70:33:24:35","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"052","objectname":"VTFL-27","licenseplatenumber":"VTFL-27","vehicletype":"sprinter","identnumber":"WDB964016L0421493","registrationdate":"2023-03-25","ep_avgfuelusage":46572,"fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"yellow","objectuid":"1-838083-466066C551","fueltanksize":390,"obu_btaddress":"E8:B4:70:31:EE:70","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"032","objectname":"LZZB-90 (740)","licenseplatenumber":"LZZB-90","vehicletype":"truck","identnumber":"W1T964414L0427390","registrationdate":"2023-03-21","ep_avgfuelusage":37253,"fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-299F963177","fueltanksize":660,"obu_btaddress":"E8:B4:70:33:23:9A","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"049","objectname":"LZZB-87 (740)","licenseplatenumber":"LZZB-87","vehicletype":"truck","registrationdate":"2023-03-27","ep_avgfuelusage":40230,"fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-530504F06E","fueltanksize":660,"obu_btaddress":"E8:B4:70:33:23:DE","fuelreference":2},{"objectno":"148","objectname":"LFGP-98 (530)","licenseplatenumber":"LFGP-98 ","vehicletype":"wrecker","ep_avgfuelusage":32302,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"red","objectuid":"1-838083-466054374A","fueltanksize":1000,"obu_btaddress":"E4:04:39:DC:D2:C9","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"150","objectname":"SDJD-24 (530)","licenseplatenumber":"SDJD-24 ","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299FA4D0B1","fueltanksize":660,"obu_btaddress":"E4:04:39:72:75:DA","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"146","objectname":"SBZX-37 (530)","licenseplatenumber":"SBZX-37","vehicletype":"pallet_truck","identnumber":"WDB964414K0286018","ep_avgfuelusage":31228,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-721420E132","fueltanksize":660,"obu_btaddress":"E4:04:39:52:62:3A","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"114","objectname":"SDWZ-90 (530)","licenseplatenumber":"SDWZ-90","vehicletype":"heavyweight_truck","registrationdate":"2023-09-02","ep_avgfuelusage":68663,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-880E367118","fueltanksize":900,"obu_btaddress":"E4:04:39:A9:4D:2F","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"125","objectname":"RRWL-64 (530)","licenseplatenumber":"RRWL64","power":"113","identnumber":"MMBJJKL10NH039195","registrationdate":"2023-09-04","ep_avgfuelusage":4215,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"enginesize":2000,"ep_btaddress":"E4:04:39:D6:7B:69","vehiclecolor":"","objectuid":"1-838083-9593AD7FB0","obu_btaddress":"E4:04:39:83:39:35","ep_type":2,"fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"093","objectname":"SGYV-56 (530)","licenseplatenumber":"SGYV-56","vehicletype":"truck","identnumber":"W1T964414P0605002","registrationdate":"2023-08-26","ep_avgfuelusage":40620,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-196F504503","fueltanksize":660,"obu_btaddress":"E4:04:39:C6:A1:05","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"098","objectname":"LZZB-89 (530)","licenseplatenumber":"LZZB-89","vehicletype":"truck","identnumber":"W1T964414L0427391","ep_avgfuelusage":39401,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-196F504420","obu_btaddress":"E4:04:39:A8:D1:2E","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"149","objectname":"LGLT-79 (530)","licenseplatenumber":"LGLT-79 ","vehicletype":"truck","ep_avgfuelusage":52404,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593AC4523","fueltanksize":540,"obu_btaddress":"E4:04:39:A8:DF:4F","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"110","objectname":"SGWS-54 (530)","licenseplatenumber":"SGWS54","vehicletype":"pickup","power":"113","identnumber":"MMBJJKL10NH084072","registrationdate":"2023-08-29","ep_avgfuelusage":5064,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"enginesize":2000,"ep_btaddress":"E4:04:39:E2:2F:A0","vehiclecolor":"","objectuid":"1-838083-050336765F","obu_btaddress":"E4:04:39:A8:CA:3B","ep_type":2,"fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"119","objectname":"VTFL-17 (530)","licenseplatenumber":"VTFL-17 ","vehicletype":"sprinter","registrationdate":"2023-09-02","ep_avgfuelusage":40158,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"yellow","objectuid":"1-838083-3234023F47","fueltanksize":72,"obu_btaddress":"E4:04:39:E3:71:56","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"143","objectname":"RXFF-21(530)","licenseplatenumber":"RXFF-21","vehicletype":"truck","identnumber":"3AKJHPDV9NSNM8996","ep_avgfuelusage":35568,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-3234030770","fueltanksize":608,"obu_btaddress":"E4:04:39:A5:9D:D5","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"101","objectname":"PFFW-24 (530)","licenseplatenumber":"PFFW-24","vehicletype":"light_truck_pallet","registrationdate":"2023-08-27","fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-6660541543","fueltanksize":210,"obu_btaddress":"E4:04:39:D4:B4:58","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"145","objectname":"RXFF-53 (530)","licenseplatenumber":"RXFF-53 ","vehicletype":"truck","identnumber":"3AKJHPDV1NSNM8992","ep_avgfuelusage":37957,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593AC47B4","fueltanksize":608,"obu_btaddress":"E4:04:39:87:8C:B6","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"118","objectname":"SGYV-61 (530)","licenseplatenumber":"SGYV-61","vehicletype":"truck","identnumber":"W1T964414P0605006","ep_avgfuelusage":39651,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E367D7A","fueltanksize":660,"obu_btaddress":"E4:04:39:9B:25:9E","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"099","objectname":"JYJK-60 (530)","licenseplatenumber":"JYJK-60","vehicletype":"truck","ep_avgfuelusage":48059,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-6660541534","fueltanksize":540,"obu_btaddress":"E4:04:39:E1:47:E1","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"144","objectname":"RBFH-54 (530)","licenseplatenumber":"RBFH-54 ","vehicletype":"truck","identnumber":"3AKJHPDV9NSNC9375","ep_avgfuelusage":38495,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-6660553751","fueltanksize":304,"obu_btaddress":"E4:04:39:80:1F:5F","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"097","objectname":"VXXB-87 (530)","licenseplatenumber":"VXXB-87","registrationdate":"2023-08-26","ep_avgfuelusage":40044,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-3234022571","obu_btaddress":"E4:04:39:54:54:5D","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"176","objectname":"PBYG-58 (530)","licenseplatenumber":"PBYG-58 ","vehicletype":"van","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-050345BF54","obu_btaddress":"E4:04:39:E3:5F:D1","fuelreference":2},{"objectno":"162","objectname":"LZZB-85 (530)","licenseplatenumber":"LZZB-85","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-5305456620","obu_btaddress":"E4:04:39:A8:C0:6C","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"165","objectname":"RSPB-98 (530)","licenseplatenumber":"RSPB-98 ","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F221271","obu_btaddress":"E4:04:39:72:7C:04","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"168","objectname":"SBZX-40 (530)","licenseplatenumber":"SBZX-40","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-9593DF335D","obu_btaddress":"E4:04:39:A3:EF:26","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"161","objectname":"RLKC-82 (530)","licenseplatenumber":"RLKC-82","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-299FD74355","obu_btaddress":"E4:04:39:9C:60:E4","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"166","objectname":"SBZX-39 (530)","licenseplatenumber":"SBZX-39","vehicletype":"truck","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-5305456633","obu_btaddress":"E4:04:39:9C:60:9B","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"170","objectname":"LBDP-29 (530)","licenseplatenumber":"LBDP-29","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-32347073E0","obu_btaddress":"E4:04:39:E3:66:23","fuelreference":2,"accelerationvehicletype":"medium_weight"},{"objectno":"174","objectname":"RKCR-99 (530)","licenseplatenumber":"RKCR-99","vehicletype":"light_truck_pallet","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"red","objectuid":"1-838083-05034501F3","obu_btaddress":"E4:04:39:D4:B4:8A","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"171","objectname":"JHST-50 (530)","licenseplatenumber":"JHST-50","vehicletype":"van","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-32347140EB","obu_btaddress":"E4:04:39:72:68:D8","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"151","objectname":"VTFL-27 (530)","licenseplatenumber":"VTFL-27","vehicletype":"sprinter","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"yellow","objectuid":"1-838083-4660253229","fueltanksize":72,"obu_btaddress":"E4:04:39:72:74:8B","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"167","objectname":"PFTT-55 (530)","licenseplatenumber":"PFTT-55","vehicletype":"dump_truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-6660264376","obu_btaddress":"E4:04:39:DF:D8:4E","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"169","objectname":"RSPC-34 (530)","licenseplatenumber":"RSPC-34","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F221280","obu_btaddress":"E4:04:39:DF:D4:7A","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"163","objectname":"SBZX-52 (530)","licenseplatenumber":"SBZX-52","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-6660264367","obu_btaddress":"E4:04:39:72:6E:17","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"164","objectname":"RBFH-57 (530)","licenseplatenumber":"RBFH-57","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-880E443111","obu_btaddress":"E4:04:39:DF:DA:EB","fuelreference":2,"accelerationvehicletype":"light_weight"},{"objectno":"178","objectname":"PSSZ-71 (530)","licenseplatenumber":"PSSZ-71","vehicletype":"pallet_truck","fl_avgfuelusage":40000,"vh_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-196F239F33","obu_btaddress":"E4:04:39:E1:EB:FB","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"185","objectname":"PFTV-43 (530)","licenseplatenumber":"PFTV-43","vehicletype":"dump_truck","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"","objectuid":"1-838083-721485D020","obu_btaddress":"E4:04:39:54:27:B0","fuelreference":2,"accelerationvehicletype":"heavy_weight"},{"objectno":"180","objectname":"JKDH-53 (530)","licenseplatenumber":"JKDH-53","vehicletype":"heavyweight_truck","fl_avgfuelusage":40000,"fl_fueltype":1,"vehiclecolor":"red","objectuid":"1-838083-196FF45436","obu_btaddress":"E4:04:39:54:55:11","fuelreference":2,"accelerationvehicletype":"heavy_weight"}]<br>https://csv.webfleet.com/extern?lang=en&account=cacciuttolo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showDriverReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig<br>insert into integracion_geoaustral_conductores (id,conductor, nombre, empresa,rut) values ('1-838083-05544257E57','000012','miguel Clavero ','cacciuttolo','') <br>Excepción capturada: Duplicate entry '1-838083-05544257E57' for key 'PRIMARY'
[{"driverno":"000012","name1":"miguel Clavero ","objectno":"188","signontime":"15/04/2026 15:57:41","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-95930944BC","driveruid":"1-838083-05544257E57"},{"driverno":"000013","name1":"Hector Saavedra","objectno":"036","signontime":"15/04/2026 16:06:40","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05030540F2","driveruid":"1-838083-88594254FD4"},{"driverno":"00002","name1":"Marco Coccio","objectno":"160","signontime":"20/10/2025 17:29:52","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-530546F455","driveruid":"1-838083-724342BB069"},{"driverno":"00003","name1":"Jorge Cornejo","objectno":"156","signontime":"20/10/2025 17:27:53","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-9593DC736D","driveruid":"1-838083-95C4CE1E526"},{"driverno":"00004","name1":"Manuel Diaz","objectno":"155","signontime":"20/10/2025 17:32:02","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660250485","driveruid":"1-838083-1938333F76C"},{"driverno":"00005","name1":"Manuel Fernandez","objectno":"168","signontime":"15/04/2026 15:51:41","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-9593DF335D","driveruid":"1-838083-3263615E143"},{"driverno":"00006","name1":"Benjamin Morales Moran","objectno":"159","signontime":"20/10/2025 17:28:37","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660252089","driveruid":"1-838083-4637366C3E9"},{"driverno":"00007","name1":"Felipe Nuñez","objectno":"153","signontime":"20/10/2025 17:26:56","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E4761FD","driveruid":"1-838083-95C4CE1E537"},{"driverno":"00009","name1":"Miguel Perez","objectno":"019","signontime":"28/11/2025 16:30:36","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466066344C","driveruid":"1-838083-1938333F77D"},{"driverno":"00010","name1":"Miguel Rivas","objectno":"175","signontime":"20/10/2025 17:30:22","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E45723D","driveruid":"1-838083-29C8C66E413"},{"driverno":"00011","name1":"Patricio Rubio","objectno":"050","signontime":"20/10/2025 17:26:15","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-95939EA564","driveruid":"1-838083-4637366C3F6"},{"driverno":"00014","name1":"Jorge Salinas ","objectno":"167","signontime":"20/10/2026 15:42:04","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660264376","driveruid":"1-838083-19383397380"},{"driverno":"00016","name1":"nn","objectno":"114","signontime":"15/04/2026 15:59:12","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E367118","driveruid":"1-838083-663737C6391"},{"driverno":"00017","name1":"Miguel Molina","objectno":"086","signontime":"28/11/2025 16:43:01","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660501198","driveruid":"1-838083-7243421349C"},{"driverno":"00018","name1":"Juan Pedraza","objectno":"039","signontime":"28/11/2025 16:09:09","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-5305040B26","driveruid":"1-838083-055455B75F6"},{"driverno":"00019","name1":"Manuel Vargas","objectno":"017","signontime":"28/11/2025 16:42:14","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F635E58","driveruid":"1-838083-7243421330A"},{"driverno":"00021","name1":"Jorge Zamora","objectno":"044","signontime":"28/11/2025 16:49:02","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-4660662C30","driveruid":"1-838083-885955B4394"},{"driverno":"00023","name1":"SIN OPERADOR","objectno":"021","signontime":"02/12/2025 17:37:08","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-0503054720","driveruid":"1-838083-88595A352B3"},{"driverno":"00024","name1":"Francisco Jofre ","objectno":"049","signontime":"15/04/2026 15:54:28","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-530504F06E","driveruid":"1-838083-95C4D956A70"},{"driverno":"00025","name1":"Roberto Toro ","objectno":"105","signontime":"15/04/2026 15:58:42","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-721421CAE3","driveruid":"1-838083-1938247783E"},{"driverno":"00026","name1":"Guillermo Aedo","objectno":"099","signontime":"20/10/2026 15:51:35","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660541534","driveruid":"1-838083-29C8D126B03"},{"driverno":"00027","name1":"nn","objectno":"104","signontime":"15/04/2026 16:13:21","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-721421CA05","driveruid":"1-838083-46372124CE6"},{"driverno":"00029","name1":"Fernardo Miranda","objectno":"170","signontime":"15/04/2026 16:18:23","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-32347073E0","driveruid":"1-838083-88594254FF6"},{"driverno":"00030","name1":"Juan Acevedo","objectno":"112","signontime":"15/04/2026 16:51:57","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-0503367271","driveruid":"1-838083-95C4D956AC5"},{"driverno":"00031","name1":"Juan Acevedo","objectno":"176","signontime":"15/04/2026 16:52:17","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-050345BF54","driveruid":"1-838083-05544257EE0"},{"driverno":"007","name1":"Leonardo Rios","company":"SDAND","objectno":"035","signontime":"24/03/2023 10:28:18","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F636077","driveruid":"1-838083-535222F071F"},{"driverno":"010","name1":"Enzo Hernandez","objectno":"118","signontime":"15/04/2026 15:59:51","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E367D7A","driveruid":"1-838083-1938459411B"},{"driverno":"012","name1":"nn","objectno":"005","signontime":"27/12/2022 09:18:45","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-53050114D2","driveruid":"1-838083-7243379AF8D"},{"driverno":"013","name1":"Nelson Bazaez","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-05542170FE5"},{"driverno":"014","name1":"Patricio Jara ","objectno":"012","signontime":"22/03/2023 10:26:48","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-050305710F","driveruid":"1-838083-46374203D09"},{"driverno":"016","name1":"Jorge Salinas ","company":"SDAND","objectno":"154","signontime":"02/12/2025 16:22:23","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-0503477570","driveruid":"1-838083-6637430F391"},{"driverno":"018","name1":"Sergio Garrido","company":"SDAND","objectno":"152","signontime":"28/11/2025 16:47:02","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E47611F","driveruid":"1-838083-0554217E5F6"},{"driverno":"019","name1":"nn","company":"SDAND","objectno":"009","signontime":"28/11/2025 16:51:35","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-95939E7015","driveruid":"1-838083-29C8B20F0FF"},{"driverno":"020","name1":"Francisco Ortiz","company":"SDAND","objectno":"069","signontime":"28/11/2025 16:36:52","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660505662","driveruid":"1-838083-6637430F403"},{"driverno":"021","name1":"Mauricio Mendez","company":"SDAND","objectno":"038","signontime":"15/04/2026 16:00:13","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-299F962E6E","driveruid":"1-838083-95C4BA7F641"},{"driverno":"022","name1":"Rodrigo Bruna","company":"SDAND","objectno":"116","signontime":"28/11/2025 16:45:19","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-53053726C3","driveruid":"1-838083-1938475E40F"},{"driverno":"023","name1":"Marcelo Gonzales","company":"SDAND","objectno":"028","signontime":"23/03/2023 10:31:58","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-0503054443","driveruid":"1-838083-95C4BA7F656"},{"driverno":"024","name1":"Jorge Soto","company":"SDAND","objectno":"026","signontime":"23/03/2023 10:32:36","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-721412E2E7","driveruid":"1-838083-29C8B20F770"},{"driverno":"027","name1":"JORGE JARA","company":"SDAND","objectno":"022","signontime":"23/03/2023 10:34:39","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F636747","driveruid":"1-838083-0554217E242"},{"driverno":"028","name1":"Jaime Cabrera","company":"SDAND","objectno":"006","signontime":"23/03/2023 10:42:09","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-299F9603AF","driveruid":"1-838083-0554217E253"},{"driverno":"029","name1":"Chabby Araya","company":"SDAND","objectno":"025","signontime":"15/04/2026 15:56:11","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660673796","driveruid":"1-838083-1938475E43A"},{"driverno":"032","name1":"Jorge Toro","company":"SDAND","objectno":"051","signontime":"28/11/2025 16:39:42","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-323431E526","driveruid":"1-838083-29C8B236A66"},{"driverno":"033","name1":"Ricardo Pavez","company":"SDAND","objectno":"029","signontime":"24/03/2023 10:31:16","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466066335E","driveruid":"1-838083-724336E3E0D"},{"driverno":"034","name1":"Melquiceder Cisternas","company":"SDAND","objectno":"011","signontime":"28/11/2025 16:07:27","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E057220","driveruid":"1-838083-05542147F76"},{"driverno":"038","name1":"Adolfo Aguilera","company":"SDAND","objectno":"032","signontime":"20/10/2026 15:38:38","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-299F963177","driveruid":"1-838083-95C4BA40546"},{"driverno":"039","name1":"Jose Ramirez","company":"SDAND","objectno":"042","signontime":"29/03/2023 09:50:58","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660672E70","driveruid":"1-838083-724336E5009"},{"driverno":"040","name1":"SIN OPERADOR","company":"SDAND","objectno":"041","signontime":"28/11/2025 16:50:26","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-4660662C21","driveruid":"1-838083-29C8B230A44"},{"driverno":"042","name1":"Miguel Toro","company":"SDAND","objectno":"187","signontime":"20/10/2026 15:46:46","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196FF46682","driveruid":"1-838083-53522015D34"},{"driverno":"046","name1":"Ivan Aguilera","company":"SDAND","objectno":"053","signontime":"30/03/2023 09:33:44","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-323431F754","driveruid":"1-838083-6637433E391"},{"driverno":"047","name1":"Omar Jorquera","company":"SDAND","objectno":"047","signontime":"28/11/2025 16:44:11","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-7214120050","driveruid":"1-838083-29C8B23E0FF"},{"driverno":"100","name1":"Fernando Cepeda","objectno":"130","signontime":"15/12/2025 16:38:39","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466055C73B","driveruid":"1-838083-66373864790"},{"driverno":"101","name1":"Diego Diaz","objectno":"054","signontime":"15/12/2025 16:40:10","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F639652","driveruid":"1-838083-72434DB109B"},{"driverno":"102","name1":"Luis Contreras","objectno":"091","signontime":"10/06/2024 16:10:23","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F575282","driveruid":"1-838083-1938345073D"},{"driverno":"104","name1":"Juan Villegas","objectno":"138","signontime":"11/03/2026 09:55:49","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-46605477C0","driveruid":"1-838083-88595A16012"},{"driverno":"105","name1":"Sergio Villegas - Cristian Hernandez","objectno":"142","signontime":"24/09/2024 14:34:58","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660550286","driveruid":"1-838083-463731033B6"},{"driverno":"106","name1":"Sergio Vergara","objectno":"147","signontime":"11/03/2026 09:56:02","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-3234030404","driveruid":"1-838083-95C4C1145D0"},{"driverno":"107","name1":"Alexis Contreras","current_workstate":0,"dt_cardid":"","driveruid":"1-838083-6637300173B"},{"driverno":"108","name1":"Francisco Vergara","objectno":"095","signontime":"15/12/2025 16:45:30","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-880E36661C","driveruid":"1-838083-05545A151F7"},{"driverno":"109","name1":"Viviana Lopez ","objectno":"120","signontime":"10/06/2024 16:13:01","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660540F46","driveruid":"1-838083-95C4C971504"},{"driverno":"110","name1":"Nicolas Galarce - Roberto Pueyes","objectno":"135","signontime":"24/09/2024 11:33:57","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-721420A002","driveruid":"1-838083-05545270123"},{"driverno":"111","name1":"Fernando Vargas","objectno":"136","signontime":"24/09/2024 11:34:36","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660557580","driveruid":"1-838083-1938345074A"},{"driverno":"112","name1":"Eduardo Clavero","objectno":"088","signontime":"24/09/2024 14:30:41","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-6660530378","driveruid":"1-838083-29C8C101422"},{"driverno":"113","name1":"Michel Delgado","objectno":"139","signontime":"10/06/2024 16:13:43","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-721420A0E0","driveruid":"1-838083-32636631161"},{"driverno":"114","name1":"Rodrigo Villarroel - Ricardo Ovando","objectno":"141","signontime":"24/09/2024 14:30:22","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-3234033216","driveruid":"1-838083-463731033C7"},{"driverno":"115","name1":"Rodolfo Salas - Juan Arancibia","objectno":"064","signontime":"24/09/2024 14:30:03","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-32343FE061","driveruid":"1-838083-53525324321"},{"driverno":"116","name1":"Leonardo Ferreira - Humberto Celedón","objectno":"131","signontime":"15/12/2025 16:46:59","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-466055C7CA","driveruid":"1-838083-19383C3579E"},{"driverno":"120","name1":"Carlos Lucero","objectno":"129","signontime":"15/12/2025 16:48:19","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-666054C566","driveruid":"1-838083-29C8C9644FE"},{"driverno":"121","name1":"Jorge Aguilera - Octavio Galarce","objectno":"140","signontime":"24/09/2024 14:27:12","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-05033704F5","driveruid":"1-838083-29C8C101435"},{"driverno":"123","name1":"Leonardo Arredondo","objectno":"137","signontime":"15/12/2025 17:00:02","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-196F512485","driveruid":"1-838083-463731033D4"},{"driverno":"126","name1":"Edgar Covarrubias","objectno":"127","signontime":"10/06/2024 16:14:51","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-530537E07E","driveruid":"1-838083-885952730DF"},{"driverno":"132","name1":"Juan Carlos Oyarzun","objectno":"133","signontime":"24/09/2024 14:28:14","signonrole":1,"current_workstate":0,"dt_cardid":"","manualassignment":true,"objectuid":"1-838083-72142110E4","driveruid":"1-838083-32636701752"}]url:https://csv.webfleet.com/extern?lang=en&account=cacciuttolo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=popQueueMessagesExtern&msgclass=0&outputformat=json&useUTF8=true&freetext=Leipzig<br><br>insert into integracion_geoaustral_log2 (id,fecha,empresa,numero,msg_type,msg_text,mensaje)  values ("538106372367",sysdate(),"cacciuttolo","116","41100353","Tracking data (5x)",'{"msgid":538106372367,"msg_time":"2026-10-30T10:36:09Z","msg_class":4,"msg_type":41100353,"msg_text":"Tracking data (5x)","objectno":"116","odometer":1248162,"pos_latitude":-32963263,"pos_longitude":-70267054,"pos_text":"2100000 Los Andes, CL","pos_country":"CL","pos_postcode":"210","pos_time":"2026-10-30T10:36:07Z","speed":45,"course":315,"direction":8,"status":"A","surplus_data":{"hd_trackingpositions":[{"crs":342,"spd":49,"gst":"2026-10-30T10:35:57Z","lon":-70266233,"lat":-32964365},{"crs":341,"spd":44,"gst":"2026-10-30T10:36:00Z","lon":-70266360,"lat":-32964049},{"crs":334,"spd":42,"gst":"2026-10-30T10:36:03Z","lon":-70266517,"lat":-32963756},{"crs":322,"spd":45,"gst":"2026-10-30T10:36:06Z","lon":-70266767,"lat":-32963498},{"crs":315,"spd":45,"gst":"2026-10-30T10:36:09Z","lon":-70267054,"lat":-32963263}]},"objectuid":"1-838083-53053726C3","location_params":"countryCode=CL;countryName=Chile;locality=Los Andes;postalCode=210;extendedPostalCode=2100000;speedLimit=90;roadUse=LocalStreet;","odometer_long":124816200}')<br><br>insert into integracion_geoaustral_log2 (id,fecha,empresa,numero,msg_type,msg_text,mensaje)  values ("538106377269",sysdate(),"cacciuttolo","148","41100353","Tracking data (5x)",'{"msgid":538106377269,"msg_time":"2026-10-30T10:36:11Z","msg_class":4,"msg_type":41100353,"msg_text":"Tracking data (5x)","objectno":"148","odometer":4076391,"pos_latitude":-32870579,"pos_longitude":-70402366,"pos_text":"Camino Internacional, 2100000 San Esteban, CL","pos_country":"CL","pos_postcode":"210","pos_time":"2026-10-30T10:36:04Z","speed":66,"course":325,"direction":8,"status":"A","surplus_data":{"hd_trackingpositions":[{"afu":0,"crs":308,"spd":64,"gst":"2026-10-30T10:35:54Z","lon":-70400996,"lat":-32872253},{"afu":0,"crs":324,"spd":68,"gst":"2026-10-30T10:35:57Z","lon":-70401332,"lat":-32871807},{"afu":0,"crs":325,"spd":67,"gst":"2026-10-30T10:36:00Z","lon":-70401683,"lat":-32871388},{"afu":0,"crs":324,"spd":66,"gst":"2026-10-30T10:36:03Z","lon":-70402031,"lat":-32870993},{"afu":0,"crs":325,"spd":66,"gst":"2026-10-30T10:36:06Z","lon":-70402366,"lat":-32870579}]},"objectuid":"1-838083-466054374A","location_params":"countryCode=CL;countryName=Chile;locality=San Esteban;street=Camino Internacional;postalCode=210;extendedPostalCode=2100000;roadNumbers=60-CH;speedLimit=70;roadUse=LocalStreet;","odometer_long":407639100}')<br><br>insert into integracion_geoaustral_log2 (id,fecha,empresa,numero,msg_type,msg_text,mensaje)  values ("538106398630",sysdate(),"cacciuttolo","118","41100353","Tracking data (5x)",'{"msgid":538106398630,"msg_time":"2026-10-30T10:36:14Z","msg_class":4,"msg_type":41100353,"msg_text":"Tracking data (5x)","objectno":"118","odometer":1853503,"pos_latitude":-32869945,"pos_longitude":-70402841,"pos_text":"Camino Internacional, 2100000 San Esteban, CL","pos_country":"CL","pos_postcode":"210","pos_time":"2026-10-30T10:36:13Z","speed":64,"course":329,"direction":8,"status":"A","surplus_data":{"hd_trackingpositions":[{"afu":5000,"crs":322,"spd":68,"gst":"2026-10-30T10:36:01Z","lon":-70401511,"lat":-32871629},{"afu":0,"crs":324,"spd":69,"gst":"2026-10-30T10:36:04Z","lon":-70401874,"lat":-32871205},{"afu":0,"crs":324,"spd":68,"gst":"2026-10-30T10:36:07Z","lon":-70402229,"lat":-32870786},{"afu":3313,"crs":328,"spd":65,"gst":"2026-10-30T10:36:10Z","lon":-70402545,"lat":-32870369},{"afu":1813,"crs":329,"spd":64,"gst":"2026-10-30T10:36:13Z","lon":-70402841,"lat":-32869945}]},"objectuid":"1-838083-880E367D7A","location_params":"countryCode=CL;countryName=Chile;locality=San Esteban;street=Camino Internacional;postalCode=210;extendedPostalCode=2100000;roadNumbers=60-CH;speedLimit=70;roadUse=LocalStreet;","odometer_long":185350300}')<br>https://csv.webfleet.com/extern?lang=en&account=cacciuttolo&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]=3<br>$data[0][outstandingMessages]=0<br><br><br><br>OK.<br><br>