extract data from json array

[Anonymous]

Hi community,

I have a flow that receives following schema of an json object via HTTP POST request from an other flow.

schema:

{

    "type": "array",

    "items": {

               "type": "object",

               "properties": {

                   "LieferscheinID": {

                        "type": "integer"

                    },

                   "EmailEmpfaenger": {

                    "type": "string"

                   }

               }

          }

}

 the output data looks as follows:

{

  "LieferscheinID" : "1",

  "EmailEmpfaenger": "john.doe@123fakecompany.com"

}

Now, I need to extract the data as two separate variables, e.g. varID = 1 and varEmail=john.doe@123fakecompany.com

in order to use them for further steps in the flow.

How can I do that?

Thanks in advance

[abm · Accepted solution]

Hi @Anonymous 

1. Add a Parse JSON action step and set the Content mapping as output of your previous step.
2. Click Generate from Sample
3. Under Insert a sample JSON Payload copy the values from your compose step. Generally you can copy this from your run history or if you have a sample JSON data which you are going to receive.
4. Click done.
5. Next action on wards you can see all the dynamic properties from your JSON schema.