SAP C4C - How to fetch more than 1000 entries in standard or custom OData Service?

[Former Member]

Hi Experts,

I have created a custom OData service for fetching all ticket details but when I run it, I can only see the oldest 1000 records in the response and not all the ~3000 records.
Any way I can fetch all of them in single result? or any way I can atleast fetch the newest 1000 and not the oldest ones?

Regards,
Akash

[Vignesh_Dh · Accepted solution]

Hi Akash,

after the 1000 <entry> tags you will have <link rel="next" href=" link to fetch next set of records"> . you can use that OData link to fetch the next set of results which are part of initial query.

This has to be continued until all the records are fetched.

Regards,

Vignesh

[dpksghl_30]

Hi Akash,

This is due to server side limitation for C4C OData, you cannot fetch more than 1000 entries. To fetch latest ticket entries which in your case I assume will be last updated ones, you can try using "$orderby=ETag desc" OData query.

Thanks!

Regards,

Deepak Singhal