How to consult clients with more than a thousand records per oData of non-consecutive clients?

[Rosmary]

Hi. I need your support for the following. I need to expose a service of type oData to query 1000 customer records. Said clients have no consecutive IDs and I can't filter by the "between", so I proceeded to do it by OR, but it drops (error) at 230 records. Is there a way to include these thousand records under another filter? I attach the URL that I have developed with more than 230 records. We need this information for the BI area. Thanks for the support

servicio-odata.txt

[former_member226]

Hello,

I think query 1000 records just via URL filter will be somewhat unachievable considering URL length. In most modern browser there is a limit of the number of charactes like 2048 or 2083 etc etc( as mentioned HERE:https://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers) however I see your URL with just over 270 entries already have have approx 7000 chars. Therefore system might be throwing an error. Event if the data is passed from browser to C4C backend, I highly doubt that it is gonna process such a hugh query in a given timeframe.

Hence the recommendation is to either try to restrict the query OR split/group the data so that it can be processed in a single HTTP call. Alternatively check if you can use any existing analytics data sources and then query the data using default selection or so.

BR

[VenuAnumayam]

Did you try using Account Group or Customer Group or Sales Area if they belong to certain?

[Rosmary]

We do not manage sales data yet. And we handle a single account group and a single customer type group.