search

VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.77k stars 573 forks source link

Error parsing some json documents #224

Open iermb opened 2 years ago

iermb commented 2 years ago

Hi,

We are using your parser for working with the Google API. After several good results we find out some json returns are not correctly analysed. It seams the parser doesn't return the content that shuld be.

For example, for the following result, everything is ok:

{

"geocoded_waypoints" : [ { "geocoder_status" : "OK", "place_id" : "ChIJF-S-sRyWpBIRF00efh6zwTo", "types" : [ "street_address" ] }, { "geocoder_status" : "OK", "place_id" : "ChIJZcFe54ObpBIRjZMpnaELuUQ", "types" : [ "establishment", "food", "meal_delivery", "point_of_interest", "restaurant" ] } ], "routes" : [ { "bounds" : { "northeast" : { "lat" : 41.5014809, "lng" : 2.1409027 }, "southwest" : { "lat" : 41.3460498, "lng" : 1.9968648 } }, "copyrights" : "Map data ©2022 Inst. Geogr. Nacional", "legs" : [ { "distance" : { "text" : "31,3 km", "value" : 31349 }, "duration" : { "text" : "32 min", "value" : 1918 }, "duration_in_traffic" : { "text" : "29 min", "value" : 1746 }, "end_address" : "Rambla Rafael Casanova, 4, 08830 Sant Boi de Llobregat, Barcelona, España", "end_location" : { "lat" : 41.3473035, "lng" : 2.0425347 }, "start_address" : "Carrer de Lluís Companys, 2, 08290 Cerdanyola del Vallès, Barcelona, España", "start_location" : { "lat" : 41.4910616, "lng" : 2.1409027 }, "steps" : [ { "distance" : { "text" : "13 m", "value" : 13 }, "duration" : { "text" : "1 min", "value" : 3 }, "end_location" : { "lat" : 41.4911707, "lng" : 2.1408631 }, "html_instructions" : "Dirígete hacia el \u003cb\u003enorte\u003c/b\u003e por \u003cb\u003eCarrer de Lluís Companys\u003c/b\u003e", "polyline" : { "points" : "cvf|FscaLUF" }, "start_location" : { "lat" : 41.4910616, "lng" : 2.1409027 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,9 km", "value" : 891 }, "duration" : { "text" : "3 min", "value" : 181 }, "end_location" : { "lat" : 41.4969376, "lng" : 2.1335071 }, "html_instructions" : "Continúa por \u003cb\u003ePasseig de Cordelles\u003c/b\u003e", "polyline" : { "points" : "yvf|FkcaLe@Lm@|@]d@QVi@x@IHmAhBORuApBSXs@bAGHm@AEDm@|@s@bAm@z@c@n@i@t@EHW\\OVEFKJEHCDIJMPORMPABIJMPKPQVe@r@QTg@t@GHIJCFu@dAm@|@E@GDSL" }, "start_location" : { "lat" : 41.4911707, "lng" : 2.1408631 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 274 }, "duration" : { "text" : "1 min", "value" : 34 }, "end_location" : { "lat" : 41.4964996, "lng" : 2.1307697 }, "html_instructions" : "En la rotonda, toma la \u003cb\u003etercera\u003c/b\u003e salida en dirección \u003cb\u003eCarrer de la Clota\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "{zg|Fmu_LA?A?A?A?A?A@A?A@A?A@A@A@A@?@A@?@A@AB?B?@?@AB?@?@?@@B?@?@?@@@?@@@?B@@@@@@?@@??@@?@@@??@@?@?@@@?@?@?RLHJHJJPHRJTJ^F\\DTBRD\\Bb@@b@AV?HA\\AVCPCNEREV" }, "start_location" : { "lat" : 41.4969376, "lng" : 2.1335071 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,9 km", "value" : 916 }, "duration" : { "text" : "2 min", "value" : 96 }, "end_location" : { "lat" : 41.5014809, "lng" : 2.1221601 }, "html_instructions" : "En la rotonda, toma la \u003cb\u003eprimera\u003c/b\u003e salida y continúa por \u003cb\u003eCarrer de la Clota\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "cxg|Fid_LA?A@A?A@A@A??@A@A@?@A@?@AB?@?@?@?@A@@B?@?@AJAHAHAFCHEJITADAJi@l@UVSRiAlAIHA@IJCHGJaC|Es@xAO\\QZc@x@i@dAyCjGUj@ELKJA?GRa@z@ELUl@a@|@[v@{BxFCJAH" }, "start_location" : { "lat" : 41.4964996, "lng" : 2.1307697 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,6 km", "value" : 592 }, "duration" : { "text" : "1 min", "value" : 65 }, "end_location" : { "lat" : 41.4972218, "lng" : 2.1208503 }, "html_instructions" : "Gira ligeramente a la \u003cb\u003eizquierda\u003c/b\u003e hacia \u003cb\u003eRonda Serraparera\u003c/b\u003e", "maneuver" : "turn-slight-left", "polyline" : { "points" : "gwh|Fon}K?H?H@HBLDNFJBD@@DH\\d@@@Xh@NX\\v@\\z@BHBFBDFLFHFHFJXb@@@PTLLHHNLHDNFF@D@F@F?FAF?FAPGdAe@p@[b@MHEb@SZMbAa@|@_@JCrAe@@?" }, "start_location" : { "lat" : 41.5014809, "lng" : 2.1221601 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 318 }, "duration" : { "text" : "1 min", "value" : 31 }, "end_location" : { "lat" : 41.4980641, "lng" : 2.1176876 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eC. de la Serra de Galliners\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "s|g|Fif}KP@F@B@B@BB@@@B@B@B@D@D@NAHYfBIn@?@?LCFQz@Sv@Wz@EPSt@Qh@ENEDELCFS@KJQJ" }, "start_location" : { "lat" : 41.4972218, "lng" : 2.1208503 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 307 }, "duration" : { "text" : "1 min", "value" : 31 }, "end_location" : { "lat" : 41.49972349999999, "lng" : 2.1149712 }, "html_instructions" : "En la rotonda, toma la \u003cb\u003eprimera\u003c/b\u003e salida en dirección \u003cb\u003eCarretera de la Universitat Autònoma\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "{ah|Fqr|KG@E@G@EBEDCDEDCFAFCH?FAH?F@H?HBFARCLAHCHEHGNILWf@KR[j@?@QZEHGJQ\KNGLYd@e@r@IHEBCB[P" }, "start_location" : { "lat" : 41.4980641, "lng" : 2.1176876 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 342 }, "duration" : { "text" : "1 min", "value" : 34 }, "end_location" : { "lat" : 41.4981509, "lng" : 2.1119759 }, "html_instructions" : "En la rotonda, toma la \u003cb\u003esegunda\u003c/b\u003e salida en dirección \u003cb\u003eCarrer de la Font del Carme\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "glh|Fqa|KE?A?C@A?C@A@A@C@A@ABA@ABAB?BAB?BAB?B?B?B?B@B?B@D@B@B@@@B@@@@B@@@@@B@@?@?@@@?@?@?@AB?DDDBDDBDBBDF@@b@z@zBhEtAjCJRBFBF@F@DBJ" }, "start_location" : { "lat" : 41.49972349999999, "lng" : 2.1149712 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,8 km", "value" : 795 }, "duration" : { "text" : "1 min", "value" : 47 }, "end_location" : { "lat" : 41.4942027, "lng" : 2.1064452 }, "html_instructions" : "En la rotonda, toma la \u003cb\u003etercera\u003c/b\u003e salida \u003cb\u003eE-15\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eAP-7\u003c/b\u003e en dirección \u003cb\u003eBarcelona\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "mbh|F{n{KAB?D?B?B?B?B@B?B@D@B@B@@@B@@B@@B@?B@@@@?@?@?@?@?@?@?@?B?@ABA@ABA@A@C@A@C@C@C@C?C?C@C?C?C?CAC?CDSDMBIHKHMDEDEHGLKNGNEFAJ?HAF@B?J?JDFBD@JHJHLPTNp@rAAvBp@bBJTfAtCFTj@dB@FDLH\\h@vBj@hCZbB@JHb@ZB" }, "start_location" : { "lat" : 41.4981509, "lng" : 2.1119759 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "11,0 km", "value" : 10975 }, "duration" : { "text" : "7 min", "value" : 405 }, "end_location" : { "lat" : 41.45235539999999, "lng" : 2.0001718 }, "html_instructions" : "Incorpórate a \u003cb\u003eE-15\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eAP-7\u003c/b\u003e por el ramal de la \u003cb\u003eizquierda\u003c/b\u003e en dirección \u003cb\u003eTarragona\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eLleida\u003c/b\u003e", "maneuver" : "ramp-left", "polyline" : { "points" : "wig|FilzKLR@DDPHb@H@Jh@Ll@Jn@V|APfANhADTRtALp@L~@Lx@L|@Fh@BVBVD\\BVNd@f@jHFv@Dp@Dh@X~DTvCThCP|AVxBVjBLx@XxAJl@DTf@fC?@l@tC\\xA^xA@Dh@pBf@lBj@pBHXp@fCFRj@tB|@pD@FLj@j@bCb@tBZdB\\xBVlBRxAPfBNtAPxBNtBLbC?LHpBFvBBtB@nA?f@@~ACrBArA?FCrAE|AIpBOpCM~AK|AKjAAFQlBMbAYjC?@gApJgAtJSzBMjAIAGdAUbEAd@AJCfAAv@AFA~@At@?n@?jA?x@@A@h@?N@^BdA@r@FpAFnAHnABh@JhALrAFd@Ff@Fp@Fh@Fd@F@?DHb@?BHd@Hb@BNDXBRDTHb@Jf@Jd@Jd@Jf@Lb@Jf@Lb@ZlA\jAJ^Pj@Xv@Ph@Tn@Xt@Rf@Rf@Tf@@z@LZR^Rb@h@AHPJPR\LPXf@R\V@RXZb@f@t@VZTZX\\NR\\@XZXZTVVVVX\ZNNDDx@r@TTVPVRZVZTHFJHFBHFFDVP@@PLHFHFZPVPt@d@b@Tp@@\\P\\Rr@@PJJFRLHDTNHDl@\XRZR@VZVn@d@^X\\XRPZXHHNNp@n@TT@@XZTTZ\\n@t@j@r@X^j@t@NRFH\\h@NTd@v@f@z@Xd@d@z@d@~@@x@P\Tb@d@bAz@bBz@BTb@d@z@h@|@tAtBf@r@RVRTRVh@p@VZr@x@XZp@p@n@l@@@l@j@x@n@r@l@r@d@\\VDBRNXNVPZP^Rr@^x@^RJNFZL\\N^Lr@TnA\\VHD?B@XFhDt@b@HfAXl@NTF\\L\\LRFXLJD^RRJLFHDRJNJj@^LJx@r@|EbFDDHLRZfAjBZl@b@bAx@rBRn@ZhAFRHXTbANl@BRP|@Hp@D@@LHl@PbBBZDr@D~@?HFjB?f@@pAAhACjAE|@EA?FAHEb@?JEb@Gn@E^Gl@QlBQvBG|@Gp@Ad@AJEbAGjB?XAn@?rA?dA@t@BdA@h@Bl@DdABh@Bl@BX?BH~@Fn@@JDb@NrAJn@Hn@F\\Fb@Nt@FZP|@BJXlAVdATx@@B^jA?BXx@Pb@L\\Rd@^~@f@hAZn@t@xAR^@v@Vb@r@pADFf@x@T@dAdBbA|ApAlB\\f@HLArArCvD@h@PT|@dAx@~@X^BBVZb@f@PTv@z@TVDDn@t@x@z@xA~Ap@l@n@l@xBrB" }, "start_location" : { "lat" : 41.4942027, "lng" : 2.1064452 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "4,7 km", "value" : 4657 }, "duration" : { "text" : "3 min", "value" : 192 }, "end_location" : { "lat" : 41.414192, "lng" : 2.0114809 }, "html_instructions" : "Toma la salida por \u003cb\u003eE-90\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eB-23\u003c/b\u003e en dirección \u003cb\u003eB-24\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eN-340\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eMolins de Rei\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eBarcelona\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003ePuertro\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eAeropuerto\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eFira\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eZona Franca\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eA-16\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eC-32\u003c/b\u003e", "maneuver" : "ramp-right", "polyline" : { "points" : "gd_|FateKLTNPr@v@FHHJNRFJ@l@P\NZfBD?BV^FH@@b@h@RRl@f@@@\\R^P^P@LB?TFJ@@?@@J@TDX@F?@@X?V@H?HA@?DARCFA@?REJAPEPE@AHCRK@?HEVOJIPKNMLIPM^UJK@AJKNOVa@~@yANWFKR@JOXc@NSPYFEFKh@m@\WZSf@YZQDA\MBATGLC@AHATGJC`@EZCTAN?ZAV@V@d@H@?p@Jf@NRFNF^Nf@Tb@Vh@Xh@VNHRHb@LVH@?JBNBN@H?L?D?B?LAPGFARIXOj@]n@k@V[LMVSDGRQ^]b@YHKHKFOtBcAv@a@LIjBkArAu@pAu@|CmBrBeArAs@h@Yj@WBAFCb@QLGrAi@@A^MFCz@[jAc@PGLEbCq@DC|A@JC@Ip@MvAYz@OvAUxBYhGq@hBSb@Eb@EtBUz@KdAM@AZETC~Ba@~@S~@Sh@Kj@IjBa@p@ONCTE\\MLCTGLEPGPGhC{@@OfC{@bA]d@QdBq@@AtAm@HE@?j@Wt@]nAi@XMRIDCFCBAb@SHE|@a@f@ULGDC|BeAbBw@ZOhCmAVMpB_AFEFCPINGLINI" }, "start_location" : { "lat" : 41.45235539999999, "lng" : 2.0001718 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "4,0 km", "value" : 3988 }, "duration" : { "text" : "3 min", "value" : 153 }, "end_location" : { "lat" : 41.3812112, "lng" : 2.0296787 }, "html_instructions" : "Mantente a la \u003cb\u003eizquierda\u003c/b\u003e para continuar por \u003cb\u003eB-23\u003c/b\u003e", "maneuver" : "keep-left", "polyline" : { "points" : "uuw{FwzgKpIeEl@Yt@]@QBy@vDgBpB_AbCkAHEPIZONI@S^Q@SAc@Ae@nCkAHEfEqBpFiCpBA~EaCHGBCDCNMHELGNKb@YZSFEd@WXSp@i@VWJK^Yd@@n@i@nFsEl@i@t@m@n@g@t@k@x@m@n@a@|@i@XOrAu@LEDCl@YjAg@vAg@RGNGPERIPEj@OfBc@f@MzCo@vBg@j@OfA[h@SXKZKpAi@|@a@ZMXOj@[zA{@j@[~@i@bAm@@UNIHGpAs@pAq@JELINGVKXMb@OHEt@WlBm@rCs@pCu@rCs@tDaA~Bo@VGjA[B?tAa@d@Ox@Yl@ULEb@QXOZU" }, "start_location" : { "lat" : 41.414192, "lng" : 2.0114809 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "3,5 km", "value" : 3470 }, "duration" : { "text" : "2 min", "value" : 142 }, "end_location" : { "lat" : 41.35691, "lng" : 2.0517528 }, "html_instructions" : "Toma la salida \u003cb\u003e5\u003c/b\u003e para incorporarte a \u003cb\u003eE-90\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eA-2\u003c/b\u003e en dirección \u003cb\u003eBarcelona\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eRonda Litoral\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eZona Franca - ZAL\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eAeroport\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eFira\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003ePort\u003c/b\u003e", "maneuver" : "ramp-right", "polyline" : { "points" : "qgq{FolkK\\AB?NIt@_@lAm@PIRKJG\\Ob@Sj@Sl@Sd@Ox@UTGh@OXKRILEf@S@QXOVOFEPKLINKNKDERM@[d@a@\\Wp@k@@[ROh@a@HGRO@?TQf@]LK~AiArAAfAu@lA{@t@i@DE\YHGRSHGPSDETYX@HMT@P]Xg@N@DMLYVs@v@kBXs@b@aAN@f@eA@aATe@?C@ADc@@s@Pa@JYVo@DM@Ct@cCFSLg@Ni@^}AVcAT{@?A\uAXgAZmADUNm@@?ZqA@CVaANk@XaAPe@DOHUTm@Zu@Ti@Vi@Xk@R@@s@d@w@@k@d@o@l@s@^c@PSJMd@c@n@k@lA}@BCt@g@v@e@v@c@r@[t@[n@Sr@Ut@Sz@Sx@Qz@Ov@K|@Iz@GdBGtBEnBEAE|@Ir@Il@G\\GnBi@|@W^O@QDAtAo@" }, "start_location" : { "lat" : 41.3812112, "lng" : 2.0296787 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "1,3 km", "value" : 1265 }, "duration" : { "text" : "1 min", "value" : 73 }, "end_location" : { "lat" : 41.3465101, "lng" : 2.0512186 }, "html_instructions" : "Toma la salida \u003cb\u003e607\u003c/b\u003e para incorporarte a \u003cb\u003eC-245\u003c/b\u003e en dirección \u003cb\u003eSant Boi de Llobregat\u003c/b\u003e", "maneuver" : "ramp-right", "polyline" : { "points" : "uol{FmvoKT?B?DAJEx@c@pAw@j@c@f@a@VWBCTUh@g@h@o@@e@d@i@HENMVQRIZIRENAD?L?JAV@d@D^BX@@CXCj@Mb@Ib@KZ?R?TBTFXJ\PXRh@@VRXTZTZRb@Vd@RFBHB^NbA@r@TXDJDNF@NbA@PHJD\NXNfBr@NHh@RHDJDB@HBDBB?DBJDRHd@Pr@Z" }, "start_location" : { "lat" : 41.35691, "lng" : 2.0517528 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,1 km", "value" : 120 }, "duration" : { "text" : "1 min", "value" : 9 }, "end_location" : { "lat" : 41.3460556, "lng" : 2.0500313 }, "html_instructions" : "Toma la salida \u003cb\u003eBV-2002\u003c/b\u003e hacia \u003cb\u003eSant Boi Centre\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eSant Vicenç dels Horts\u003c/b\u003e", "maneuver" : "ramp-right", "polyline" : { "points" : "unj{FcsoKb@@B@NPLRDLBLFX@T@\\Ax@" }, "start_location" : { "lat" : 41.3465101, "lng" : 2.0512186 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "1,2 km", "value" : 1196 }, "duration" : { "text" : "1 min", "value" : 82 }, "end_location" : { "lat" : 41.3511877, "lng" : 2.0377644 }, "html_instructions" : "Continúa por \u003cb\u003eCtra. Sant Vicenç dels Horts\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eBV-2002\u003c/b\u003e", "polyline" : { "points" : "{kj{FukoKGlAQlAKd@CJS~@AHENQb@Wp@IPGNMTKPABOTCFEHW\\k@|@[j@e@|@u@jAGHQVCDS\\Ud@Q\\Q\\GNIRIRIVK@[bAAFOl@M^ABc@pACJEJADUj@O^IREJCDc@A}@vBSf@c@dAUp@KVELc@dBQjAE\\CLGb@Af@ABATAZEn@AXCf@AJ?B?BARGhAAF?BMNMT" }, "start_location" : { "lat" : 41.3460556, "lng" : 2.0500313 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,4 km", "value" : 407 }, "duration" : { "text" : "1 min", "value" : 72 }, "end_location" : { "lat" : 41.3485754, "lng" : 2.0396691 }, "html_instructions" : "En la rotonda, toma la \u003cb\u003esegunda\u003c/b\u003e salida en dirección \u003cb\u003eC/\u003cwbr/\u003e del Dr. Antoni Pujadas\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "}kk{F__mKA?A?A?A?A@A?A@A?A@?@A@A?A@?BA@A@?@A@?B?@A@?B?@?@?B?@?@@B?@?@@@?B@B@@@@?@@@@?@@@@@?B@@?@?@?@?@?@?BA@?@A@?@A?A@A@A@A@ALCHADCBEHAHCPIHG@Ab@]NMZYTUHId@c@l@i@z@{@ZYHI^_@^a@FIn@s@" }, "start_location" : { "lat" : 41.3511877, "lng" : 2.0377644 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,2 km", "value" : 173 }, "duration" : { "text" : "1 min", "value" : 32 }, "end_location" : { "lat" : 41.3483352, "lng" : 2.0376533 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer Carles Martí i Vila\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "s{j{F}jmKHl@XnCPzADh@EPE|@" }, "start_location" : { "lat" : 41.3485754, "lng" : 2.0396691 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,1 km", "value" : 149 }, "duration" : { "text" : "1 min", "value" : 28 }, "end_location" : { "lat" : 41.3483129, "lng" : 2.0382564 }, "html_instructions" : "En \u003cb\u003ePlaça del Pallars Sobirà\u003c/b\u003e, toma la \u003cb\u003ecuarta\u003c/b\u003e salida y continúa por \u003cb\u003eCarrer Carles Martí i Vila\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "czj{Fi~lKC@A@ABA@A@?BA@AB?@AB?D?B?@@B?B?@@B?@@B?@@@@@@@@B@?@@@@@@B@B?@?@?@?B?@?@A@?@A@?@A@A@A@A@A?C@A@C?A@C?A?C@A?CAE?C?A?CAA?AAC?AAAAAAAAAAAAAM}@EQEi@" }, "start_location" : { "lat" : 41.3483352, "lng" : 2.0376533 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,2 km", "value" : 192 }, "duration" : { "text" : "1 min", "value" : 48 }, "end_location" : { "lat" : 41.347008, "lng" : 2.039190800000001 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer de l'Ebre\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "}yj{FcbmK|@UhBe@nAYFABABA@A?A@CAI?QCe@AS" }, "start_location" : { "lat" : 41.3483129, "lng" : 2.0382564 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "18 m", "value" : 18 }, "duration" : { "text" : "1 min", "value" : 5 }, "end_location" : { "lat" : 41.3468516, "lng" : 2.039226 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer Miguel de Cervantes\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "yqj{F}gmK^G" }, "start_location" : { "lat" : 41.347008, "lng" : 2.039190800000001 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 254 }, "duration" : { "text" : "2 min", "value" : 122 }, "end_location" : { "lat" : 41.3474717, "lng" : 2.0421458 }, "html_instructions" : "Gira a la \u003cb\u003eizquierda\u003c/b\u003e hacia \u003cb\u003eCarrer Vermell\u003c/b\u003e", "maneuver" : "turn-left", "polyline" : { "points" : "ypj{FehmKk@eE?CYqCAKAK?IYwBCIGe@Ka@" }, "start_location" : { "lat" : 41.3468516, "lng" : 2.039226 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "37 m", "value" : 37 }, "duration" : { "text" : "1 min", "value" : 33 }, "end_location" : { "lat" : 41.3473035, "lng" : 2.0425347 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eRambla Rafael Casanova\u003c/b\u003e\u003cdiv style=\"font-size:0.9em\"\u003eEl destino está a la izquierda.\u003c/div\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "utj{FmzmK@kA" }, "start_location" : { "lat" : 41.3474717, "lng" : 2.0421458 }, "travel_mode" : "DRIVING" } ], "traffic_speed_entry" : [], "via_waypoint" : [] } ], "overview_polyline" : { "points" : "cvf|FscaL{@TkAbBsCdEwGrJqHpK}CpEqBvCa@TM@IFGd@PXJBr@v@h@fBRjBAbBOlAKXKLARQAKZk@x@}BbCoFtKyGdN_BtD}CfIDj@Rb@~@zAjAlCdAhBj@n@p@\\\\@fBo@lHwCtAe@XBLHFPBT[pBMfAcAEq@tBIT@l@g@PUTI@?d@Cr@[p@qBxDsAvBo@b@YHKZ@@PTPDPFRVlG~LBj@L\RHRCNSD@Hi@\i@l@a@l@Ib@Fd@Xb@@rBjElCdH|@xCrBpJd@dCNXd@CzBjNbAfINd@f@jHLhBjAjOnA|JrAdHjBjI~BvInBjHxBhJtBbMfApKf@xJLdJCnHc@tLaBpQqDn\i@pJMdKRL@rGd@rEt@hFAjFjC|JzAfE~ArDvCtFjErGEtEnExDbBjAtD~B|EpCpFpDnE~DlApAD~DrErHbHhNnAxB|BhDdBvBvCbDxCjCjCnBBbAD~AhBr@D|@jFhAhD~@vAh@hDpBfHjHzAfC~@pBlAbDb@|Ar@~Cb@~Cd@FL|EIdH[vEeAtMMhE?~FZxIfApJp@rDjAxEnBtFxCrGClEfIjMhGjItChDjGdHtHnHxAhBbAxAhC~EdAtABpABp@d@HhALBEnAWnBiAjAy@t@_ArD_GvAwAdBaArBk@bBKpBJnBb@zBdAvBdAhAZv@Dh@IBy@lBiB|AqARWFOtBcAdAk@~DaCnFcDfEyBBw@fCeArIqCpCq@|GmAlX{ChKkBrG{AfPyFnHcD~U{Kra@}RbLiFbXoMdC_BhCmBCoBbKsI|EeDCoAdFqBfA]vIqBjFsApDuA~C{AjGoDhGeD~Ao@bDeAdHiBNmDjEmAxCgAt@e@@AdDaBBw@fH{BpCqAnJiHvKwHxCgCnAgBAsBvBmF|BiF\\oAvA_DdAiDbDoMxBuIz@mC~AwDtBwDtCsDrBqB~DoCpEoB~EoAlFm@lKY|Dc@nFcBzAq@X?|CcBnBaBjCsCvAoArA[vCJjC_@~@Kh@Bn@Rv@d@vBBlBbADjAvAb@~BA~ErBZLx@ZvA|@f@t@NzAIfC]rB@dBgBxDmElHkBlDeBzFaBrEeEbKi@rBWhBO|AQvDKhB@d@MFMd@FTJH\Gp@Wf@WdB{A~FyFv@}@b@|DVdCKnAIHEJ?ZJTRFXQFWEYGGWsAEi@|@UxD_APGE{A^Gk@eEYuC]yCKo@Ka@`@kA" }, "summary" : "AP-7", "warnings" : [], "waypoint_order" : [] } ], "status" : "OK" }

while when trying to get the same key for the following result, it fails:

{

"geocoded_waypoints" : [ { "geocoder_status" : "OK", "place_id" : "ChIJW7PrdQMzuxIRMiwBf67oi2I", "types" : [ "street_address" ] }, { "geocoder_status" : "OK", "place_id" : "ChIJ5TluBRq9pBIRcfg0abGEV4Y", "types" : [ "street_address" ] } ], "routes" : [ { "bounds" : { "northeast" : { "lat" : 41.6899489, "lng" : 2.4930568 }, "southwest" : { "lat" : 41.4456031, "lng" : 2.1749674 } }, "copyrights" : "Map data ©2022 Inst. Geogr. Nacional", "legs" : [ { "distance" : { "text" : "42,9 km", "value" : 42885 }, "duration" : { "text" : "35 min", "value" : 2096 }, "duration_in_traffic" : { "text" : "32 min", "value" : 1905 }, "end_address" : "Carrer de Romaní, 4, 08042 Barcelona, España", "end_location" : { "lat" : 41.4463935, "lng" : 2.1749674 }, "start_address" : "Carrer Anselm Clavé, 1, 08470 Sant Celoni, Barcelona, España", "start_location" : { "lat" : 41.6899489, "lng" : 2.4928271 }, "steps" : [ { "distance" : { "text" : "28 m", "value" : 28 }, "duration" : { "text" : "1 min", "value" : 5 }, "end_location" : { "lat" : 41.6897631, "lng" : 2.4930568 }, "html_instructions" : "Dirígete hacia el \u003cb\u003esureste\u003c/b\u003e en \u003cb\u003eCarrer del Callao\u003c/b\u003e hacia \u003cb\u003eCarrer de Sant Antoni\u003c/b\u003e", "polyline" : { "points" : "eqm}Fe{eNd@m@" }, "start_location" : { "lat" : 41.6899489, "lng" : 2.4928271 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 256 }, "duration" : { "text" : "2 min", "value" : 94 }, "end_location" : { "lat" : 41.6884518, "lng" : 2.4905248 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer Sant Josep\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "_pm}Fs|eNLZRd@P^h@lABDXp@Th@Xz@JXDHDJRf@N\Xn@BF" }, "start_location" : { "lat" : 41.6897631, "lng" : 2.4930568 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,2 km", "value" : 179 }, "duration" : { "text" : "1 min", "value" : 40 }, "end_location" : { "lat" : 41.6897421, "lng" : 2.4892344 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer de Sant Martí\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eBV-5114\u003c/b\u003e\u003cdiv style=\"font-size:0.9em\"\u003eContinúa hacia BV-5114\u003c/div\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "ygm}FwleN[Xi@n@QPg@h@CBy@v@OLe@b@ML" }, "start_location" : { "lat" : 41.6884518, "lng" : 2.4905248 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,3 km", "value" : 322 }, "duration" : { "text" : "1 min", "value" : 70 }, "end_location" : { "lat" : 41.6875467, "lng" : 2.486972 }, "html_instructions" : "Gira a la \u003cb\u003eizquierda\u003c/b\u003e hacia \u003cb\u003eCarrer Campins\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eBV-5114\u003c/b\u003e", "maneuver" : "turn-left", "polyline" : { "points" : "{om}FudeNL^BHDJX~@FNZv@N@Xj@HHn@^LFFBpAn@^P@RJDdAd@" }, "start_location" : { "lat" : 41.6897421, "lng" : 2.4892344 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,6 km", "value" : 645 }, "duration" : { "text" : "2 min", "value" : 123 }, "end_location" : { "lat" : 41.6825573, "lng" : 2.4878575 }, "html_instructions" : "Gira a la \u003cb\u003eizquierda\u003c/b\u003e hacia \u003cb\u003eAv. Hospital\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eBV-5114\u003c/b\u003e\u003cdiv style=\"font-size:0.9em\"\u003eContinúa hacia BV-5114\u003c/div\u003e", "maneuver" : "turn-left", "polyline" : { "points" : "ebm}FqvdNHc@@I@EHg@V{ANaAX@Z?j@@d@@T@L?R@RAP@H?JAN?j@@j@@nBBP@dBD@?\\?V?@?F?~@B@?@@B?B@B@B@B@BBBDHJJJHJ?@BFDFHDHBF?F?FA@AJCLIRIPK" }, "start_location" : { "lat" : 41.6875467, "lng" : 2.486972 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,2 km", "value" : 191 }, "duration" : { "text" : "1 min", "value" : 19 }, "end_location" : { "lat" : 41.6811594, "lng" : 2.4866589 }, "html_instructions" : "Toma el ramal \u003cb\u003eC-35\u003c/b\u003e en dirección \u003cb\u003eBarcelona\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eGranollers\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eCardedeu\u003c/b\u003e", "maneuver" : "ramp-right", "polyline" : { "points" : "_cl}Fc|dNF@@?F?DAF@D@@?@?@@@@B@BB@@FFBB@@@@DDJDLBLBD@FBFDJFHJHHFJHLLPHNPXNTJNNNBD" }, "start_location" : { "lat" : 41.6825573, "lng" : 2.4878575 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,4 km", "value" : 410 }, "duration" : { "text" : "1 min", "value" : 28 }, "end_location" : { "lat" : 41.6777099, "lng" : 2.485128 }, "html_instructions" : "Mantente a la \u003cb\u003eizquierda\u003c/b\u003e y pasa a \u003cb\u003eCarrer Trentapasses\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eC-35\u003c/b\u003e.", "maneuver" : "keep-left", "polyline" : { "points" : "gzk}FstdNRN@?@@@?HA?@RPNLFBXPTLVJD@ZJD@B@H@r@JtC@pATXFTDPFTHTJPJBBTNNLFDFHLL" }, "start_location" : { "lat" : 41.6811594, "lng" : 2.4866589 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,2 km", "value" : 229 }, "duration" : { "text" : "1 min", "value" : 19 }, "end_location" : { "lat" : 41.6765589, "lng" : 2.4828773 }, "html_instructions" : "Toma el ramal en dirección \u003cb\u003eC-61\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eArenys M.\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eVallgorguina\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eE-15\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eAP-7\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eBarcelona\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eGirona\u003c/b\u003e", "maneuver" : "ramp-right", "polyline" : { "points" : "udk}FakdNFV@BBHNXLTTf@Xl@HN\t@^v@h@jAJR@B@D@B@F@F@X" }, "start_location" : { "lat" : 41.6777099, "lng" : 2.485128 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,1 km", "value" : 120 }, "duration" : { "text" : "1 min", "value" : 16 }, "end_location" : { "lat" : 41.6758414, "lng" : 2.4830801 }, "htmlinstructions" : "En la rotonda, toma la \u003cb\u003etercera\u003c/b\u003e salida en dirección \u003cb\u003eC-61\u003c/b\u003e", "maneuver" : "roundabout-right", "polyline" : { "points" : "o}j}F}cN?B?D?B?@?@@B?B@B?B@B@B@B@@@@?@@@@@B@DBB@B?B@B?B?BABABA@ABABC@C@CBC@C@E?C@I?C@EAE?C?Az@a@" }, "start_location" : { "lat" : 41.6765589, "lng" : 2.4828773 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "53 m", "value" : 53 }, "duration" : { "text" : "1 min", "value" : 7 }, "end_location" : { "lat" : 41.6754537, "lng" : 2.4827955 }, "html_instructions" : "Gira ligeramente a la \u003cb\u003ederecha\u003c/b\u003e", "maneuver" : "turn-slight-right", "polyline" : { "points" : "_yj}Fg~cN@@@@B?@ADAD?@?@?@?D@B@BBBBDBDDR@" }, "start_location" : { "lat" : 41.6758414, "lng" : 2.4830801 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "24,6 km", "value" : 24649 }, "duration" : { "text" : "14 min", "value" : 864 }, "end_location" : { "lat" : 41.5581787, "lng" : 2.24598 }, "html_instructions" : "Incorpórate a \u003cb\u003eE-15\u003c/b\u003e/\u003cwbr/\u003e\u003cb\u003eAP-7\u003c/b\u003e por el ramal en dirección \u003cb\u003eBarcelona\u003c/b\u003e", "polyline" : { "points" : "qvj}Fo|cNDRHVLXRd@JJPVFDFFB@FBLDJBT\\BBBBJDRHTHRFHBVF@?XDL@VBD@D?P@PDPBVHLDDB@@BB@@DDFFDF@@FJHRJTHR?@BD?@hADpArDZz@f@|A~@jCBFAjCFN@B@BVTN@HTBHv@nBXt@@~@b@fAXl@|@pBAvBNXNZZl@Zl@Td@@@JPP\fCfEj@AZf@x@nAx@jAl@z@~AvBDF~AtBzD|EjDjEp@~@LNb@n@j@|@T^RZ\\j@\\r@f@dAn@xA\\x@FNTn@@nAZdAZhAVfAPt@TbAN~@Jf@XjBt@fFJr@Hl@Jl@^CV~A@pBb@pBb@hBFRNj@HTV~@HVFPPh@BF^jAXt@\z@Vj@JVFNVl@Vf@Vj@Xl@HNLTT@f@~@@n@f@v@l@|@p@~@RZPTNNDFv@ADtDlB|BPPNP~CENRAzAbAbBHLT@d@z@f@fAr@|AXp@Tn@Rf@JXFLd@rA^fATt@ZfAr@dC@DLh@h@rB\\~Af@zBBPJj@Ll@Hh@@@V|APAJp@^hCVnBNrABPD^@JDTn@GVhCPfB\\pDDd@Ht@dAfLLxALpAb@tDPrA\\hC^bCJh@\\hBX|An@pCJd@V~@|@bDTp@d@|AZ~@@hADJ\x@@Dn@xAb@Av@|Av@xAz@xARZ\\h@X@DHnBnCd@l@|ApBAlA~@lAj@p@bAtAj@t@h@t@@B|@rA~AjCd@z@BFPZT@d@dARb@f@jATh@Zt@?@@fA^dAPf@Nf@z@rCFTFTt@jCPr@XAJb@ZAv@dC\\dAd@lAv@nBDLp@zAd@~@f@~@~@fBt@pAP\\f@z@Xf@fAlBTd@p@rAl@tAf@hA^ARn@Rl@DHJ^Tv@^rAXtAVlA^vBBPPfAVzBNdBHdAJbB?HFvAFvBHhD?@@@@v@FdEFC@T@XBv@DjAHrAFlALrAJfAJx@D@F@ZjBRfAb@lBVdAZfAn@nBZz@h@rAFNp@xAv@bBhAxBn@lADFPZDFJP^r@p@pA^p@@v@p@nAj@jAp@~AVj@Vl@^|@b@pAXv@h@dBZfAXdAVfAb@lB@nB?DDRJj@Hf@ZrBXrBLlA^vELxAHvAB\\NrCFpAFpAL|CBn@Dt@HBJvBJxAHAFl@Fj@B\\DZBPL~@DZTtAX~ARx@RAXbA\lAL^Rl@Xr@Vp@d@fAJR\t@f@~@Vd@@p@b@p@n@|@n@x@p@x@v@~@vCbD@@v@|@~@nAh@v@j@z@p@jAZl@@z@b@~@Xp@Vn@@AACr@hBLXr@~A@z@P\\@v@Zj@LTVd@lAlBr@dA@h@RVNTPRJLJNpAzAAbAr@p@XXv@p@zAnAj@b@d@^RLPLpA|@BfA~CvB~BbB~@r@xAhAhA|@jAbAdA~@p@n@dAbAfAjAd@d@j@n@FHdAnANPr@|@Z@r@ATXpAjBPXRZ^h@z@tAn@hAT^pAdCR^P\\x@~ATd@T@JTl@nA^A@hAPb@DJr@dBd@pAZx@FP@Dx@xBt@xBRl@Vt@\fA?@b@rADNXAHVV|@Nh@Nh@Lf@VAHZDN\vA@DJd@\vAPt@VlANj@DTFTf@dCFXx@xDt@tDLr@XxALl@@vBPx@Jf@Jf@j@rCZ~ALl@Jj@@?t@pDLj@Lj@Rz@r@~CNj@\\vAl@CDPRv@Lf@b@~Ad@|Ad@zARn@Rn@ZbA\fAh@|ATp@zAbE@FBFZz@BFHPHVXx@Nb@x@~Bf@lADJn@jAR^\h@X@R\\x@nAJLR\\b@r@p@hA@r@\n@f@|@fAhBZd@f@v@h@z@|@tA^h@V@@BAxA@h@\\f@n@z@X@@BV\p@AB|Bp@~@bB~BzDxFl@|@NR|@vA|@zA|@bBjA~Bj@rAN\N^Zv@\bARj@ZbAVx@Pp@d@jBBNR~@h@tCBHTzABNF\A~GPnAPlAPjAJh@F\\Ll@Jb@@FJb@b@bBn@nBBFN@Xl@Rd@HNJTj@dAf@z@f@t@p@z@X^XVVXfAbAd@b@b@Zf@\TLdAn@f@T?@t@ZLD^NJDj@Pj@Nd@Lr@LRDLBTBPBNB^D|@Hv@FnAJp@Bx@Fl@Bh@Dd@Dx@Ff@Dt@Jv@H@Hr@Lb@J^J^Jt@T\\Ln@Vn@Zj@Xf@VJFRLLHv@h@f@@p@j@j@f@FHZZp@t@d@j@NTx@lAd@t@PVPZ^r@@@n@vAXp@@fANf@HTBHBFJVVz@f@~A@|AJ\Vz@BJTv@Tt@x@hCPf@J\Vn@Td@\t@j@jAJVHL?@T@h@z@n@ALRAxAh@t@NRjCvD~@vAh@x@f@z@Zj@JPf@Ab@Ab@bAn@|APd@N@^fAFPTr@V~@\nAVhAVlALj@F^Px@BLRnAPdAPvAPnANpARnBRrBTbCHjALnBHhAH~AJlBFxAHxBDxBDdB@l@@n@?H@d@@fA@~A@dB@bB?lB?|B?|A?vA?^?j@?BAz@?bA@dA@tADnB@n@@b@DtADnAFnA@JB\Dn@JhADZHt@TfBd@tC" }, "start_location" : { "lat" : 41.6754537, "lng" : 2.4827955 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "14,4 km", "value" : 14394 }, "duration" : { "text" : "9 min", "value" : 555 }, "end_location" : { "lat" : 41.4485277, "lng" : 2.1880931 }, "htmlinstructions" : "Mantente a la \u003cb\u003eizquierda\u003c/b\u003e para continuar por \u003cb\u003eC-33\u003c/b\u003e", "maneuver" : "keep-left", "polyline" : { "points" : "sys|FktuLDRFVHb@@F@BTjAf@nBd@fBNh@?@d@tAX|@n@hB@hARh@BDVl@P\\NZ\\r@d@x@Vd@R\\FHLTj@~@V@l@~@j@x@TZl@t@f@p@^@RTTVDDRRFHTTFDJJTRVV@@^\\p@f@\\VVPNJLHPJHFVNRLb@T@Rd@Tz@\fA@JDh@N@LZHXFr@PLBrAXb@JD@b@HRFLBb@JB@x@R~@Tx@XTHHBVJb@Nr@\dAh@FDTNVNNHTPb@ZTP\Xl@h@RRXX\@VVTXl@t@X@b@p@TZT@T^JRJTLPJTRb@jAzBJTd@|@b@z@b@z@T^R^PX@@T^X@PXFFf@p@JNX^FHRTDDj@n@l@l@l@h@@@\Xl@d@NJJH\TZRVN^TdB~@FBt@@B@p@Zv@b@@Rn@ZFDVLh@XJFRJDDz@d@p@@\\Tn@@@Xf@\\PLNJ~AtAhE~DhDfDtAjAn@j@vBjBRRd@b@XTtE|DlAAj@d@vGlFxFhELHzBBFDt@h@dAt@JHxBzALH~AdAnBpAjAv@VP@?@@xA~@|DbCpAv@tAz@lAr@|@f@JHhCzArAv@pAr@n@^~BtAf@Z@RlAr@tAx@rAv@FB@@DB^TLFDBJFLHDBf@Xn@^@?LH^RxFfDlDvBfAj@zD|BpA~@\Xn@b@tB|AnBxAv@j@f@^ElCx@v@PL@@RNz@t@XV\\Zr@n@zA~AJJpBzBp@v@hApAbBpBb@h@X^fC~C|@bAt@Av@~@X\d@h@BpBt@~@RRFHpA|APTv@x@^@@b@Z\\FFx@x@x@x@JJp@l@FFh@f@x@r@BBJHB@XTNJr@j@rAAf@ZfAp@j@Zf@Vf@Vl@Zr@Zn@V\J^NF@JDHBHBt@Tj@Lt@PnATxBZTD|ARj@HfBVj@Hf@HXHVHZHh@R\LXLLFZPNHLHXRj@d@h@d@PPX\Z\@l@@r@DFVb@h@dAj@jATd@@Bh@fANZDF\j@PZFJV^b@f@PRLNXXVVVRTPXT\Rd@X\Pf@Tl@TPFPFVDj@NVFP@d@Hn@Fj@Dl@Bp@BR?\@V?VA|@AAEN?ZC~@GnAKpAKLC^CbBOjAKLAdAGd@EN?F?@AT?B?DAB?x@An@A^@\\?B?F@N?F?F@D?P@J@H?ZBD?ZD@?B?TBTBL@F@@@ZDTDRDLB^HTDJBLDJBLBRFVHFBf@RRFj@Vl@Vf@Vb@THDVNRLTNZPPLp@b@h@@j@d@XTp@h@PNb@@lAfAt@p@Z\\FDRT@@RRdAhA?@RR\\^l@l@l@n@HJJJPRHHVTBDd@h@\\^^^DDDD@@FF@@fA~@d@^TLTLXPp@\\^N\\L@Lj@LB@@?FBD?JBl@H`@Fh@BT@^?F?J?B?N?DAH?J?ZCHA~@KNCl@Mv@SLGd@Q?AHC@APG@AJEf@W\SVOXUDCh@e@d@e@HIJKh@m@FGp@u@HOFKPSb@a@TWRO\]p@g@HIXOHG^QJGTM\Q@APIJEJEj@YHG@?\URMJIPMLIPM@AHE^WTOHG\YBAXWPOBAFINQJKZ]f@i@fAsAbBcCJO^i@JQR[R]BER@dAeBFKFKT]Va@@C?AFY@AdAgBNOJQFMHM@u@^k@FKb@k@h@o@TSDETUNKHGFENIROp@_@FCfAc@PGz@YPCXIh@Mn@MTEHCNCNCT?TDrAKb@E^EP?z@?H?B@r@Bh@Dn@@Z?B?d@Av@B@@bAJr@F@?r@Ht@N^FJ?JBZFt@HdAXj@P" }, "start_location" : { "lat" : 41.5581787, "lng" : 2.24598 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "61 m", "value" : 61 }, "duration" : { "text" : "1 min", "value" : 12 }, "end_location" : { "lat" : 41.4486047, "lng" : 2.1873737 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer de Platja d'Aro\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "il~{FqjjL@H?PCP?DADAFARALCH?@" }, "start_location" : { "lat" : 41.4485277, "lng" : 2.1880931 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,2 km", "value" : 180 }, "duration" : { "text" : "1 min", "value" : 32 }, "end_location" : { "lat" : 41.4470477, "lng" : 2.186812600000001 }, "html_instructions" : "Gira a la \u003cb\u003eizquierda\u003c/b\u003e hacia \u003cb\u003eCarrer de s'Agaró\u003c/b\u003e", "maneuver" : "turn-left", "polyline" : { "points" : "wl~{FafjLJ@H@f@LbCj@LBFBz@TJBTN" }, "start_location" : { "lat" : 41.4486047, "lng" : 2.1873737 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,9 km", "value" : 857 }, "duration" : { "text" : "2 min", "value" : 106 }, "end_location" : { "lat" : 41.4456031, "lng" : 2.1767563 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eVia Favència\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "ac~{FqbjLDv@@T@XLlCFxA?H@J@ZFx@Bf@@\Bn@Bf@@ZJ~A@VF|@@JD~@@F?D?D?H?H?F?D@b@?V@T?LFn@Dl@Dj@Dp@@PJtA@H?HBL@TF|@Hl@BXBR@DF^VnBBTVzATpA@HZ~ADP" }, "start_location" : { "lat" : 41.4470477, "lng" : 2.186812600000001 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "44 m", "value" : 44 }, "duration" : { "text" : "1 min", "value" : 16 }, "end_location" : { "lat" : 41.4459671, "lng" : 2.1765501 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer de Jaume Pinent\u003c/b\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "_z}{FwchLk@ZIFSD" }, "start_location" : { "lat" : 41.4456031, "lng" : 2.1767563 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "0,1 km", "value" : 114 }, "duration" : { "text" : "1 min", "value" : 30 }, "end_location" : { "lat" : 41.4469223, "lng" : 2.1764278 }, "html_instructions" : "\u003cb\u003eCarrer de Jaume Pinent\u003c/b\u003e continúa hacia la \u003cb\u003ederecha\u003c/b\u003e hasta \u003cb\u003eC/\u003cwbr/\u003e del Pla de Fornells\u003c/b\u003e", "polyline" : { "points" : "i|}{FmbhLc@EkBSm@p@" }, "start_location" : { "lat" : 41.4459671, "lng" : 2.1765501 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "69 m", "value" : 69 }, "duration" : { "text" : "1 min", "value" : 28 }, "end_location" : { "lat" : 41.4468784, "lng" : 2.1756069 }, "html_instructions" : "Gira a la \u003cb\u003eizquierda\u003c/b\u003e hacia \u003cb\u003eCarrer de les Torres\u003c/b\u003e", "maneuver" : "turn-left", "polyline" : { "points" : "gb~{FuahL?H?L@V@VBzA" }, "start_location" : { "lat" : 41.4469223, "lng" : 2.1764278 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "11 m", "value" : 11 }, "duration" : { "text" : "1 min", "value" : 11 }, "end_location" : { "lat" : 41.4467882, "lng" : 2.1756711 }, "html_instructions" : "Gira a la \u003cb\u003eizquierda\u003c/b\u003e en la 1.ª bocacalle hacia \u003cb\u003eCarrer de Jaume Pinent\u003c/b\u003e", "maneuver" : "turn-left", "polyline" : { "points" : "_b~{Fq|gLPK" }, "start_location" : { "lat" : 41.4468784, "lng" : 2.1756069 }, "travel_mode" : "DRIVING" }, { "distance" : { "text" : "73 m", "value" : 73 }, "duration" : { "text" : "1 min", "value" : 21 }, "end_location" : { "lat" : 41.4463935, "lng" : 2.1749674 }, "html_instructions" : "Gira a la \u003cb\u003ederecha\u003c/b\u003e hacia \u003cb\u003eCarrer de Romaní\u003c/b\u003e\u003cdiv style=\"font-size:0.9em\"\u003eEl destino está a la izquierda.\u003c/div\u003e", "maneuver" : "turn-right", "polyline" : { "points" : "ma~{F}|gLJTFPHLZn@Rd@@?" }, "start_location" : { "lat" : 41.4467882, "lng" : 2.1756711 }, "travel_mode" : "DRIVING" } ], "traffic_speed_entry" : [], "via_waypoint" : [] } ], "overview_polyline" : { "points" : "eqm}Fe{eNd@m@LZd@dA|AnDrBhFsFrFMLL^HTlAhDb@t@|@f@zCxApAj@Jm@r@kErEFpGHhGH\R|@~@xAg@h@BZXdA@hAxAxAfBfBbAlA^tHjArAb@z@l@d@t@zBxE~AtDBr@JX\\LZQLi@AIz@c@H@^Db@n@p@jBl@p@d@Nh@j@fA^vBVvAd@|@BbHdSnAfDr@pAtHnQlChFhGKlEfGxN~QrB|CvBEjBrEpBfHbAFjEvXrCzKxCbIvDvHdFnHxIfKGbIhCnEjCfGlAbDdCjI|CjNhCjQjBfQdEjb@fBLlBtItCrJfAtCbErIfCEjN|QtCbEzCjFjEKtEtOxBlHCpG~DbIhCrE|D|HnBhFfAtDtAlHbAnJZ|H@|SZdHj@vFzAbI~BxHzCHpCjFbGdLCvFbCvHrCxMbBlOZnElAtWAKhAjGxArFjBzEhBnDdDzEbG~GlEGrCtFlHdQ|AvCzDbGtGpHvJxHMvItHjGnJKpHfKhIhOnBhElB~EfFzNxFlSzJve@pDnQdEjQtE|O~EnN|@fCvCdH|ExHnInNhHlKxO|TxDdGdEtI|AfEjBzGdAnFbBhLbBbKB~FA|BhBfDlChDhD|CjDpBlFhBjFr@jLv@vDd@vCp@rDvArBfA~CCCbCtCdEdAhBxCxHtDlMnB~FjB~DrFrIdG|IvBzDhChGlAnDpCzLhA|HlAxLj@dJb@zLPO@tQPtPt@tKlBdL|AbGpCfIlDjH|EtHEzEjDzCzCpBfD|A~CdAxGxArGfBtFlCxEzDbFzGrDfHEpH|CdElClC|AlAH~DhG~CbGrDhDlCxN~MjExDfRrOlSO~KlH~g@pZdNIbOJrHtFzIpGbBtAfEbExFpGnN~PtJfLvGxGhDtCvFzDhDfBhE~AfFjAxG~@tEt@zBt@rAp@|BhBhBzBhBdDrDhHlD|DrBtAdCdAlBd@rCXpCHnDI~K{@tF]nGB|BRrCh@nCz@nFhCvGzErFfFxJlKdEvDvBjAjCx@xC^lB?pBQbCm@xBaAtA}@dBaBEuElB_BnAq@tCyAjGoEf@i@nF_H|DqGhAyB|DsGhBuBv@o@|A}@fDiAhCk@~@KhBEbAKxD@lHNzGx@bE|@Ar@Gn@Cj@TBEAfAXTNDv@Bn@TfFJjBd@nJHzBVnFb@nGnAbJx@lEu@b@w@?kBSm@p@?VBn@BzAPKRf@d@|@Td@" }, "summary" : "AP-7 y C-33", "warnings" : [], "waypoint_order" : [] } ], "status" : "OK" }

Is there any update you are currelnty working that can fix this malfuntion?

Thanks

Lx commented 2 years ago

*sigh*—another day, another @mention in someone's binary dump...

ab commented 2 years ago

Lol it didn't occur to me to seek out the secret fellowship of people who receive these. :joy:

sandeepshenoyh commented 2 years ago

if the json begins are an array the parser throws an error to read key value pair.

houghtonap commented 2 years ago

@sandeepshenoyh

VBA-JSON maps a JSON array to a VBA.Collection not a Scripting.Dictionary, so when you try to do the following you should get an error:

Dim json as Scripting.Dictionary
Set json = ParseJson("[1,2,3]") ' this produces an error since you are assigning a value to the wrong type of object.

What you want to do is use a VBA.Collection as the following demonstrates:


Option Explicit

Public Sub test()

  Dim json As VBA.Collection

  Set json = ParseJson("[1,2,3]")

  Debug.Assert json.Count = 3
  Debug.Assert json(1) = 1
  Debug.Assert json(2) = 2
  Debug.Assert json(3) = 3

  Exit Sub
End Sub