Loading .csv file to SFDC only 100 lines at a time

Hi Everyone

I have made a recipe that takes a dropbox .csv file and loads to SFDC, but it stops after a 100 lines.

Does anyone know a workaround for this?

Help Appreciated as it causing alot of issues.

Cheers

Nigel

Best Answer

Allan Teng said almost 7 years ago

Try using the "New line batch in CSV file" trigger instead. The file can be broken down into batch for processing.

Answer

Allan Teng

said almost 7 years ago

Try using the "New line batch in CSV file" trigger instead. The file can be broken down into batch for processing.

nigel blackwell

said almost 7 years ago

Thanks, will give this a shot.

Every morning, We have an updated file with under 200 lines of new data that gets uploaded to dropbox to in turn update Salesforce. By changing our trigger from "when a new/updated file is added" to the "new line batch", does workato still recognize when the new daily file (with same filename) is uploaded to dropbox and act on it?

Let's say my lines only go to 127 and not 200, is Workato smart enough to not try and load erroneous blank lines into our SFDC org?

Thanks again for responding, we truly appreciate your help.

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem