topic Salesforce EXCEEDED_ID_LIMIT Received in Talend Studio

Salesforce EXCEEDED_ID_LIMIT Received

Anonymous — Sat, 16 Nov 2024 13:52:19 GMT

When using new getupdated component I receive this error if over 2000 records need to be updated.
Researched this and found that the Saleforce API has a 2000 record limit for the retrieve call. See this URL http://community.salesforce.com/sforce/board/message?board.id=JAVA_development&message.id=1615
I increased the number of times the update is run to reduce the number of records per call below 2000. Is there a more permanent solution?

Re: Salesforce EXCEEDED_ID_LIMIT Received

Anonymous — Thu, 16 Jul 2009 02:53:29 GMT

Hello
Split your update time into several time segment on a file, eg:
2009-02-12 18:00:00;2009-02-15 18:00:00
2009-02-15 18:00:00;2009-02-16 18:00:00
Then, use a tFileInputDelimited to extract the start time, end time, and link to a tFlowToIterate,eg:
tFileInputDelimited-->tFlowToIterate--iterate-->tSalesForceUpdated
Best regards
shong

Re: Salesforce EXCEEDED_ID_LIMIT Received

Anonymous — Thu, 16 Jul 2009 21:47:00 GMT

Thanks is a more permanent solution coming in a future release?