HTTP Web Request - SharePoint Office 365/Online Excel Document
Hi
I am trying to use HTTP web request in SharePoint Designer 2013 to get an Excel Workbook table items that is stored in Office 365 SharePoint sites.
And also want to template a process to get information automatically.
Please don't suggest Power Automate. I have tried it and limitation is that it cannot be used as part of SharePoint Site template and Power Automate needs hard coded links to a SharePoint site and excel document library. I have already asked the question about Power Automate before.
What I found on Microsoft documentation is that SharePoint and Excel Rest APIs are now different due to Microsoft Graph and is confusing me a lot to get the information from the Excel workbook and table.
All I need is a connection and access to the table, rest should be fine. Workflow in SharePoint designer can be added to Site Templates which is what we ultimately want.
Any help and guidance will be highly appreciated as always :-)
Thank you,
SJ