When trying to insert my records into salesforce, I'm receiving the following error -
EXCEEDED_ID_LIMIT: record limit reached. cannot submit more than 200 records into this call
This hard limit is set by Salesforce to send 200 records at a time as part of the query method call when the query is a simple Select * (as part of SOQL). The Web service is not meant for bulk extraction.
The bulk loading or extraction needs to be done carefully and should use a filter condition on the database source query such as modified date to pull only the incremental changes from the database that need to be sent to Salesforce.
Article is closed for comments.