SAP Knowledge Base Article - Public

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

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.

First attempt with "top=500 filter" in the body of the API call, and in the second attempt with "skip=500 and top=500 filter".

 

 

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

JWT Bearer Token API Authentication | SAP Help Portal

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

SAP CPQ 2020

Attachments

basic_token_API_call.png
Custom_table_API_Call.png
JWT_token_API_call.png