Ask Your Question

FORCE_07 - SOQL query must include 'Id' in WHERE clause and in ORDER BY clause before other columns.

asked 2019-12-06 17:43:47 -0600

anonymous user


Just starting out with streamsets, and I'm trying to get the Salesforce origin to work. Right now, no matter what SOQL query I write, I end up with the above error. This even when there is no "ID" in the query, and there certainly isn't a where or order by clause. I have tried a couple different orgs and trailheads, and no luck. I am running StreamSets Data Collector 3.11.0 on a Macbook Pro with Mojave installed.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-12-09 06:00:59 -0600

Ranjan Mishra gravatar image

updated 2019-12-09 06:01:11 -0600

turn off the incremental mode option. When the incremental model option is checked the query looks for an offset or where by clause to pull the changed data

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-06 17:43:47 -0600

Seen: 116 times

Last updated: Dec 09 '19