CODEWITHSUNDEEP
microsoft-graph-apisharepoint-api
Rich7716
Rich7716

Reputation: 49

Server task/daemon read Excel workbook from Sharepoint Online using MS Graph API

Requirement is for a (non Microsoft) server task to pull information, on a schedule, from an Excel workbook on Sharepoint Online.

I'd been looking into the Micrsoft Graph API, and it looked like it would work (I can navigate to the workbook using Graph Explorer, etc), and I had been about to request a new app to be registered in Azure AD, to start testing. I had been planning to use the "Application Permissions" option, as there won't be a logged in user.

However I just noticed in the MS documentation that the workbook & worksheet API calls are not supported for the 'Application' permission type!!

Can anyone confirm that if the following would work, or not?

If this scenario would not work, is there an alternative way for a daemon to read Excel info from SPO?

Thanks

Upvotes: 1

Views: 300

Answers (1)

Danstan
Danstan

Reputation: 1801

As you mentioned, the Workbooks Graph APIs don't support application permissions. You must have a user that consents to the application to use delegated permissions.

In this case you can use Service Principals with the required delegated permission to access the workbooks APIs. Service Principal APIs are documented here

Upvotes: 0

Related Questions