Integracion Position (para Unigis) cacciuttolo
https://csv.webfleet.com/extern?lang=en&account=cacciuttolo&apikey=fe6370c8-0c69-4729-b134-e33fca450067&action=showVehicleReportExtern&outputformat=json&useUTF8=true&freetext=Leipzig
con error:Sin Error
update integracion_position_vehiculos set borrar='S'
where empresa='cacciuttolo'
update integracion_position_vehiculos set numero='194' , patente=upper('RKCR97'), borrar='N', nombre='RKCR-97 (CAMARA)', actualizacion=sysdate() where nro='1-838083-7215129001' and empresa='cacciuttolo'
insert into integracion_position_vehiculos (nro,numero,patente, nombre, empresa,creacion) values ('1-838083-7215129001','194',upper('RKCR97'),'RKCR-97 (CAMARA)','cacciuttolo',sysdate())
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":"089","objectname":"LZZB-86 (530)","licenseplatenumber":"LZZB-86","vehicletype":"truck","identnumber":"WDB963424K0295028","ep_avgfuelusage":46978,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-721426D609","obu_btaddress":"E4:04:39:E3:5F:67","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":"111","objectname":"LZZB-81 (530)","licenseplatenumber":"LZZB-81 (530)","vehicletype":"light_truck_pallet","power":"113","registrationdate":"2023-08-30","ep_avgfuelusage":5640,"fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"enginesize":2000,"ep_btaddress":"E4:04:39:D2:92:2C","vehiclecolor":"","speedlimit":80,"objectuid":"1-838083-050336726E","fueltanksize":150,"obu_btaddress":"E4:04:39:D7:8B:1D","ep_type":2,"fuelreference":2,"accelerationvehicletype":"medium_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":"139","objectname":"LGLV-52 (530)","licenseplatenumber":"LGLV-52 ","vehicletype":"truck","fl_avgfuelusage":40000,"vh_fueltype":1,"ep_fueltype":1,"fl_fueltype":1,"vehiclecolor":"","speedlimit":120,"objectuid":"1-838083-721420A0E0","fueltanksize":540,"obu_btaddress":"E4:04:39:87:9E:D9","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":"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":"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"}]
SELECT nro, replace(substr(patente,1,7),' ','') patente FROM integracion_position_vehiculos
WHERE inscrito='N'
and empresa='cacciuttolo'
Fatal error: Uncaught SoapFault exception: [WSDL] SOAP-ERROR: Parsing WSDL: Couldn't load from 'https://api.gpsposition.cl/wsPositionGPS/integrationPositionGPSAgunsa.php?wsdl' : failed to load external entity "https://api.gpsposition.cl/wsPositionGPS/integrationPositionGPSAgunsa.php?wsdl"
in /home/telemati/public_html/api/integracion_position_tabla.php:176
Stack trace:
#0 /home/telemati/public_html/api/integracion_position_tabla.php(176): SoapClient->__construct('https://api.gps...', Array)
#1 {main}
thrown in /home/telemati/public_html/api/integracion_position_tabla.php on line 176