Page 1 of 1
Location Path Metadata List
Posted: Fri Feb 07, 2025 12:10 pm
by schmitzdp
Hello,
is there a trick to retrieve the value following the key given in a structure like the one below?
Instead of using this way?
Code: Select all
[Metadata.Text:Dataset="Payload",Model="JSON",Path="/data/fields/2/value"]
Thank you.
Re: Location Path Metadata List
Posted: Fri Feb 07, 2025 12:40 pm
by JimmyHartington
I try to use the syntax below.
Code: Select all
[Metadata.Integer:Dataset="RollLabel",Model="XML",Path="/field-list/field[tag='TAGNAME']/value"]
This has often helped me with a submit point when adding new fields, so the number changes for the values.
Re: Location Path Metadata List
Posted: Fri Feb 07, 2025 12:59 pm
by schmitzdp
I try this but without success.
Have I made a mistake?
Code: Select all
[Metadata.Text:Dataset="Payload",Model="JSON",Path="/data/fields[key='question_8zkRMO']/value"]
or
Code: Select all
[Metadata.Integer:Dataset="Payload",Model="JSON",Path="/data/fields[key='question_8zkRMO']/value"]
Re: Location Path Metadata List
Posted: Fri Feb 07, 2025 1:18 pm
by JimmyHartington
Sorry. I missed yours data was JSON.
I think my method only works with XML.
Re: Location Path Metadata List
Posted: Fri Feb 07, 2025 2:22 pm
by freddyp
Correct, Jimmy, your method will only work with XML but it is easy to convert a JSON to XML with "JSON pickup - Pickup result - XML".