Location Path Metadata List

[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.

[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.

[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"]

[JimmyHartington]

Sorry. I missed yours data was JSON.
I think my method only works with XML.

[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".