Default max page size?

[NutterzUK]

Hi,

I’m looking for any guidance please on if there is any mechanism to limit the number of results returned at the service layer from the database.

I can see when I request a resource, the limit is set to 2147483647. This means a badly configured or malicious client could pull millions of records all at once.

Is there a way to set a max number of results (server side)?

[wog48]

Hello,

There is the option of server driven paging. I documented this option in How To Build Server Driven Paging? The document contains some example as a fruit of thought. Please note that as of today paging is only support on entity set level. See issue#314 .
I hope this helps.

[NutterzUK]

Hello,

There is the option of server driven paging. I documented this option in How To Build Server Driven Paging? The document contains some example as a fruit of thought. Please note that as of today paging is only support on entity set level. See issue#314 . I hope this helps.

Thank you @wog48 ! I really appreciate that, sorry I’d not managed to find that document. I’ll have a look through.

If there is anything that we want that isn’t available I’ll find time to contribute back, I was just needing a pointer of where to start.

I really appreciate everything you’ve done in this project - I’ve got a requirement to connect from Salesforce using OData to a Snowflake database and this seems to be providing the perfect layer in between them.

Thanks again for the support, I’ll do what so can to offer something back as soon as I’m up to speed!

[wog48]

I close the issue. In case there is another issue, feel free to create another one.