Answered

Querying Data with Web API and Filter on Dates

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am referring to this document Query data using Portals Web API and I don't see an option to filter on dates. Is it still possible to filter on date using Portals Web API? If not, any way I can dynamically add filters to fetchxml for instance, if I don't know before hand how many date filters I'd need in fetchxml?

Thank you so much in advance!!

Categories:

Power Apps portals

I have the same question (0)

All responses (5)

Answers (1)

OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Web API supports filtering. You can use $filter option to specify your filter the same way as with regular Dataverse api. It is described in the article you mention.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Thank you for your response @OOlashyn!

I am not able to use filter on dates using Portals Web API. I tried all ways to filter with dates.
"/_api/cred7_claims?$select=cred7_type,cred7_controlnumber,cred7_contact&$filter=cred7_incidentdateandtime ge datetime'"+ 2021-02-18T20:11:00 + "'"
"/_api/cred7_claims?$select=cred7_type,cred7_controlnumber,cred7_contact&$filter=cred7_incidentdateandtime ge '"+ 2021-02-18 + "'"
"/_api/cred7_claims?$select=cred7_type,cred7_controlnumber,cred7_contact&$filter=cred7_incidentdateandtime ge '"+ 2021-02-18T20:11:00 + "'"
I have test filtering on other data types and it has worked. Date is the only data type that's not working for me.

Any suggestions would be greatly appreciated!

Thank you!

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

I presume maybe it is not there yet. Below is the snippet from dataverse API . I think it is applicable for Portal Web API.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Verified answer

OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

I just checked and filtering works just fine with dates. Can you show me how exactly you are performing the request? Do you receive any errors in response? Also, can you create your query in Fetchxml Builder in Xrmtoolbox and validate that it works there? My guess is that there is something wrong with the request itself ie can you filter only on a date without the time and check if that helps.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you @ragavanrajan and @OOlashyn for your responses!

@OOlashyn's solution worked for me! Thank you for trying it out, I removed the time and it worked perfectly.

Was this reply helpful? Yes No