Symptom
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."
Environment
SAP SALES CLOUD CPQ
Cause
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.
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."
See Also
Keywords
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
Product
Attachments
basic_token_API_call.png |
Custom_table_API_Call.png |
JWT_token_API_call.png |