3590344 - SIGNAL OData API error: "Too many rows: Maximum size is 10000 rows, but OData query would process at least 10001"

When trying to use pagination parameters $skip and $top on a query I receive an error code "400" with the response "Too many rows: Maximum size is 10000 rows, but OData query would process at least 10001"

Example API-call:

'https://{baseUrl}/pi/signal/odata/v1/my-view?$top=10&$skip=0'

This is expected behavior for a query with more than 10k rows. Before applying skip/top pagination, a query's total result size is limited. This is checked before parameters are passed with the OData query. The parameters can only be applied to a result set with less than 10k allowed result rows.

Workaround: Create multiple OData Views limited to 10k result rows. You could use the clause "OFFSET" to skip the first chunk of rows specified in the clause for this. See: https://help.sap.com/docs/signavio-process-intelligence/signal-guide/offset-clause.

SAP Process Intelligence, SIGNAL OData API, Query Options, Error, Too many rows, PowerBI, OData Views, pagination. , KBA , BPI-SIG-PI-INV , Investigations for SAP Signavio Process Intelligence , How To

SAP Signavio Process Intelligence all versions