Symptom
Error message when running Quotes API:
{
"error": {
"code": "116000",
"message": "Internal server error.",
"target": "/api/v1/quotes?$filter=quotenumber%eq%",
"details": [],
"internalMessage": "Incorrect syntax near the keyword 'for'.\r\nInvalid usage of the option NEXT in the FETCH statement.\r\nIncorrect syntax near the keyword 'for'."
}
}
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
Run following API endpoint /api/v1/quotes?$filter=quotenumber eq 'QuoteNumber' using bearer token.
Cause
The visibility rule has a problem, the database contains quote status names instead of IDs. This causes an exception when evaluating quote visibility.
Resolution
The advanced condition of the visibility rule should be edited with the correct quote status.
Keywords
CPQ, internal, server, error, incorrect, syntax, API, quote, number, keyword , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem