One Star

Salesforce EXCEEDED_ID_LIMIT Received

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?
2 REPLIES
Community Manager

Re: Salesforce EXCEEDED_ID_LIMIT Received

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Salesforce EXCEEDED_ID_LIMIT Received

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