Ask Your Question

Salesforce Origin cannot parse SOQL with Order object

asked 2018-04-30 17:10:35 -0500

Dylan gravatar image

updated 2018-06-01 13:49:11 -0500

metadaddy gravatar image

This error is probably due to the fact that Order object is SOQL keyword so that it can't be parsed correctly

FORCE_00 - A configuration is invalid because: , FORCE_27 - Error parsing SOQL query SELECT * FROM Order WHERE SystemModstamp > ${offset} ORDER BY SystemModstamp

Initial Offset=1900-01-01T00:00:00.000Z

Github: streamsets/datacollector/salesforcelib/

Salesforce Group object also fails to parse SELECT * FROM Group

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-06-01 14:02:35 -0500

metadaddy gravatar image

updated 2018-11-21 10:16:51 -0500

Currently, the Antlr4 grammar that Data Collector uses to parse SOQL queries doesn't handle keywords being used as identifiers.

SDC-9143 fixes this and will be available in a future release.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-30 17:10:35 -0500

Seen: 177 times

Last updated: Nov 21 '18