• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Recipe Building Questions
n

nigel blackwell

started a topic almost 7 years ago
Answered

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
A
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.

n

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.

Login to post a comment

Still can't find your solution?

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

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count