How to get a value from nested array of object

Question

How to get a value from nested array of object

Krzysztof Nowicki 81

Json Attributes array of objects is dynamic and may change which means I cannot use Parse Json or expression function to count the position and get the value of the key "key": "mserp_dataareaid".

Payload.

{
  "BusinessUnitId": "15b8fcb2-98c7-ee11-907a-0022481b5de0",
  "CorrelationId": "0442be0b-af18-4434-8545-61cbb613eab7",
  "Depth": 1,
  "InitiatingUserAgent": "xxxxxxxxxxxxxxxx",
  "InitiatingUserAzureActiveDirectoryObjectId": "xxxxxxxxxxx",
  "InitiatingUserId": "xxxxxxxxxxxxxxx",
  "InputParameters": [
    {
      "key": "Target",
      "value": {
        "__type": "Entity:http://schemas.microsoft.com/xrm/2011/Contracts",
        "Attributes": [
          {
            "key": "mserp_tolerancefailingaction",
            "value": {
              "__type": "OptionSetValue:http://schemas.microsoft.com/xrm/2011/Contracts",
              "Value": 200000000
            }
          },
          {
            "key": "mserp_dataareaid",
            "value": "2002"
          },
          {
            "key": "mserp_engchgengineeringchangeorderproductattributeentityid",
            "value": "00002e57-0000-0000-1c52-005001000000"
          }
        ],
        "EntityState": null,
        "FormattedValues": [],
        "Id": "00002e57-0000-0000-1c52-005001000000",
        "KeyAttributes": [],
        "LogicalName": "mserp_engchgengineeringchangeorderproductattributeentity",
        "RelatedEntities": [],
        "RowVersion": null
      }
    }
  ],
  "IsExecutingOffline": false,
  "IsInTransaction": false,
  "IsOfflinePlayback": false,
  "IsolationMode": 1,
  "MessageName": "OnExternalCreated",
  "Mode": 1,
  "OutputParameters": [],
  "OwningExtension": {
    "Id": "c8d12775-d8f9-ef11-bae3-6045bd0b0c20",
    "KeyAttributes": [],
    "LogicalName": "sdkmessageprocessingstep",
    "Name": null,
    "RowVersion": null
  },
  "ParentContext": null,
  "SecondaryEntityName": "none",
  "SharedVariables": [
    {
      "key": "IsAutoTransact",
      "value": false
    },
    {
      "key": "AcceptLang",
      "value": ""
    }
  ],
  "Stage": 40,
  "UserAzureActiveDirectoryObjectId": "xxxxxxxx",
  "UserId": "xxxxxxxx"
}

Required output is the value from "key": "mserp_dataareaid" which is 2002 in this case.What is the best approach to get this value out, considering Attributes are dynamic values.

Can this be achieved with 'first' expression function?

Khadeer Ali 3,830 Reputation points Microsoft External Staff

2025-03-06T10:12:19.11+00:00
@Krzysztof Nowicki ,

You are correct about using the first expression along with filter to extract the value dynamically. I tried it, and the correct expression is:

first(filter(body('Parse_JSON')?['InputParameters'][0]?['value']?['Attributes'], item()?['key'] == 'mserp_dataareaid'))?['value']

This returns the expected output: "2002".

Could you try this on your end and let me know if it works?
Krzysztof Nowicki 81 Reputation points

2025-03-06T10:40:56.3566667+00:00
Expression is not valid. Taking the value out of the Compose Message as

"inputs": "@first(filter(outputs('Compose_Message')?['InputParameters'][0]?['value']?['Attributes'], item()?['key'] == 'mserp_dataareaid'))?['value']"

Error
Khadeer Ali 3,830 Reputation points Microsoft External Staff

2025-03-06T10:50:19.38+00:00

@Krzysztof Nowicki ,

I’d like to better understand your Logic App workflow before suggesting a solution. Can you share how you’re currently processing this JSON? I can try replicating it on my side and suggest an approach that works best.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Krzysztof Nowicki 81 Reputation points

