CODEWITHSUNDEEP
microsoft-graph-apiexcel-online
Ansonee
Ansonee

Reputation: 21

Alternatives to Microsoft Graph API Execute Excel Script

I am working with Microsoft Graph API and have run into something of a roadblock.

We have an Excel Online workbook in SharePoint. This workbook is linked from a different workbook. Within this linked workbook, there is a script which just essentially refreshes the link and updates the data in the workbook.

I was hoping to use Graph API to accomplish, but in all of my reading and research and scouring various user groups and posts, it looks as though the methods that used to exist for this (i.e., getScripts, executeScripts) no longer exist. Whenever I try to execute them based on the existing documentation I've found, I get a "no segment found" error.

So the question being: were script methods deprecated in Graph API? If not, where is documentation on how to implement the API call? If they are indeed DOA, what other methods - besides Power Automate - have people used to refresh links/connections in Excel Online?

I've looked everywhere and all signs I've found point to Power Automate being the only option.

Thanks for any insight.

Upvotes: 0

Views: 149

Answers (1)

DMabulage
DMabulage

Reputation: 896

You can use Office JS API for excel sheet manipulation https://learn.microsoft.com/en-us/javascript/api/overview?view=common-js-preview

Upvotes: 0

Related Questions