Hi,
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" } ] } |