pcsoft.us.windevCopyright 2026, PC SOFT20 Oct 2016 10:56:51 Z21 Aug 2016 13:31:00 ZAnyone using the ..Member to retrieve JSON values? My attempts have bee unsuccessful - any advice, suggestion appreciated. As a simplified example say I receive a JSON string containing 5 items [ { "ID":"65" }, { "ID":"67" }, { "ID":"71" }, { "ID":"74" }, { "ID":"76" } ]According to the Help for the ..Member property all I need to do is..... v is Variant = JSONToVariant(JSON) FOR EACH x OF v..Member Trace("The member " + x..Name + " has the value " + x..Value) ENDLine 1 is OK - the debugger shows 'v' as being 'an array of 5 variant' Double clicking this shows a 5 element array with the correct values. Line 2 however throws the error 'The variant is not an object' Question is - what needs to be done to make the variable seen as an object? I have tried declaring it locally in the procedure, global to the window, even global to the application - all fail with the same error. If I declare a structure containing 'ID' and an array for this this structure then bu using MyArray<=v fills the array with the 5 elements as expected. So not the end of the world - it just seemed that this would be a simpler way of achieving the same result30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)contactpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-60056/read.awp20 Oct 2016 10:56:51 ZHi Alexandre, thank you for the tip, I've tested it and it's missing [i] in the v[i]..membre statment if I'm not wrong, th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-60056/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-60056/read.awpJSON..Member propertyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59170/read.awp22 Aug 2016 15:55:00 ZGuys Thank you very much. As you both no doubt noticed I let myself fall into the trap of attempting to use something without …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59170/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59170/read.awpJSON..Member propertyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59173/read.awp22 Aug 2016 15:17:00 ZHi Derekt, Variants are tricky to use. Your example is composed of an array of variants. So you must consider that array firs…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59173/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59173/read.awpJSON..Member propertyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59163/read.awp21 Aug 2016 17:08:00 ZLooks like it is seeing it as an array of variants instead of as a variant. This works for me: sJSon is ANSI string = [ { "I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59163/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59159-json-member-property-59163/read.awpJSON..Member property