Excel data in Widget

Hi all!

I am noob in javascript and other stuff, but trying to make a widget that is showing cell-value, calculated in Excel file stored on OneDrive for Business.

At first, I made a GET URL for getting cell’s data in MSGraph sandbox (I have been granted access to 1drive for MSGraph). I have application ID registered in Azure also.

What’s my next move to make Scriptable get data (all these auth things and so on)?

As a next step - help me to choose what Quickstart guide section in Azure fits for Scriptable?

What type of application are you building?

  1. Web application
  2. Node.js
  3. Mobile and desktop application (no?)
  4. Single-page application (SPA)
  5. JavaScript (auth code flow)
  6. JavaScript (implicit flow)
  7. Daemon application (no?)

I would suggest following the guides 5 or 6 depending on what looks to be easier to implement.

You may also have a look at this example of an OAuth flow: