Extract information from a JSON body without never ending loops

(0) Share

Report

Posted on by NicolleAbraham

Hi everyone,

I am using the HTTP action to return some information on documents, I would like to extract specific information like the webUrl of a document. The payload is very similiar to the below,

{
"value": [
{
"searchTerms": [
"contoso"
],
"hitsContainers": [
{
"hits": [
{
"hitId": "1",
"rank": 1,
"summary": "_summary-value",
"resource": {
"@odata.type": "#microsoft.graph.listItem",
"id": "c23c7035-73d6-4bad-8901-9e2930d4be8e",
"createdBy": {
"user": {
"displayName": "Bob",
"email": "Bob@contoso.com"
}
},
"createdDateTime": "2021-11-19T17:04:18Z",
"lastModifiedDateTime": "2023-03-09T18:52:26Z"
}
}
],
"total": 1,
"moreResultsAvailable": false
}
]
}
]
}

How would I extract the createdDateTime? In PowerAutomate of course

TIA

Categories:

Business Process Flows

Flow Mobile App

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Paulie78 8,418 Moderator on at

Like (1)

Report

Extract information from a JSON body without never ending loops

It depends if you want all possible results, or only the single result as per your example above. There is a whole bunch of nested arrays there so you could easily get multiple results. To get the createdDateTime from your example above you can use the expression:

first(first(first(outputs('Compose')?['value'])?['hitsContainers'])?['hits'])['resource']?['createdDateTime']

where outputs('Compose') is the name of the action that returns your result.

Was this reply helpful? Yes No