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.
nigel blackwell
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
Try using the "New line batch in CSV file" trigger instead. The file can be broken down into batch for processing.
Allan Teng
Try using the "New line batch in CSV file" trigger instead. The file can be broken down into batch for processing.
nigel blackwell
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.