venkyvb/flow.md

Last active July 31, 2020 16:26

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/venkyvb/8167b5aff96f9e6a0624bc143f5c46ca.js"></script>
Save venkyvb/8167b5aff96f9e6a0624bc143f5c46ca to your computer and use it in GitHub Desktop.

Download ZIP

Using Microsoft Graph Excel API for calculations

Raw

flow.md

Steps done using Graph Explorer - https://developer.microsoft.com/en-us/graph/graph-explorer

Create a new non-persistent session for the workbook

POST
https://graph.microsoft.com/v1.0/me/drive/items/{itemId}/workbook/createSession

{
    "persistChanges": false
}

Use the session as HTTP header (in all the subsequent calls)

"workbook-session-id": "<non-persistent-session-id>"

Send Input values

PATCH
https://graph.microsoft.com/v1.0/me/drive/items/{itemId}/workbook/worksheets('InputOutput')/range(address='C3')

{
    "values" : [["230"]]
}

Read the output values

GET
https://graph.microsoft.com/v1.0/me/drive/items/{itemId}/workbook/worksheets('InputOutput')/range(address='C9:C11')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment