3309505 - How to use Custom Tables API Endpoint for Retrieving 500 Table Entries or more than 500 table entries

The Custom Tables API Endpoint for Retrieving Table Entries is not working for more than 500 records, and it encounters an error message of "400 BAD REQUEST."

SAP SALES CLOUD CPQ

It is not possible to fetch more than 500 records in one request, hence we need to try 2 attempts as shown in the resolution.

1. Go to Postman.

2. Follow the process shown in this help article JWT Bearer Token API Authentication | SAP Help Portal to generate JWT token and then make the API call.

3. Mention the below in the body:

First Attempt:

params={
$orderby=CpqTableEntryId,
$top=500,
$filter=CpqTableEntryId gt \{500\}

}

Second attempt:

params={
$orderby=CpqTableEntryId,
$top=500,
$skip=500,
$filter=CpqTableEntryId gt \{500\}
}

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

JWT Bearer Token API Authentication | SAP Help Portal

custom table, custom table entries, custom table with 500 records, custom table with more than 500 records, custom table API, custom table endpoint, top, filter, skip, REST API call,  , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To