pcsoft.us.windevCopyright 2026, PC SOFT18 Oct 2015 15:41:00 Z16 Oct 2015 21:10:00 ZHello, I think a simple question, how can i extract a string what i receive from a webservice in JSON format? By example the received JSON text below, i want the "aantal_cilinders" in a string. By xml format it is very easy with XMLExtractString. [{"aantal_cilinders":"5","aantal_deuren":"4","aantal_wielen":"4","aantal_zitplaatsen":"5","afstand_hart_koppeling_tot_achterzijde_voertuig":"0","afstand_voorzijde_voertuig_tot_hart_koppeling":"0"," Thanks!30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54531/read.awp18 Oct 2015 15:41:00 ZThanks King! Works ok for me.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54531/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54531/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54530/read.awp18 Oct 2015 15:10:00 ZCase closed, pls see as below: ResStart is boolean _url is string = "https://opendata.rdw.nl/resource/m9d7-ebf2.json?kente…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54530/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54530/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54529/read.awp18 Oct 2015 13:00:00 ZThanks for the support, I do as below and receive the error The variant is not an object. ResStart is boolean _url is s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54529/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54529/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54528/read.awp17 Oct 2015 22:05:00 ZIf I were you, I'd do this as below: sJZon is ANSI string =[ {"aantal_cilinders":"5", "aantal_deuren":"4", "aantal_wielen"…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54528/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54528/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54527/read.awp17 Oct 2015 21:58:00 ZHi Pls see below example: sJZon is ANSI string =[ {"aantal_cilinders":"5","aantal_deuren":"4","aantal_wielen":"4"} ] jz…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54527/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54527/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54526/read.awp17 Oct 2015 18:02:00 ZOr is there a way to convert the JSON data to XML data? Thanks, Sammyhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54526/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54526/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54523/read.awp17 Oct 2015 08:53:00 ZI have tryed this a lot but it stil not works for me. In the Windev help i can`t find some more information.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54523/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54523/read.awpExtract JSON stringguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54521/read.awp16 Oct 2015 22:56:00 ZJSONToVariant and VariantToJSON would be my advice.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54521/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54512-extract-json-string-54521/read.awpExtract JSON string