pcsoft.us.windevCopyright 2026, PC SOFT15 Oct 2017 21:29:00 Z15 Oct 2017 02:07:00 ZHi, I'm trying to get a handle on how to parse a JSON data payload. I'm able to use JSONToVariant to convert payload to JSON and then VariantToJSON to convert back into JSON and this seems to confirm that the payload stays in tact but I'm having problems figuring out how to deal with a JSON structure that is multi -tiered Below is an example file. How would I navigate down to the "itinerary_days" section and then loop through the individual days? There seems to be a lot more capabilities in WD for moving around an XML file than there is for JSON but maybe I'm missing something? { "id":540, "title":"14-Day Ultimate Namibia Safari", "itinerary_days": [ { "DayNbr":1, "Title":"Day 1" },{ "DayNbr":2, "Title":"Day 2" },{ "DayNbr":3, "Title":"Day 3" },{ "DayNbr":4, "Title":"Day 4" },{ "DayNbr":5, "Title":"Day 5" },{ "DayNbr":6, "Title":"Day 6" },{ "DayNbr":7, "Title":"Day 7" },{ "DayNbr":8, "Title":"Day 8" },{ "DayNbr":9, "Title":"Day 9" },{ "DayNbr":10, "Title":"Day 10" },{ "DayNbr":11, "Title":"Day 11" },{ "DayNbr":12, "Title":"Day 12" },{ "DayNbr":13, "Title":"Day 13" },{ "DayNbr":14, "Title":"Day 14" } ] }30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62949/read.awp15 Oct 2017 21:29:00 ZQuote Alen U. Hi Steve, here is solution sText is ANSI string=fLoadText("c:\ emp\jsontest.json.good.txt") vItin i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62949/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62949/read.awpParsing Jsonguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62948/read.awp15 Oct 2017 21:02:00 ZHi Steve, here is solution sText is ANSI string=fLoadText("c:\ emp\jsontest.json.good.txt") vItin is Variant=JSONToVariant(sTe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62948/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62948/read.awpParsing Jsonguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62947/read.awp15 Oct 2017 20:04:00 ZHi Fabrice, I've gotten far enough along to see that there are 14 elements within the variant member "itinerary_days" but I'm…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62947/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62947/read.awpParsing Jsonguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62946/read.awp15 Oct 2017 13:41:00 ZHi Steve, If I remember correctly, you just do a for each loop inside a for each loop for each sublevel. best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62946/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62944-parsing-json-62946/read.awpParsing Json