Parse JSON - Dynamic Object as field name

[Martin260]

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

[ekarim2020]

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.

[Martin260]

@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 

[ekarim2020]

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.

[ekarim2020 · Accepted solution]

Here is a working example flow:

(3) Expression for Compose Reformat:

json(concat('[',replace(outputs('Compose_String'),'},', '}},{'),']'))

(4) Select Expression for Map:

json(concat('{',replace(last(split(string(item()),'{')), '}}','}')))

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

[Martin260]

@ekarim2020 Thank you for all your help, this solution has worked perfectly.