Mixing
Can multiple people edit the same excel file using Microsoft Graph Excel APIs
I would like to have a solution where a single administrator account would make calls on behalf of the signed in users on a web app to perform CRUD operation on a single shared excel file stored in the administrators OneDrive.
This is how the flow will look like.
- User signs into web app and performs a operation.
- The web app on behalf of the user gets access_token from Azure Active Directory and then performs the operation on the excel file stored in OneDrive based on the Microsoft Graph API.
Now suppose there are multiple users logged in to the web app and make requests. How will the Graph API respond to this scenario?
Does Microsoft Graph API support concurrent requests to edit.
excel
azure-active-directory office365 microsoft-graph asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
add a comment |
I would like to have a solution where a single administrator account would make calls on behalf of the signed in users on a web app to perform CRUD operation on a single shared excel file stored in the administrators OneDrive.
This is how the flow will look like.
- User signs into web app and performs a operation.
- The web app on behalf of the user gets access_token from Azure Active Directory and then performs the operation on the excel file stored in OneDrive based on the Microsoft Graph API.
Now suppose there are multiple users logged in to the web app and make requests. How will the Graph API respond to this scenario?
Does Microsoft Graph API support concurrent requests to edit.
excel
azure-active-directory office365 microsoft-graph asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
add a comment |
I would like to have a solution where a single administrator account would make calls on behalf of the signed in users on a web app to perform CRUD operation on a single shared excel file stored in the administrators OneDrive.
This is how the flow will look like.
- User signs into web app and performs a operation.
- The web app on behalf of the user gets access_token from Azure Active Directory and then performs the operation on the excel file stored in OneDrive based on the Microsoft Graph API.
Now suppose there are multiple users logged in to the web app and make requests. How will the Graph API respond to this scenario?
Does Microsoft Graph API support concurrent requests to edit.
excel
azure-active-directory office365 microsoft-graph asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
I would like to have a solution where a single administrator account would make calls on behalf of the signed in users on a web app to perform CRUD operation on a single shared excel file stored in the administrators OneDrive.
This is how the flow will look like.
- User signs into web app and performs a operation.
- The web app on behalf of the user gets access_token from Azure Active Directory and then performs the operation on the excel file stored in OneDrive based on the Microsoft Graph API.
Now suppose there are multiple users logged in to the web app and make requests. How will the Graph API respond to this scenario?
Does Microsoft Graph API support concurrent requests to edit.
excel
azure-active-directory office365 microsoft-graph excel
azure-active-directory office365 microsoft-graph asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
asked Nov 21 '18 at 16:17
thebenmanthebenman
1,094922
1,094922
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Microsoft Graph throttling limits the number of concurrent calls to a service to prevent overuse of resources.
When a throttling threshold is exceeded, Microsoft Graph limits any further requests from that client for a period of time. When throttling occurs, Microsoft Graph returns HTTP status code 429 (Too many requests), and the requests fail.
For more details, refer to Microsoft Graph throttling guidance.
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53416315%2fcan-multiple-people-edit-the-same-excel-file-using-microsoft-graph-excel-apis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Microsoft Graph throttling limits the number of concurrent calls to a service to prevent overuse of resources.
When a throttling threshold is exceeded, Microsoft Graph limits any further requests from that client for a period of time. When throttling occurs, Microsoft Graph returns HTTP status code 429 (Too many requests), and the requests fail.
For more details, refer to Microsoft Graph throttling guidance.
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
add a comment |
Microsoft Graph throttling limits the number of concurrent calls to a service to prevent overuse of resources.
When a throttling threshold is exceeded, Microsoft Graph limits any further requests from that client for a period of time. When throttling occurs, Microsoft Graph returns HTTP status code 429 (Too many requests), and the requests fail.
For more details, refer to Microsoft Graph throttling guidance.
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
add a comment |
Microsoft Graph throttling limits the number of concurrent calls to a service to prevent overuse of resources.
When a throttling threshold is exceeded, Microsoft Graph limits any further requests from that client for a period of time. When throttling occurs, Microsoft Graph returns HTTP status code 429 (Too many requests), and the requests fail.
For more details, refer to Microsoft Graph throttling guidance.
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
Microsoft Graph throttling limits the number of concurrent calls to a service to prevent overuse of resources.
When a throttling threshold is exceeded, Microsoft Graph limits any further requests from that client for a period of time. When throttling occurs, Microsoft Graph returns HTTP status code 429 (Too many requests), and the requests fail.
For more details, refer to Microsoft Graph throttling guidance.
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
answered Nov 22 '18 at 1:36
Joy WangJoy Wang
7,3432213
7,3432213
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
add a comment |
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
although this helps i'm thinking specifically about how excel will respond to multiple api calls and multiple people editing the same sheet and so on
– thebenman
Nov 23 '18 at 2:53
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
@thebenman May be this is about the architecture of the MS graph, could not find it.
– Joy Wang
Nov 23 '18 at 3:01
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53416315%2fcan-multiple-people-edit-the-same-excel-file-using-microsoft-graph-excel-apis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
