Answered

How to Extract Data From The Value of Object in JSON

(0) Share

Report

Posted on by HalimeArs

Hello Power Automate Community,

I am quite new in MS. Power Automate. I would like to extract particular data in the value of object of the array from JSON

Basically, I need to extract the specific data from the value of object which starts with "project_description" in JSON.

To be more clear, I have to get the value corresponding to "text", which is "XYZ" in this example.

Long story short, i need to get the value "XYZ".

Could you please help me out about this?

here is the sample data:

"projects": [
{
"project_id": 9,
"project_name": "Language processing",

"project_description": "{\"blocks\":[{\"key\":\"dopmg\",\"text\":\"XYZ\",\"type\":\"sharp\",\"depth\":5,\"entityRanges\":[],\"data\":{}}],\"entityMap\":{}}",

}

]

Thank you in advance for your help.

Happy automation.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Could you show your flow?

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
I'm assuming your projects array is contained within another object. The flow below also assumes you have a single project in your projects array. If you can have multiple projects, then we would need to adjust the flow to accommodate.

See full flow below. I'll go into each of the actions.

Data is a Compose that contains your sample data. Note that I had to wrap it within an object for it to be valid JSON. Also removed the last comma at the end of your project_description which was also invalid.
{ "projects": [ { "project_id": 9, "project_name": "Language processing", "project_description": "{\"blocks\":[{\"key\":\"dopmg\",\"text\":\"XYZ\",\"type\":\"sharp\",\"depth\":5,\"entityRanges\":[],\"data\":{}}],\"entityMap\":{}}" } ] }

JSON is a Compose that converts the value (object) of project_description to valid JSON. The expression used is below. Note that we use 0 to get the first project. If you had more projects, we'd likely need a different approach.
json(outputs('Data')?['projects'][0]?['project_description'])

This would give us the following output.
{ "blocks": [ { "key": "dopmg", "text": "XYZ", "type": "sharp", "depth": 5, "entityRanges": [], "data": {} } ], "entityMap": {} }

Compose uses the following expression to extract the text from the first object in the blocks array. Note that if you have multiple block objects you would likely go with a slightly different approach.
outputs('JSON')?['blocks'][0]?['text']

The result from the Compose would be:

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
HalimeArs 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @grantjenkins,

Perfect! It works very well. Thanks a lot.

Was this reply helpful? Yes No
SwJ23 85 on at

Like (0)

Report
Copy link

Link copied!

I realize that a very good answer has been given, but I'd just like to point out (because I'm learning about Power Automate and object-oriented programming too, and this was a revelation to me) that you have posted the text for an Array of Objects. This language should be helpful when searching for similar answers.

In JSON, everything is an Object initially, so I'm guessing you didn't copy over the initial curly braces. So what you really have is an Object containing an Array of Objects. You access an Object's properties (and sub properties) in Power Automate by something like this:

outputs('Name_of_Connector')?['Property_Name'][arrayintegerifnecessary]?['Subproperty_Name'] etc. The "?" shows the downward connection of objects and properties, which can be linked together, and when you put "[ ]" at the end of a property you're accessing that index of an array.

{ <---- this curly brace starts any JSON
"projects": [ <---- this open bracket indicates that "projects" is an array
{ <---- this open curly brace indicates the following text is an object
"project_id": 9, <---- this is the first Object property, which is an integer
"project_name": "Language processing", <---- this is the second Object property, which is a string
"project_description":
"{\"blocks\":[{\"key\":\"dopmg\",\"text\":\"XYZ\",\"type\":\"sharp\",\"depth\":5,\"entityRanges\":[],\"data\":
{}}],\"entityMap\":{}}", <---- this is also a string, though it looks to be an array of objects that has been turned
into a string)
}
]
} <---- this curly brace is at the close of any JSON

So, if a connector named "Compose_2" contained your JSON, you could access "project_id" with this text:

outputs('Compose_2')?['projects'][0]?['project_id']

And using the json() function to convert your Object's index-0-Array's Object's third string-Property, as @grantjenkins demonstrated, you could access XYZ like this:

json(outputs('Compose_2')?['projects'][0]?['project_description'])?['blocks'][0]?['text']

Getting the gist of all that helps immensely when plinking around in Power Automate.

Was this reply helpful? Yes No