How to Extract Attribute value from JSON output

(0) Share

Report

Posted on 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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @godala_vamshi ,

Please try this

item()?['objectTypeAttributeId']

string(926)

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

Best Regards,

Wearsky

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
godala_vamshi 174 on at

Like (0)

Report
Copy link

Link copied!

@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"
}

Was this reply helpful? Yes No