Hello,
I am having some trouble with dynamic field names that are breaking the parse Json in my process. For example, if I have two different field numbers ("405", "403") If I set the schema to have the field header as "405" it will work for the first, but not the second. Is there any way to make these field headers parseable through the JSON schema?
{
"405": {
"id": 405,
"Title": "BlankUsername",
"Name": "Null"
},
"403": {
"id": 403,
"Title": "BlankUsername",
"Name": "Null"
}
}
Many Thanks in Advance
Solved! Go to Solution.
Here is a working example flow:
(3) Expression for Compose Reformat:
(4) Select Expression for Map:
(5) Apply to Each loop
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
If the data was transformed and formatted as an array as shown below, could your flow make use of the data in this format?
[
{
"id": 403,
"Title": "403BlankUsername",
"Name": "Null"
},
{
"id": 405,
"Title": "405BlankUsername",
"Name": "Null"
}
]
You could loop through each item in the array (403, 405) and reference each of the properties id, Title and Name with needing to use the Parse JSON action:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
@ekarim2020 Thanks you for this response.
Unfortunately, there is no easy way of removing this from the response string (apart from using regular expression in PAD, which usually causes the process to take a long amount of time).
I'll try to find a workaround with what you have given me in the meantime.
Kind Regards,
Martin
We can write a flow to take the data you already have and format the data as:
[
{
"id": 403,
"Title": "403BlankUsername",
"Name": "Null"
},
{
"id": 405,
"Title": "405BlankUsername",
"Name": "Null"
}
]
Could you then use that data structure within your flow? You could then reference each property
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Here is a working example flow:
(3) Expression for Compose Reformat:
(4) Select Expression for Map:
(5) Apply to Each loop
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.