SAP Knowledge Base Article - Public

2732213 - ODATA Query for Report and Data Sources Fetches Only 50 Records

Symptom

ODATA query for report and data sources fetches only 50 records.

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

You tried to fetch data from a report or data source using an Odata query, but the result is restricted to 50 entries.

Cause

There is a restriction for the records fetch in ODATA to be 50 to avoid memory timeout. Hence an ODATA query for a report or data source will not fetch more than 50 records.

Resolution

You can bypass this limitation using the $top or $skip option. The $top=n where n is a number option specifies that only the first n records will be returned. Hence if you specify the $top=100 will return the first 100 entries. This might end up in a timeout for larger values for $top.

See Also

Please, refer the blog on ODATA for further information OData for SAP Business ByDesign Analytics or the recording of the OData webinar.

Keywords

ODATA, 50 records, $top, $skip, restricted data retrieval , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions