question

MaceoWu-5946 avatar image
0 Votes"
MaceoWu-5946 asked saldana-msft edited

Microsoft Graph Api batch request when trying to modified range of Excel on SharePoint Online

Hi, I'm trying to modified a dynamic value in Excel which stored in SharePoint Online. Currently I'm using the update range, merge range, update range format and so on. Currently I'm trying to find another way to request for Graph api in batch in order to avoid getting throttled or blocked in SharePoint Online.

Much appreciate if there are any ideas, thanks

office-sharepoint-onlinesharepoint-devmicrosoft-graph-workbooks
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

RaytheonXie-MSFT avatar image
0 Votes"
RaytheonXie-MSFT answered RaytheonXie-MSFT commented

Hi @MaceoWu-5946 ,
Microsoft Graph is cloud born APIs that have the latest improvements and optimizations. In general, Microsoft Graph consumes less resource than CSOM and REST to achieve the same functionality. Hence, adopting Microsoft Graph can improve application's performance and reduce throttling.

If you do run into throttling, we require leveraging the Retry-After HTTP header to ensure minimum delay until the throttle is removed.

The Retry-After HTTP header is the fastest way to handle being throttled because SharePoint Online dynamically determines the right time to try again. In other words, aggressive retries work against you because even though the calls fail, they still accrue against your usage limits. Following the Retry-After HTTP header will ensure the shortest delay.

For information about ways to monitor your SharePoint Online activity, see Diagnosing performance issues with SharePoint Online.

For a broader discussion of throttling on the Microsoft Cloud, see Throttling Pattern.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MaceoWu-5946 avatar image MaceoWu-5946 ·

Hi RaytheonXie,

Much appreciate that you can answer for my question. It did help me a lot.
I will try to fix the problems I met according to your suggestions.
By the way, do you know where we can give suggestions to Graph api? Actually it made me confused when I try to add 'All Border' to Excel when using Graph api. I think the pratices we done also are the good suggestions to make the api works better

Thanks,
Maceo

0 Votes 0 ·
RaytheonXie-MSFT avatar image RaytheonXie-MSFT MaceoWu-5946 ·

Hi @MaceoWu-5946 ,
Thanks for letting us know your user experience. It is highly recommended that you can raise a feedback here. Many features of our current products are designed and upgraded based on customers’ feedback. With requirements like this increase, the problem may well be released in the future. Thanks for your understanding.


0 Votes 0 ·