pcsoft.us.windevCopyright 2026, PC SOFT30 Apr 2016 12:36:00 Z27 Apr 2016 16:52:00 ZHello all, I had a simular question before with JSON, now i have a web API to receive dutch adres information and can't exctract a JSON string with JSONTOVARIANT(). Below the json data i receive. Is there anyone with a solution? I tried a lot of things but nothing works! {"_embedded":{"addresses":[{"city":{"id":"3594","label":"Amsterdam"},"letter":null,"id":"0363200000158443","purpose":null,"postcode":"1012NX","municipality":{"id":"0363","label":"Amsterdam"},"nen5825":{"street":"KALVERSTRAAT","postcode":"1012 NX"},"street":"Kalverstraat","number":1,"province":{"id":"27","label":"Noord-Holland"},"addition":null,"geo":{"center":{"wgs84":{"crs":{"properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"},"type":"name"},"type":"Point","coordinates":[4.89214047794,52.3725040602]},"rd":{"crs":{"properties":{"name":"urn:ogc:def:crs:EPSG::28992"},"type":"name"},"type":"Point","coordinates":[121286,487296]}}},"type":"Verblijfsobject","_links":{"self":{"href":"https://postcode-api.apiwise.nl/v2/addresses/0363200000158443/"}}}]},"_links":{"self":{"href":"https://postcode-api.apiwise.nl/v2/addresses/?postcode=1012NX&number=1"}}} Thanks, Sammy30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57471/read.awp30 Apr 2016 12:36:00 ZHi Any I deas How this works if jsontovarriant is not availeble. Iam trying to do some map stuff in php modus but in php modus …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57471/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57471/read.awpJSON dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57464/read.awp29 Apr 2016 14:10:00 ZPeter, Thank you very much! My fault was in the addresses[1] :-) Now it works. Sammyhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57464/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57464/read.awpJSON dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57463/read.awp29 Apr 2016 13:44:00 ZHi Sammy, If I do a vVariant=JSONToVariant(yourstring) I get the right values in the Variant variable sJSON is ANSI string…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57463/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57463/read.awpJSON dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57461/read.awp29 Apr 2016 12:56:00 ZHello Harry, I want to extract the data, but with JSONToVariant() i don`t receive something. Mayby there is another way to e…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57461/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57461/read.awpJSON dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57460/read.awp29 Apr 2016 12:48:00 ZHi Sammy, What is your real problem... I never heard about 'JSON' data but i saw it's something like XML. Don't' you se…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57460/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57460/read.awpJSON dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57459/read.awp29 Apr 2016 11:59:00 ZNobody any experience with this? Then i start looking for another database with dutch adresses.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57459/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57459/read.awpJSON dataguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57448/read.awp28 Apr 2016 15:45:00 ZWith the code below i recieve in sAlgemeen the data as in my first post, but by Info(VAlgemeen.city.street) i recieve 0. Gelu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57448/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57440-json-data-57448/read.awpJSON data