Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
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.