Skip to content

Instantly share code, notes, and snippets.

@venkyvb

venkyvb/flow.md

Last active July 31, 2020 16:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save venkyvb/8167b5aff96f9e6a0624bc143f5c46ca to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save venkyvb/8167b5aff96f9e6a0624bc143f5c46ca to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. venkyvb revised this gist Jul 31, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion flow.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,7 +18,7 @@ https://graph.microsoft.com/v1.0/me/drive/items/{itemId}/workbook/createSession
    "workbook-session-id": "<non-persistent-session-id>"
    ```

    3. Send Input values - note in this case we are just updated a single input cell, this can be a range e.g. C3:C7 well, in which case the values would be `[["valC3", "valC4", "valC5", "valC6", "valC7"]]`. Also number format can be specified using the attribute e.g. `"numberFormat" : [[null,null], ["m-ddd", null]]`
    3. Send Input values - note in this case we are just updated a single input cell, this can be a range e.g. C3:C7 well, in which case the values would be `[["valC3", "valC4", "valC5", "valC6", "valC7"]]`. Also number format can be specified using the attribute e.g. `"numberFormat"` for each cell.

    ```
    PATCH
  2. venkyvb revised this gist Jul 31, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion flow.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,7 +18,7 @@ https://graph.microsoft.com/v1.0/me/drive/items/{itemId}/workbook/createSession
    "workbook-session-id": "<non-persistent-session-id>"
    ```

    3. Send Input values - note in this case we are just updated a single input cell, this can be a range e.g. C3:C7 well, in which case the values would be `[["valC3", "valC4", "valC5", "valC6", "valC7"]]`
    3. Send Input values - note in this case we are just updated a single input cell, this can be a range e.g. C3:C7 well, in which case the values would be `[["valC3", "valC4", "valC5", "valC6", "valC7"]]`. Also number format can be specified using the attribute e.g. `"numberFormat" : [[null,null], ["m-ddd", null]]`

    ```
    PATCH
  3. venkyvb revised this gist Jul 31, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion flow.md
    View file
    Original file line number Diff line number Diff line change
    @@ -18,7 +18,7 @@ https://graph.microsoft.com/v1.0/me/drive/items/{itemId}/workbook/createSession
    "workbook-session-id": "<non-persistent-session-id>"
    ```

    3. Send Input values
    3. Send Input values - note in this case we are just updated a single input cell, this can be a range e.g. C3:C7 well, in which case the values would be `[["valC3", "valC4", "valC5", "valC6", "valC7"]]`

    ```
    PATCH
  4. venkyvb created this gist Jul 31, 2020.
    37 changes: 37 additions & 0 deletions flow.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,37 @@
    Steps done using Graph Explorer - https://developer.microsoft.com/en-us/graph/graph-explorer


    1. Create a new **non-persistent session** for the workbook

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

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

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

    3. Send Input values

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

    4. Read the output values

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