Unanswered

filter JSON based on date range

(1) Share

Report

Posted on by cbernier12

248

HI, I'm looking to filter a block of JSON returned from a service query to just the last day. I've tried things such as utcNow(createddatetime),-1) however not sure how to just pull those results from the returned JSON and place the filtered items into a new JSON output in the flow if that makes sense. Unfortunately there is no filter on the JSON query that's allowed when doing the query or I would have done that.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Expiscornovus 33,912 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You might be able to use a filter array or a condition action for this. Depends a bit on the schema/structure of the returned json.

Can you share a sample output of the returned json. Can you also share a screenshot of your current flow setup?

Was this reply helpful? Yes No
cbernier12 248 on at

Like
a
(0)

Report
Copy link

Link copied!

sure:

{

"type": "object",

"properties": {

"@@odata.context": {

"type": "string"

},

"@@odata.count": {

"type": "integer"

},

"@@odata.nextLink": {

"type": "string"

},

"value": {

"type": "array",

"items": {

"type": "object",

"properties": {

"id": {

"type": "string"

},

"name": {

"type": "string"

},

"createdDateTime": {

"type": "string"

}

},

"required": [

"id",

"name",

"createdDateTime"

]

}

}

}

}

Was this reply helpful? Yes No
Expiscornovus 33,912 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for sharing. Try the below setup in a filter array.

Use the value property from your Parse JSON action in the From

In the filter use the createdDateTime field on the left and use the is greater than or equal to operator and on the right use the expression

addDays(utcNow(), -1)

Was this reply helpful? Yes No