2025-03-06T11:15:28.3566667+00:00

I'm receiving the json from the service bus topic, then use decodeBase64 to read the message to the plain json in Compose Message and finally I'm setting the variable with the value of "key": "mserp_dataareaid"
Loknathsatyasaivarma Mahali 710 Reputation points Microsoft External Staff

2025-03-06T17:10:55.0133333+00:00
Hello Krzysztof Nowicki,

One alternative approach you can consider is using the 'apply to each' loop combined with a condition to iterate through the dynamic array of objects and extract the value of "mserp_dataareaid" when the key matches.

Here is a step-by-step guide to help you extract the value of "mserp_dataareaid" using the 'apply to each' loop:

After decoding the JSON message using decodeBase64 and storing it in a Compose Message action, add an 'apply to each' loop to iterate through the dynamic array of objects.

Within the 'apply to each' loop, add a condition to check if the current object's key is equal to "mserp_dataareaid".

If the condition is met, extract the value associated with the key "mserp_dataareaid" and store it in a variable.

By using the 'apply to each' loop with a condition, you can dynamically search for the key "mserp_dataareaid" within the array of objects and extract its corresponding value.

1 answer

Your answer

Khadeer Ali 3,830 Reputation points Microsoft External Staff

2025-03-06T10:12:19.11+00:00

@Krzysztof Nowicki ,

You are correct about using the first expression along with filter to extract the value dynamically. I tried it, and the correct expression is:

first(filter(body('Parse_JSON')?['InputParameters'][0]?['value']?['Attributes'], item()?['key'] == 'mserp_dataareaid'))?['value']

This returns the expected output: "2002".

Could you try this on your end and let me know if it works?
Krzysztof Nowicki 81 Reputation points

2025-03-06T10:40:56.3566667+00:00

Expression is not valid. Taking the value out of the Compose Message as

"inputs": "@first(filter(outputs('Compose_Message')?['InputParameters'][0]?['value']?['Attributes'], item()?['key'] == 'mserp_dataareaid'))?['value']"

Error
Khadeer Ali 3,830 Reputation points Microsoft External Staff

2025-03-06T10:50:19.38+00:00

@Krzysztof Nowicki ,

I’d like to better understand your Logic App workflow before suggesting a solution. Can you share how you’re currently processing this JSON? I can try replicating it on my side and suggest an approach that works best.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Krzysztof Nowicki 81 Reputation points

2025-03-06T11:15:28.3566667+00:00

I'm receiving the json from the service bus topic, then use decodeBase64 to read the message to the plain json in Compose Message and finally I'm setting the variable with the value of "key": "mserp_dataareaid"
Loknathsatyasaivarma Mahali 710 Reputation points Microsoft External Staff

2025-03-06T17:10:55.0133333+00:00

Hello Krzysztof Nowicki,

One alternative approach you can consider is using the 'apply to each' loop combined with a condition to iterate through the dynamic array of objects and extract the value of "mserp_dataareaid" when the key matches.

Here is a step-by-step guide to help you extract the value of "mserp_dataareaid" using the 'apply to each' loop:

After decoding the JSON message using decodeBase64 and storing it in a Compose Message action, add an 'apply to each' loop to iterate through the dynamic array of objects.

Within the 'apply to each' loop, add a condition to check if the current object's key is equal to "mserp_dataareaid".

If the condition is met, extract the value associated with the key "mserp_dataareaid" and store it in a variable.

By using the 'apply to each' loop with a condition, you can dynamically search for the key "mserp_dataareaid" within the array of objects and extract its corresponding value.

Answer 1

Hi @Krzysztof Nowicki,,

You can use below design which does the work:

Firstly, sent input in Parse_Json:

enter image description here

Schema:


