SAP Knowledge Base Article - Public

3393186 - Receiving error code 112000 when using API with top filter

Symptom

When using Quotes API with /api/v1/quotes?$top={number greater than 1000}, receives:

{
    "error": {
        "code": "112000",
        "message": "The maximum of $top is 1000 ",
        "details": [],
        "internalMessage": "The maximum of $top is 1000 "
    }
}

Environment

SAP SALES CLOUD CPQ in Quote 2.0

Reproducing the Issue

  1. Create API call with Quotes using: https://{{Domain}}.cpq.cloud.sap/api/v1/quotes?$top={number greater than 1000};
  2. Error is received with status "400: Bad Request".

Cause

Filter $top has a limit of 1000.

Resolution

If you wish to retrieve more data then 1000 in Quote API, you will need to use filter $top along with $skip, as following:

https://{{Domain}}.cpq.cloud.sap/api/v1/quotes?$top=1000$skip={amount of values you wish to skip}

See Also

Swagger API

Keywords

API, Quote, $top, $skip, Filter, Error, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To

Product

SAP CPQ 2023