How to Extract Attribute value from JSON output

Like (0) Share

Report

Posted on 28 May 2024 18:32:20 by godala_vamshi

174

Hello,

I have a JSON output from a source each time with multiple objects that have several attributes, each defined by an objectTypeAttribute object. I'm trying to extract the particular value of an objectTypeAttributeId 926, which should be 386 for this example, and use that value for a condition. As we have multiple objects with the same name, objectTypeAttributeId and value, what is the best way to extract it? Thank you for your help in advance.

All responses (3)

Answers (1)

godala_vamshi 174 on 31 May 2024 at 22:19:32

Like (0)

Report

Re: How to Extract Attribute value from JSON output

@v-xiaochen-msft I just notice you passed 'objectTypeAttributeValues' in Array on your example but JSON response I'm working with will have multiple objects in below format and I don't see objectTypeAttributeValues in my JSON.
{
"workspaceId": "21b184a3-5411-4d4c-a9af-dcf7fb6c792d",
"globalId": "21b184a3-5411-4d4c-a9af-dcf7fb6c792d:121231",
"id": "121231",
"objectTypeAttribute": {
"workspaceId": "21b184a3-5411-4d4c-a9af-dcf7fb6c792d",
"globalId": "21b184a3-5411-4d4c-a9af-dcf7fb6c792d:926",
"id": "926",
"name": "ID",
"label": false,
"type": 0,
"description": "",
"defaultType": {
"id": 0,
"name": "Text"
},
"editable": true,
"system": false,
"sortable": true,
"summable": false,
"indexed": true,
"minimumCardinality": 0,
"maximumCardinality": 1,
"removable": true,
"hidden": false,
"includeChildObjectTypes": false,
"uniqueAttribute": false,
"options": "",
"position": 0
},
"objectTypeAttributeId": "926",
"objectAttributeValues": [
{
"value": "2013",
"displayValue": "2013",
"searchValue": "2013",
"referencedType": false
}
],
"objectId": "2378"
}
godala_vamshi 174 on 29 May 2024 at 04:34:06

Like (0)

Report

Re: How to Extract Attribute value from JSON output

@v-xiaochen-msft Thank you for your time on this. I have tried your suggestion but the compose output coming as blank.
I have also tried other way but still coming as blank.
Verified answer

v-xiaochen-msft on 29 May 2024 at 02:13:46

Like (0)

Report

Re: How to Extract Attribute value from JSON output

Hi @godala_vamshi ,

Please try this

item()?['objectTypeAttributeId']

string(926)

body('Filter_array')?[0]?['objectTypeAttributeValues']?[0]?['value']

Best Regards,

Wearsky