What is the maximum condition parameter can pass in query expression/fetchxml

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have a query expression which has a lot of condition for account entity so what is the maximum limitation for condition parameter for Online D365 CRM.

Example: I wan to retrieve list of accounts using Query Data by Web API

so i am passing 'n' number account numbers like filter=accountnumber eq '2456' or accountnumber eq '2457' or accountnumber eq '2458' or......

Thanks

Gokul JB

Categories:

Customization / Solutions / SDK and API

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: What is the maximum condition parameter can pass in query expression/fetchxml

Thanks LeoArt for valuable input, i can focus on based on URL limitation.

Here we can't use contains since contains find specific string but in my case i want to fetch list of different account numbers based on passed account number parameter
LeoAlt 16,329 on at

Like (2)

Report

RE: What is the maximum condition parameter can pass in query expression/fetchxml

Hi Gokul,

About the limits of Dynamics Web Api, Microsoft only provided this article without mentioning the url limitation.

docs.microsoft.com/.../api-limits

OData/Web Api itself doesn't limit the length of the request Url, but most browsers and servers have different limitations for url.

I recommend you to use "contains" conditions instead of "or" so that you could save many space.

Here is a similar issue for referring to.

community.dynamics.com/.../119672

Hope it helps.

Best Regards

Leo
Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (2)

Report

RE: What is the maximum condition parameter can pass in query expression/fetchxml

Hello,

Check following post - stackoverflow.com/.../what-is-the-maximum-length-of-a-url-in-different-browsers