cancel
Showing results for 
Search instead for 
Did you mean: 

Synchrous Execution (IE Excel Add Row, Sharepoint Copy File)

When adding rows to an excel file, or copying an excel file in a sharepoint folder, the operation is performed asynchronously.  This causes errors if adding multiple rows or copying the file immediately after submitting add rows requests, as the add rows requests may easily overload the server, fail behind the scenes and/or the copy operation is processed before the add rows requests are complete. 

 

All connectors should have a clear synchronous or async mode, as available for the service. If either method is not available, the connector should so indicate.  It is not clear what operations are processed synchronously vs async. 

Status: New
Comments
sayyedkohler
Advocate II

Any update on that?

iampegram
Frequent Visitor

There is a lot of inconsistency with this connector. I tried to set up a Do-Until loop checking how many rows are present, but it returns all the rows I added. Even so, the file still didn't contain them for the SharePoint add attachment action.

ekansh005
Regular Visitor

Hi, This should be prioritized. Currently I have no way of knowing that the excel file is completely updated or not before sending the file via email, for example. Adding a delay is not solution as it is unreliable and would fail when the dataset is large.