{

    "type": "object",

    "properties": {

        "BusinessUnitId": {

            "type": "string"

        },

        "CorrelationId": {

            "type": "string"

        },

        "Depth": {

            "type": "integer"

        },

        "InitiatingUserAgent": {

            "type": "string"

        },

        "InitiatingUserAzureActiveDirectoryObjectId": {

            "type": "string"

        },

        "InitiatingUserId": {

            "type": "string"

        },

        "InputParameters": {

            "type": "array",

            "items": {

                "type": "object",

                "properties": {

                    "key": {

                        "type": "string"

                    },

                    "value": {

                        "type": "object",

                        "properties": {

                            "__type": {

                                "type": "string"

                            },

                            "Attributes": {

                                "type": "array",

                                "items": {

                                    "type": "object",

                                    "properties": {

                                        "key": {

                                            "type": "string"

                                        },

                                        "value": {

                                            "oneOf": [

                                                {

                                                    "type": "object",

                                                    "properties": {

                                                        "__type": {

                                                            "type": "string"

                                                        },

                                                        "Value": {

                                                            "type": "integer"

                                                        }

                                                    }

                                                },

                                                {

                                                    "type": "string"

                                                }

                                            ]

                                        }

                                    },

                                    "required": [

                                        "key",

                                        "value"

                                    ]

                                }

                            },

                            "EntityState": {

                                "type": [

                                    "null",

                                    "string"

                                ]

                            },

                            "FormattedValues": {

                                "type": "array",

                                "items": {}

                            },

                            "Id": {

                                "type": "string"

                            },

                            "KeyAttributes": {

                                "type": "array",

                                "items": {}

                            },

                            "LogicalName": {

                                "type": "string"

                            },

                            "RelatedEntities": {

                                "type": "array",

                                "items": {}

                            },

                            "RowVersion": {

                                "type": [

                                    "null",

                                    "string"

                                ]

                            }

                        }

                    }

                },

                "required": [

                    "key",

                    "value"

                ]

            }

        },

        "IsExecutingOffline": {

            "type": "boolean"

        },

        "IsInTransaction": {

            "type": "boolean"

        },

        "IsOfflinePlayback": {

            "type": "boolean"

        },

        "IsolationMode": {

            "type": "integer"

        },

        "MessageName": {

            "type": "string"

        },

        "Mode": {

            "type": "integer"

        },

        "OutputParameters": {

            "type": "array",

            "items": {}

        },

        "OwningExtension": {

            "type": "object",

            "properties": {

                "Id": {

                    "type": "string"

                },

                "KeyAttributes": {

                    "type": "array",

                    "items": {}

                },

                "LogicalName": {

                    "type": "string"

                },

                "Name": {

                    "type": [

                        "null",

                        "string"

                    ]

                },

                "RowVersion": {

                    "type": [

                        "null",

                        "string"

                    ]

                }

            }

        },

        "ParentContext": {

            "oneOf": [

                {

                    "type": "null"

                },

                {

                    "type": "object"

                }

            ]

        },

        "SecondaryEntityName": {

            "type": "string"

        },

        "SharedVariables": {

            "type": "array",

            "items": {

                "type": "object",

                "properties": {

                    "key": {

                        "type": "string"

                    },

                    "value": {

                        "oneOf": [

                            {

                                "type": "boolean"

                            },

                            {

                                "type": "string"

                            }

                        ]

                    }

                },

                "required": [

                    "key",

                    "value"

                ]

            }

        },

        "Stage": {

            "type": "integer"

        },

        "UserAzureActiveDirectoryObjectId": {

            "type": "string"

        },

        "UserId": {

            "type": "string"

        }

    }

}

Then in 1st For each(For each):

outputs('Parse_JSON')?['body']?['InputParameters']

enter image description here

2nd for each(For each 1):

items('For_each')?['value']?['Attributes']

enter image description here

Then in condition, items('For_each_1')?['key'] is equal to mserp_dataareaid:

enter image description here

Then in Compose:

items('For_each_1').value

enter image description here

Output:

enter image description here

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.

RithwikBojja 870 Reputation points Microsoft External Staff

2025-03-10T03:20:39.58+00:00

I wanted to follow up and see if the given answer was helpful. If this resolves your issue, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.

Share via

How to get a value from nested array of object

1 answer

Your answer