Data Structure not linear

[sinnamora]

Hi everyone,

I need to read 2 infos from an API.

I build the flow with HTML - Compose - Parse JSON but the response of API is not linear.

The structure is like this:

                {

                    "dirty": false,

                    "displayName": "RecID",

                    "fieldId": "BO:944e02d8537d17b3384143451180f87eda564c5798,FI:944e02da60578af7d7bc4644b6ae07ed4eb2648fc3",

                    "fullFieldId": null,

                    "html": null,

                    "name": "RecID",

                    "value": "946409e58a0cd978dad85c439cbe8f7732834fc9e0"

                },

                {

                    "dirty": false,

                    "displayName": "Created Date Time",

                    "fieldId": "BO:944e02d8537d17b3384143451180f87eda564c5798,FI:944e02da60ad493eb8d4904384b4b5f3e4fd01e675",

                    "fullFieldId": null,

                    "html": null,

                    "name": "CreatedDateTime",

                    "value": "8/18/2020 3:09 PM"

                }

File with response: LINK

I need to get the value from 2 parameters named SAPCliente and AccountManager.

Is it possible? Any suggestions?

Thanks for your help.

Silvia Innamorati

[Caspar_Rubin · Accepted solution]

Hey,

maybe there is an easier way but you could do it like this:

Full Flow:

***

Explanation

First, after your Parse JSON action, create two new variables (initialize variable action). Called SAPCliente and AccountManager. Both empty strings.

Then add two nested Apply to each loops and select the dynamic content responses and fields (from the Parse JSON action) as their "output".

Then, add two Condition actions.

On the left side, use the Dynamic content name, as operator set it to is equal to and on the right side enter the text SAPCliente for the first Condition and AccountManager for the second Condition.

Then inside the If yes sections, add the Set variable actions. Select SAPCliente inside the first If yes section and Account Manager in the second If yes section.

As Value, put the Dynamic content value.

***

Test / Check

Result Compose action at the very end of the flow to check if it works:

When the flow ran:

hope this helps... 

cheers

[sinnamora]

It works!

Thank you so much 😁