Skip Navigation
Expand
ROQL keywords break REST API custom object requests
Answer ID 11833   |   Last Review Date 02/26/2021

Why do I get an '"Bad Request: near \"Report\": syntax error"' in my response to GET a custom object via REST API?

Environment:

Oracle B2C Service REST API Custom Objects

Resolution:

There are a few ROQL reserved words used for identifying which database the query should be run against.  These are USE, DEFAULT, OPERATIONAL, and REPORT.  They are not necessarily MySQL keywords, but specifically parsed and used as directives for ROQL.  This response error is expected and these words should be considered part of the "reserved words" list.
Notify Me
The page will refresh upon submission. Any pending input will be lost.