API error when connecting from SQL to Excel

Matt Paver 1 Reputation point
2020-12-03T15:54:04.77+00:00

Hi all,

We are currently in the process of automating an onboarding process for learners but are recieving this api issue.
What we would like to do is bulk update rows in the same excel document but it is across over various tables so so far I have created 30 actions to update a row.
I have reduced this to 4 actions of updating the row but all with this same error. I have set the retry policy to none but still no difference.
44817-api-error.png

Any help would be greatly appreciated :)

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,097 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ChaitanyaNaykodi-MSFT 12,881 Reputation points Microsoft Employee
    2020-12-04T03:49:25.793+00:00

    Hello @Matt Paver , Thank you for reaching out. The excel connector has a throttling limit of 100 calls per 60 seconds. According to the How to handle throttling problems in Azure Logic App guide you can set-up multiple connections for a single action so that data is partitioned for processing. You can use the For-Each loop for each connection as mentioned the guide shared above. You can run For each loop sequentially and parallelly according to your requirement just be aware of the concurrency limit. If excel connector permits retries you can also try the Retry policy solution mentioned in the guide.

    Please let me know if there are any additional concerns. Thank you!

    0 comments