Show / Hide Table of Contents

Files.ReadWrite

Allows the app to read, create, update and delete the signed-in user's files.

Graph Methods

Type: A = Application Permission, D = Delegate Permission

Ver Type Method
V1 D /me/drive/items/{id}/workbook/worksheets/{id|name}/pivotTables/refreshAll
V1 D DELETE /drive/bundles/{bundle-id}/children/{item-id}
V1 D DELETE /drive/items/{bundle-id}
V1 D DELETE /drives/{drive-id}/items/{item-id}
V1 D DELETE /drives/{drive-id}/items/{item-id}/permissions/{perm-id}
V1 D DELETE /groups/{group-id}/drive/items/{item-id}
V1 D DELETE /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D DELETE /me/drive/following/{item-id}
V1 D DELETE /me/drive/items/{id}/workbook/names/{name}
V1 D DELETE /me/drive/items/{id}/workbook/tables/{id|name}
V1 D DELETE /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}
V1 D DELETE /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}
V1 D DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}
V1 D DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}
V1 D DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/names/{name}
V1 D DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}
V1 D DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1 D DELETE /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1 D DELETE /me/drive/items/{item-id}
V1 D DELETE /me/drive/items/{item-id}/permissions/{perm-id}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/names/{name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/tables/{id|name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/names/{name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1 D DELETE /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1 D DELETE /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D DELETE /sites/{siteId}/drive/items/{itemId}
V1 D DELETE /users/{user-id}/drive/following/{item-id}
V1 D DELETE /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D DELETE /users/{userId}/drive/items/{itemId}
V1 D GET /drive/bundles
V1 D GET /drive/bundles/{bundle-id}
V1 D GET /drive/items/{bundle-id}
V1 D GET /drive/items/{id}/workbook/comments/{id}/replies/{id}
V1 D GET /drive/items/{item-id}/content?format={format}
V1 D GET /drive/root:/{path and filename}:/content?format={format}
V1 D GET /drives/{drive-id}/activities
V1 D GET /drives/{drive-id}/items/{item-id}
V1 D GET /drives/{drive-id}/items/{item-id}/activities
V1 D GET /drives/{drive-id}/items/{item-id}/analytics
V1 D GET /drives/{drive-id}/items/{item-id}/analytics/allTime
V1 D GET /drives/{drive-id}/items/{item-id}/analytics/lastSevenDays
V1 D GET /drives/{drive-id}/items/{item-id}/children
V1 D GET /drives/{drive-id}/items/{item-id}/content
V1 D GET /drives/{drive-id}/items/{item-id}/getActivitiesByInterval(startDateTime='2017-01-01',endDateTime='2017-01-10',interval='day')
V1 D GET /drives/{drive-id}/items/{item-id}/permissions
V1 D GET /drives/{drive-id}/items/{item-id}/permissions/{perm-id}
V1 D GET /drives/{drive-id}/items/{item-id}/thumbnails
V1 D GET /drives/{drive-id}/items/{item-id}/versions
V1 D GET /drives/{drive-id}/items/{item-id}/versions/{version-id}
V1 D GET /drives/{drive-id}/items/{item-id}/versions/{version-id}/content
V1 D GET /drives/{drive-id}/root:/{item-path}
V1 D GET /drives/{drive-id}/root/delta
V1 D GET /drives/{drive-id}/root/search(q='{search-text}')
V1 D GET /drives/{driveId}/list/subscriptions/socketIo
V1 D GET /drives/{driveId}/root/subscriptions/socketIo
V1 D GET /groups/{group-id}/drive/items/{item-id}
V1 D GET /groups/{group-id}/drive/items/{item-id}/children
V1 D GET /groups/{group-id}/drive/items/{item-id}/content
V1 D GET /groups/{group-id}/drive/items/{item-id}/permissions
V1 D GET /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D GET /groups/{group-id}/drive/items/{item-id}/thumbnails
V1 D GET /groups/{group-id}/drive/items/{item-id}/versions
V1 D GET /groups/{group-id}/drive/items/{item-id}/versions/{version-id}
V1 D GET /groups/{group-id}/drive/items/{item-id}/versions/{version-id}/content
V1 D GET /groups/{group-id}/drive/root:/{item-path}
V1 D GET /groups/{group-id}/drive/root/search(q='{search-text}')
V1 D GET /groups/{groupId}/drive/root/delta
V1 D GET /groups/{groupId}/drive/root/subscriptions/socketIo
V1 D GET /groups/{groupId}/drives
V1 D GET /me/drive
V1 D GET /me/drive/following
V1 D GET /me/drive/items/{id}/workbook/application
V1 D GET /me/drive/items/{id}/workbook/comments
V1 D GET /me/drive/items/{id}/workbook/comments/{id}
V1 D GET /me/drive/items/{id}/workbook/comments/{id}/replies
V1 D GET /me/drive/items/{id}/workbook/comments/{id}/replies/{id}
V1 D GET /me/drive/items/{id}/workbook/names
V1 D GET /me/drive/items/{id}/workbook/names/{name}
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range
V1 D GET /me/drive/items/{id}/workbook/names/{name}/Range
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/boundingRect
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/BoundingRect
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/cell
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/Cell
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/column
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/Column
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/entireColumn
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/EntireColumn
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/entireRow
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/EntireRow
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format/borders
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format/borders()
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format/borders/{sideIndex}
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format/fill
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format/font
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/format/protection
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/intersection
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/Intersection
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/lastCell
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/LastCell
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/lastColumn
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/LastColumn
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/lastRow
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/LastRow
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/offsetRange
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/OffsetRange
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/usedRange
V1 D GET /me/drive/items/{id}/workbook/names/{name}/range/UsedRange
V1 D GET /me/drive/items/{id}/workbook/operations/{operation-id}
V1 D GET /me/drive/items/{id}/workbook/tableRowOperationResult(key={operation-id})
V1 D GET /me/drive/items/{id}/workbook/tables
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/dataBodyRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/DataBodyRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/headerRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/Range
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/boundingRect
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/BoundingRect
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/cell
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Cell
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/column
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Column
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/entireColumn
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/EntireColumn
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/entireRow
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/EntireRow
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/intersection
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Intersection
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/lastCell
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/LastCell
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/lastColumn
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/LastColumn
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/lastRow
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/LastRow
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/offsetRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/OffsetRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/usedRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/UsedRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/totalRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/TotalRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/dataBodyRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/DataBodyRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/headerRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/HeaderRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/range
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/Range
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/rows
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}/Range
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/rows/itemAt(index={index})/range
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/sort
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/sort/fields/icon
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/totalRowRange
V1 D GET /me/drive/items/{id}/workbook/tables/{id|name}/TotalRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables/{id}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView/itemAt(index={n})
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView/range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range(address={address})/visibleView/rows
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range/columnsAfter(count=n)
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range/columnsBefore(count=n)
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range/rowsAbove(count=n)
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id}/range/rowsBelow(count=n)
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/cell(row={row},column={column})
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/Cell(row={row},column={column})
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/Image(width=0,height=0,fittingMode='fit')
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480,fittingMode='fit')
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480)
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/image(width=640)
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/{point-id}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/{undefined}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/names
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/protection
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/Range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(
)/format/protection
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/boundingRect
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/BoundingRect
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/cell
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/Cell
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/column
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/Column
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/entireColumn
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/EntireColumn
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/EntireRow
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders()
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders/{sideIndex}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/fill
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/font
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/intersection
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/Intersection
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/lastCell
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/LastCell
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/lastColumn
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/LastColumn
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/lastRow
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/LastRow
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/offsetRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/OffsetRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/usedRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/UsedRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
'/entireRow
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/dataBodyRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/DataBodyRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/headerRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/Range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/totalRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/TotalRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/dataBodyRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/DataBodyRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/headerRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/HeaderRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/Range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}/Range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt(index={index})range
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/totalRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/TotalRowRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/usedRange
V1 D GET /me/drive/items/{id}/workbook/worksheets/{id|name}/UsedRange
V1 D GET /me/drive/items/{item-id}
V1 D GET /me/drive/items/{item-id}/children
V1 D GET /me/drive/items/{item-id}/content
V1 D GET /me/drive/items/{item-id}/permissions
V1 D GET /me/drive/items/{item-id}/permissions/{perm-id}
V1 D GET /me/drive/items/{item-id}/thumbnails
V1 D GET /me/drive/items/{item-id}/versions
V1 D GET /me/drive/items/{item-id}/versions/{version-id}
V1 D GET /me/drive/items/{item-id}/versions/{version-id}/content
V1 D GET /me/drive/recent
V1 D GET /me/drive/root:/{item-path}
V1 D GET /me/drive/root:/{item-path}:/content
V1 D GET /me/drive/root:/{item-path}:/workbook/application
V1 D GET /me/drive/root:/{item-path}:/workbook/comments
V1 D GET /me/drive/root:/{item-path}:/workbook/comments/{id}/replies
V1 D GET /me/drive/root:/{item-path}:/workbook/comments/{id}/replies/{id}
V1 D GET /me/drive/root:/{item-path}:/workbook/names
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/boundingRect
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/BoundingRect
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/cell
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/Cell
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/column
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/Column
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/entireColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/EntireColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/entireRow
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/EntireRow
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders()
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/{sideIndex}
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/fill
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/protection
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/intersection
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/Intersection
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/lastCell
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/LastCell
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/lastColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/LastColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/lastRow
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/LastRow
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/offsetRange
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/OffsetRange
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/usedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/names/{name}/range/UsedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tableRowOperationResult(key={operation-id})
V1 D GET /me/drive/root:/{item-path}:/workbook/tables
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/dataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/DataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/headerRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/boundingRect
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/BoundingRect
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/cell
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Cell
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/column
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Column
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/entireColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/EntireColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/entireRow
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/EntireRow
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/intersection
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Intersection
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/lastCell
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/LastCell
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/lastColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/LastColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/lastRow
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/LastRow
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/offsetRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/OffsetRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/usedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/UsedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/totalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/TotalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/dataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/DataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/headerRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/HeaderRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/range
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/itemAt(index={index})/range
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/fields/icon
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/totalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/TotalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables/{id}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView/itemAt(index={n})
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView/range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range(address={address})/visibleView/rows
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/columnsAfter(count=n)
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/columnsBefore(count=n)
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/rowsAbove(count=n)
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/rowsBelow(count=n)
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/cell(row={row},column={column})
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/Cell(row={row},column={column})
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/Image(width=0,height=0,fittingMode='fit')
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480,fittingMode='fit')
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image(width=640,height=480)
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/image(width=640)
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/{point-id}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/{undefined}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/names
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/protection
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(
)/format/protection
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/boundingRect
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/BoundingRect
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/cell
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/Cell
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/column
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/Column
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/entireColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/EntireColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/EntireRow
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders()
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders/{sideIndex}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/fill
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/font
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/intersection
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/Intersection
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/lastCell
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/LastCell
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/lastColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/LastColumn
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/lastRow
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/LastRow
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/offsetRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/OffsetRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/usedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/UsedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
'/entireRow
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/dataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/DataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/headerRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/HeaderRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/totalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/TotalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/dataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/DataBodyRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/headerRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/HeaderRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}/Range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt(index={index})/range
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/totalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/TotalRowRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/usedRange
V1 D GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/UsedRange
V1 D GET /me/drive/root:/{path}:/permissions
V1 D GET /me/drive/root/delta
V1 D GET /me/drive/root/search(q='{search-text}')
V1 D GET /me/drive/root/subscriptions/socketIo
V1 D GET /me/drive/special/{name}
V1 D GET /shares/{shareIdOrEncodedSharingUrl}
V1 D GET /shares/{shareIdOrEncodedSharingUrl}/driveItem/content
V1 D GET /sites/{site-id}/analytics
V1 D GET /sites/{site-id}/analytics/allTime
V1 D GET /sites/{site-id}/analytics/lastSevenDays
V1 D GET /sites/{site-id}/drive/items/{item-id}
V1 D GET /sites/{site-id}/drive/items/{item-id}/children
V1 D GET /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D GET /sites/{site-id}/drive/items/{item-id}/thumbnails
V1 D GET /sites/{site-id}/drive/items/{item-id}/versions
V1 D GET /sites/{site-id}/drive/items/{item-id}/versions/{version-id}
V1 D GET /sites/{site-id}/drive/items/{item-id}/versions/{version-id}/content
V1 D GET /sites/{site-id}/drive/root:/{item-path}
V1 D GET /sites/{site-id}/drive/root/search(q='{search-text}')
V1 D GET /sites/{site-id}/getActivitiesByInterval(startDateTime='2016-01-01',endDateTime='2017-05-20',interval='month')
V1 D GET /sites/{site-id}/getActivitiesByInterval(startDateTime='2016',endDateTime='2017',interval='month')
V1 D GET /sites/{site-id}/lists/{list-id}/activities
V1 D GET /sites/{site-id}/lists/{list-id}/items/{item-id}/activities
V1 D GET /sites/{site-id}/lists/{list-id}/items/{item-id}/analytics
V1 D GET /sites/{site-id}/lists/{list-id}/items/{item-id}/analytics/allTime
V1 D GET /sites/{site-id}/lists/{list-id}/items/{item-id}/analytics/lastSevenDays
V1 D GET /sites/{site-id}/lists/{list-id}/items/{item-id}/driveItem
V1 D GET /sites/{site-id}/lists/{list-id}/items/{item-id}/getActivitiesByInterval(startDateTime='2017-05-01',endDateTime='2017-05-20',interval='week')
V1 D GET /sites/{siteId}/drive/items/{item-id}/content
V1 D GET /sites/{siteId}/drive/items/{itemId}
V1 D GET /sites/{siteId}/drive/items/{itemId}/permissions
V1 D GET /sites/{siteId}/drive/root:/{item-path}
V1 D GET /sites/{siteId}/drive/root/delta
V1 D GET /sites/{siteId}/lists/{listId}/drive/root/subscriptions/socketIo
V1 D GET /teams/{teamId}/channels/{channelId}/filesFolder
V1 D GET /users/{user-id}/drive/items/{item-id}
V1 D GET /users/{user-id}/drive/items/{item-id}/children
V1 D GET /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D GET /users/{user-id}/drive/items/{item-id}/thumbnails
V1 D GET /users/{user-id}/drive/items/{item-id}/versions
V1 D GET /users/{user-id}/drive/items/{item-id}/versions/{version-id}
V1 D GET /users/{user-id}/drive/items/{item-id}/versions/{version-id}/content
V1 D GET /users/{user-id}/drive/root:/{item-path}
V1 D GET /users/{user-id}/drive/root/search(q='{search-text}')
V1 D GET /users/{userId}/drive/items/{item-id}/content
V1 D GET /users/{userId}/drive/items/{itemId}
V1 D GET /users/{userId}/drive/items/{itemId}/permissions
V1 D GET /users/{userId}/drive/root:/{item-path}
V1 D GET /users/{userId}/drive/root/delta
V1 D GET https://graph.microsoft.com/v1.0/groups/02bd9fd6-8f93-4758-87c3-1fb73740a315/drives
V1 D PATCH /drive/items/{bundle-id}
V1 D PATCH /drives/{drive-id}/items/{item-id}
V1 D PATCH /drives/{drive-id}/items/{item-id}/permissions/{perm-id}
V1 D PATCH /groups/{group-id}/drive/items/{item-id}
V1 D PATCH /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range/format
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/borders()
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/borders/{sideIndex}
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/fill
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/font
V1 D PATCH /me/drive/items/{id}/workbook/names/{name}/range/format/protection
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/rows/{index}
V1 D PATCH /me/drive/items/{id}/workbook/tables/{id|name}/sort/fields/icon
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(
)/format/protection
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders()
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders/{sideIndex}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/fill
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/font
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1 D PATCH /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1 D PATCH /me/drive/items/{item-id}
V1 D PATCH /me/drive/items/{item-id}/permissions/{perm-id}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders()
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/{sideIndex}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/fill
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/protection
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders()
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/{sideIndex}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/fill
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/protection
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/{index}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/fields/icon
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/title
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorGridlines
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/title
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/title
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/majorgridlines
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/majorGridlines
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/minorgridlines
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/minorGridlines
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueaxis/title
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/valueAxis/title
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/datalabels
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/dataLabels
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(
)/format/protection
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders()
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders/{sideIndex}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/fill
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/font
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/{index}
V1 D PATCH /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/fields/icon
V1 D PATCH /sites/{site-id}/drive/items/{item-id}
V1 D PATCH /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D PATCH /users/{user-id}/drive/items/{item-id}
V1 D PATCH /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}
V1 D POST /drive/bundles
V1 D POST /drive/bundles/{bundle-id}/children
V1 D POST /drives/{drive-id}/items/{item-id}/follow
V1 D POST /drives/{drive-id}/items/{item-id}/invite
V1 D POST /drives/{drive-id}/items/{item-id}/permissions/{perm-id}/revokeGrants
V1 D POST /drives/{drive-id}/items/{parent-item-id}/children
V1 D POST /drives/{driveId}/items/{itemId}/checkin
V1 D POST /drives/{driveId}/items/{itemId}/checkout
V1 D POST /drives/{driveId}/items/{itemId}/copy
V1 D POST /drives/{driveId}/items/{itemId}/createLink
V1 D POST /drives/{driveId}/items/{itemId}/createUploadSession
V1 D POST /drives/{driveId}/items/{itemId}/preview
V1 D POST /drives/{driveId}/items/{itemId}/versions/{version-id}/restoreVersion
V1 D POST /groups/{group-id}/drive/items/{item-id}/follow
V1 D POST /groups/{group-id}/drive/items/{item-id}/invite
V1 D POST /groups/{group-id}/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1 D POST /groups/{group-id}/drive/items/{parent-item-id}/children
V1 D POST /groups/{groupId}/drive/items/{itemId}/checkin
V1 D POST /groups/{groupId}/drive/items/{itemId}/checkout
V1 D POST /groups/{groupId}/drive/items/{itemId}/copy
V1 D POST /groups/{groupId}/drive/items/{itemId}/createLink
V1 D POST /groups/{groupId}/drive/items/{itemId}/createUploadSession
V1 D POST /groups/{groupId}/drive/items/{itemId}/preview
V1 D POST /groups/{groupId}/drive/items/{itemId}/versions/{version-id}/restoreVersion
V1 D POST /me/drive/items/{id}/workbook/application/calculate
V1 D POST /me/drive/items/{id}/workbook/closeSession
V1 D POST /me/drive/items/{id}/workbook/comments/{id}/replies
V1 D POST /me/drive/items/{id}/workbook/createSession
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/clear
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/delete
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/format/autofitColumns
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/format/autofitRows
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/format/borders
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/format/borders/itemAt
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/format/borders/ItemAt
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/format/fill/clear
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/insert
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/merge
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/row
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/Row
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/sort/apply
V1 D POST /me/drive/items/{id}/workbook/names/{name}/range/unmerge
V1 D POST /me/drive/items/{id}/workbook/names/add
V1 D POST /me/drive/items/{id}/workbook/refreshSession
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/clearFilters
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/filter/apply
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/filter/clear
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/clear
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/delete
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitColumns
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitRows
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/itemAt
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/ItemAt
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/format/fill/clear
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/insert
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/merge
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/row
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/Row
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/sort/apply
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range/unmerge
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/add
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/itemAt
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/columns/ItemAt
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/convertToRange
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/reapplyFilters
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/rows
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/rows/add
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/rows/itemAt
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/rows/ItemAt
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/sort/apply
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/sort/clear
V1 D POST /me/drive/items/{id}/workbook/tables/{id|name}/sort/reapply
V1 D POST /me/drive/items/{id}/workbook/tables/{table-id}/add
V1 D POST /me/drive/items/{id}/workbook/tables/$/add
V1 D POST /me/drive/items/{id}/workbook/tables/add
V1 D POST /me/drive/items/{id}/workbook/worksheets/
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables/{id}/refresh
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id}/pivotTables/refreshAll
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id}/range/resizedRange(deltaRows={n}, deltaColumns={n})
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/format/fill/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/format/fill/setSolidColor
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/setSolidColor
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/itemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/ItemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/itemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/series/ItemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/setData
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/setPosition
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/setSolidColor
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/add
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/itemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/charts/ItemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/names/add
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/pivotTables/refreshAll
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/protection/protect
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/protection/unprotect
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/delete
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/autofitColumns
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/autofitRows
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders/itemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/borders/ItemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/format/fill/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/insert
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/merge
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/row
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/Row
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/sort/apply
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='
')/unmerge
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/clearFilters
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/apply
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/add
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/itemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/columns/ItemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/convertToRange
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/reapplyFilters
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/add
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/rows/ItemAt
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/apply
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/clear
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/{id|name}/sort/reapply
V1 D POST /me/drive/items/{id}/workbook/worksheets/{id|name}/tables/add
V1 D POST /me/drive/items/{id}/workbook/worksheets/add
V1 D POST /me/drive/items/{item-id}/checkin
V1 D POST /me/drive/items/{item-id}/checkout
V1 D POST /me/drive/items/{item-id}/copy
V1 D POST /me/drive/items/{item-id}/follow
V1 D POST /me/drive/items/{item-id}/invite
V1 D POST /me/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1 D POST /me/drive/items/{item-id}/unfollow
V1 D POST /me/drive/items/{item-id}/versions/{version-id}/restoreVersion
V1 D POST /me/drive/items/{itemId}:/{fileName}:/createUploadSession
V1 D POST /me/drive/items/{itemId}/createLink
V1 D POST /me/drive/items/{itemId}/createUploadSession
V1 D POST /me/drive/items/{itemId}/preview
V1 D POST /me/drive/items/{parent-item-id}/children
V1 D POST /me/drive/root:/{item-path}:/workbook/application/calculate
V1 D POST /me/drive/root:/{item-path}:/workbook/closeSession
V1 D POST /me/drive/root:/{item-path}:/workbook/comments/{id}/replies
V1 D POST /me/drive/root:/{item-path}:/workbook/createSession
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/delete
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/autofitColumns
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/autofitRows
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/borders/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/format/fill/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/insert
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/merge
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/row
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/Row
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/sort/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/names/{name}/range/unmerge
V1 D POST /me/drive/root:/{item-path}:/workbook/names/add
V1 D POST /me/drive/root:/{item-path}:/workbook/refreshSession
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/clearFilters
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/filter/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/filter/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/delete
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitColumns
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/autofitRows
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/borders/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/format/fill/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/insert
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/merge
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/row
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/Row
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/sort/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range/unmerge
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/add
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/convertToRange
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/reapplyFilters
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/add
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/rows/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{id|name}/sort/reapply
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/{table-id}/add
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/$/add
V1 D POST /me/drive/root:/{item-path}:/workbook/tables/add
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables/{id}/refresh
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id}/pivotTables/refreshAll
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id}/range/resizedRange(deltaRows={n}, deltaColumns={n})
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/categoryaxis/format/line/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/format/line/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/format/line/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesaxis/majorgridlines/format/line/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/axes/seriesAxis/majorgridlines/format/line/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/format/fill/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/format/fill/setSolidColor
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/legend/format/fill/setSolidColor
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{series-id}/points/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/{undefined}/points/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/series/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/setData
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/setPosition
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/{name}/title/format/fill/setSolidColor
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/add
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/charts/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/names/add
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/pivotTables/refreshAll
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/protection/protect
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/protection/unprotect
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/delete
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/autofitColumns
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/autofitRows
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/borders/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/format/fill/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/insert
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/merge
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/row
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/Row
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/sort/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='
')/unmerge
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/clearFilters
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/{id|name}/filter/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/add
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/columns/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/convertToRange
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/reapplyFilters
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/add
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/itemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/rows/ItemAt
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/apply
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/clear
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/{id|name}/sort/reapply
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables/add
V1 D POST /me/drive/root:/{item-path}:/workbook/worksheets/add
V1 D POST /shares/{encoded-sharing-url}/permission/grant
V1 D POST /shares/{shareId}/driveItem/preview
V1 D POST /sites/{site-id}/drive/items/{item-id}/follow
V1 D POST /sites/{site-id}/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1 D POST /sites/{site-id}/drive/items/{parent-item-id}/children
V1 D POST /sites/{site-id}/lists/{list-id}/items/{listItem-id}/driveItem/permissions/{perm-id}/revokeGrants
V1 D POST /sites/{siteId}/drive/items/{itemId}/checkin
V1 D POST /sites/{siteId}/drive/items/{itemId}/checkout
V1 D POST /sites/{siteId}/drive/items/{itemId}/copy
V1 D POST /sites/{siteId}/drive/items/{itemId}/createLink
V1 D POST /sites/{siteId}/drive/items/{itemId}/createUploadSession
V1 D POST /sites/{siteId}/drive/items/{itemId}/invite
V1 D POST /sites/{siteId}/drive/items/{itemId}/preview
V1 D POST /sites/{siteId}/drive/items/{itemId}/versions/{version-id}/restoreVersion
V1 D POST /sites/{siteId}/lists/{listId}/items/{itemId}/createLink
V1 D POST /sites/{siteId}/pages/{pageId}/publish
V1 D POST /users/{user-id}/drive/items/{item-id}/follow
V1 D POST /users/{user-id}/drive/items/{item-id}/permissions/{perm-id}/revokeGrants
V1 D POST /users/{user-id}/drive/items/{item-id}/unfollow
V1 D POST /users/{user-id}/drive/items/{parent-item-id}/children
V1 D POST /users/{userId}/drive/items/{itemId}/checkin
V1 D POST /users/{userId}/drive/items/{itemId}/checkout
V1 D POST /users/{userId}/drive/items/{itemId}/copy
V1 D POST /users/{userId}/drive/items/{itemId}/createLink
V1 D POST /users/{userId}/drive/items/{itemId}/createUploadSession
V1 D POST /users/{userId}/drive/items/{itemId}/invite
V1 D POST /users/{userId}/drive/items/{itemId}/preview
V1 D POST /users/{userId}/drive/items/{itemId}/versions/{version-id}/restoreVersion
V1 D PUT /drives/{drive-id}/items/{item-id}/content
V1 D PUT /groups/{group-id}/drive/items/{item-id}/content
V1 D PUT /me/drive/items/{item-id}/content
V1 D PUT /sites/{site-id}/drive/items/{item-id}/content
V1 D PUT /users/{user-id}/drive/items/{item-id}/content
V1 D workbook-session-id: {session-id}

Delegate Permission

Id 5c28f0bf-8a70-41f1-8ab2-9032436ddb65
Consent Type User
Display String Have full access to user files
Description Allows the app to read, create, update and delete the signed-in user's files.

Resources

bundle

Chart

Property Type Description
height double Represents the height, in points, of the chart object.
id string Gets a chart based on its position in the collection. Read-only.
left double The distance, in points, from the left side of the chart to the worksheet origin.
name string Represents the name of a chart object.
top double Represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
width double Represents the width, in points, of the chart object.

ChartAxis

Property Type Description
id string Unique identifier. Read-only.
majorUnit Json Represents the interval between two major tick marks. Can be set to a numeric value or an empty string. The returned value is always a number.
maximum Json Represents the maximum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minimum Json Represents the minimum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
minorUnit Json Represents the interval between two minor tick marks. "Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.

ChartAxisTitle

Property Type Description
text string Represents the axis title.
visible boolean A boolean that specifies the visibility of an axis title.

ChartDataLabels

Property Type Description
position string DataLabelPosition value that represents the position of the data label. The possible values are: None, Center, InsideEnd, InsideBase, OutsideEnd, Left, Right, Top, Bottom, BestFit, Callout.
separator string String representing the separator used for the data labels on a chart.
showBubbleSize boolean Boolean value representing if the data label bubble size is visible or not.
showCategoryName boolean Boolean value representing if the data label category name is visible or not.
showLegendKey boolean Boolean value representing if the data label legend key is visible or not.
showPercentage boolean Boolean value representing if the data label percentage is visible or not.
showSeriesName boolean Boolean value representing if the data label series name is visible or not.
showValue boolean Boolean value representing if the data label value is visible or not.

ChartFont

Property Type Description
bold boolean Represents the bold status of font.
color string HTML color code representation of the text color. E.g. #FF0000 represents Red.
italic boolean Represents the italic status of the font.
name string Font name (e.g. "Calibri")
size double Size of the font (e.g. 11)
underline string Type of underline applied to the font. The possible values are: None, Single.

ChartGridlines

Property Type Description
visible boolean Boolean value representing if the axis gridlines are visible or not.

ChartLegend

Property Type Description
overlay boolean Boolean value for whether the chart legend should overlap with the main body of the chart.
position string Represents the position of the legend on the chart. The possible values are: Top, Bottom, Left, Right, Corner, Custom.
visible boolean A boolean value the represents the visibility of a ChartLegend object.

ChartLineFormat

Property Type Description
color string HTML color code representing the color of lines in the chart.

ChartPoint

Property Type Description
id string unique identifier
value Json Returns the value of a chart point. Read-only.

ChartSeries

Property Type Description
name string Represents the name of a series in a chart.

ChartTitle

Property Type Description
overlay boolean Boolean value representing if the chart title will overlay the chart or not.
text string Represents the title text of a chart.
visible boolean A boolean value the represents the visibility of a chart title object.

deleted

Property Type Description
state String Represents the state of the deleted item.

drive

Property Type Description
createdBy [identitySet][] Identity of the user, device, or application which created the item. Read-only.
createdDateTime dateTimeOffset Date and time of item creation. Read-only.
description String Provide a user-visible description of the drive. Read-write.
driveType String Describes the type of drive represented by this resource. OneDrive personal drives will return personal. OneDrive for Business will return business. SharePoint document libraries will return documentLibrary. Read-only.
id String The unique identifier of the drive. Read-only.
lastModifiedBy [identitySet][] Identity of the user, device, and application which last modified the item. Read-only.
lastModifiedDateTime dateTimeOffset Date and time the item was last modified. Read-only.
name string The name of the item. Read-write.
owner identitySet Optional. The user account that owns the drive. Read-only.
quota quota Optional. Information about the drive's storage space quota. Read-only.
sharepointIds [sharepointIds][] Returns identifiers useful for SharePoint REST compatibility. Read-only. This property is not returned by default and must be selected using the $select query parameter.
system [systemFacet][] If present, indicates that this is a system-managed drive. Read-only.
webUrl string (url) URL that displays the resource in the browser. Read-only.

driveItem

Property Type Description
audio [audio][] Audio metadata, if the item is an audio file. Read-only. Read-only. Only on OneDrive Personal.
bundle [bundle][] Bundle metadata, if the item is a bundle. Read-only.
content Stream The content stream, if the item represents a file.
createdBy [identitySet][] Identity of the user, device, and application which created the item. Read-only.
createdDateTime DateTimeOffset Date and time of item creation. Read-only.
cTag String An eTag for the content of the item. This eTag is not changed if only the metadata is changed. Note This property is not returned if the item is a folder. Read-only.
deleted [deleted][] Information about the deleted state of the item. Read-only.
description String Provides a user-visible description of the item. Read-write. Only on OneDrive Personal.
eTag String eTag for the entire item (metadata + content). Read-only.
file [file][] File metadata, if the item is a file. Read-only.
fileSystemInfo [fileSystemInfo][] File system information on client. Read-write.
folder [folder][] Folder metadata, if the item is a folder. Read-only.
id String The unique identifier of the item within the Drive. Read-only.
image [image][] Image metadata, if the item is an image. Read-only.
lastModifiedBy [identitySet][] Identity of the user, device, and application which last modified the item. Read-only.
lastModifiedDateTime DateTimeOffset Date and time the item was last modified. Read-only.
location [geoCoordinates][] Location metadata, if the item has location data. Read-only.
malware [malware][] Malware metadata, if the item was detected to contain malware. Read-only.
name String The name of the item (filename and extension). Read-write.
package [package][] If present, indicates that this item is a package instead of a folder or file. Packages are treated like files in some contexts and folders in others. Read-only.
parentReference [itemReference][] Parent information, if the item has a parent. Read-write.
pendingOperations [pendingOperations][] If present, indicates that one or more operations that might affect the state of the driveItem are pending completion. Read-only.
photo [photo][] Photo metadata, if the item is a photo. Read-only.
publication [publicationFacet][] Provides information about the published or checked-out state of an item, in locations that support such actions. This property is not returned by default. Read-only.
remoteItem [remoteItem][] Remote item data, if the item is shared from a drive other than the one being accessed. Read-only.
root [root][] If this property is non-null, it indicates that the driveItem is the top-most driveItem in the drive.
searchResult [searchResult][] Search metadata, if the item is from a search result. Read-only.
shared [shared][] Indicates that the item has been shared with others and provides information about the shared state of the item. Read-only.
sharepointIds [sharepointIds][] Returns identifiers useful for SharePoint REST compatibility. Read-only.
size Int64 Size of the item in bytes. Read-only.
specialFolder [specialFolder][] If the current item is also available as a special folder, this facet is returned. Read-only.
video [video][] Video metadata, if the item is a video. Read-only.
webDavUrl String WebDAV compatible URL for the item.
webUrl String URL that displays the resource in the browser. Read-only.

driverecipient

formatProtection

Property Type Description
formulaHidden boolean Indicates if Excel hides the formula for the cells in the range. A null value indicates that the entire range doesn't have uniform formula hidden setting.
locked boolean Indicates if Excel locks the cells in the object. A null value indicates that the entire range doesn't have uniform lock setting.

Icon

Property Type Description
index int Represents the index of the icon in the given set.
set string Represents the set that the icon is part of. The possible values are: Invalid, ThreeArrows, ThreeArrowsGray, ThreeFlags, ThreeTrafficLights1, ThreeTrafficLights2, ThreeSigns, ThreeSymbols, ThreeSymbols2, FourArrows, FourArrowsGray, FourRedToBlack, FourRating, FourTrafficLights, FiveArrows, FiveArrowsGray, FiveRating, FiveQuarters, ThreeStars, ThreeTriangles, FiveBoxes.

itemActivity

Property Type Description
access [accessAction][] An item was accessed.
activityDateTime DateTimeOffset Details about when the activity took place. Read-only.
actor [identitySet][] Identity of who performed the action. Read-only.
id string The unique identifier of the activity. Read-only.

itemActivityStat

Property Type Description
access [itemActionStat][] Statistics about the access actions in this interval. Read-only.
create [itemActionStat][] Statistics about the create actions in this interval. Read-only.
delete [itemActionStat][] Statistics about the delete actions in this interval. Read-only.
edit [itemActionStat][] Statistics about the edit actions in this interval. Read-only.
endDateTime DateTimeOffset When the interval ends. Read-only.
incompleteData [incompleteData][] Indicates that the statistics in this interval are based on incomplete data. Read-only.
isTrending Boolean Indicates whether the item is "trending." Read-only.
move [itemActionStat][] Statistics about the move actions in this interval. Read-only.
startDateTime DateTimeOffset When the interval starts. Read-only.

itemAnalytics

Property Type Description
allTime [itemActivityStat][] Analytics over the item's lifespan.
lastSevenDays [itemActivityStat][] Analytics for the last seven days.

ItemReference

Property Type Description
driveId String Unique identifier of the drive instance that contains the item. Read-only.
driveType String Identifies the type of drive. See [drive][] resource for values.
id String Unique identifier of the item in the drive. Read-only.
name String The name of the item being referenced. Read-only.
path String Path that can be used to navigate to the item. Read-only.
shareId String A unique identifier for a shared resource that can be accessed via the [Shares][] API.
sharepointIds [sharepointIds][] Returns identifiers useful for SharePoint REST compatibility. Read-only.
siteId String For OneDrive for Business and SharePoint, this property represents the ID of the site that contains the parent document library of the driveItem resource. The value is the same as the id property of that site][] resource. It is an [opaque string that consists of three identifiers of the site.
For OneDrive, this property is not populated.

json

list

listitem

Property Type Description
contentType [contentTypeInfo][] The content type of this list item

NamedItem

Property Type Description
comment string Represents the comment associated with this name.
name string The name of the object. Read-only.
scope string Indicates whether the name is scoped to the workbook or to a specific worksheet. Read-only.
type string Indicates what type of reference is associated with the name. The possible values are: String, Integer, Double, Boolean, Range. Read-only.
value Json Represents the formula that the name is defined to refer to. E.g. =Sheet14!$B$2:$H$12, =4.75, etc. Read-only.
visible boolean Specifies whether the object is visible or not.

Permission

Property Type Description
expirationDateTime DateTimeOffset A format of yyyy-MM-ddTHH:mm:ssZ of DateTimeOffset indicates the expiration time of the permission. DateTime.MinValue indicates there is no expiration set for this permission. Optional.
id String The unique identifier of the permission among all permissions on the item. Read-only.
hasPassword Boolean Indicates whether the password is set for this permission. This property only appears in the response. Optional. Read-only. For OneDrive Personal only..
grantedTo (deprecated) IdentitySet For user type permissions, the details of the users and applications for this permission. Read-only.
grantedToIdentities (deprecated) Collection(IdentitySet) For type permissions, the details of the users to whom permission was granted. Read-only.
grantedToIdentitiesV2 Collection([SharePointIdentitySet][]) For link type permissions, the details of the users to whom permission was granted. Read-only.
grantedToV2 [SharePointIdentitySet][] For user type permissions, the details of the users and applications for this permission. Read-only.
inheritedFrom ItemReference Provides a reference to the ancestor of the current permission, if it is inherited from an ancestor. Read-only.
invitation [SharingInvitation][] Details of any associated sharing invitation for this permission. Read-only.
link [SharingLink][] Provides the link details of the current permission, if it is a link type permissions. Read-only.
roles Collection of String The type of permission, for example, read. See below for the full list of roles. Read-only.
shareId String A unique token that can be used to access this shared item via the shares API. Read-only.

Range

Property Type Description
address string Represents the range reference in A1-style. Address value will contain the Sheet reference (e.g. Sheet1!A1:B4). Read-only.
addressLocal string Represents range reference for the specified range in the language of the user. Read-only.
cellCount int Number of cells in the range. Read-only.
columnCount int Represents the total number of columns in the range. Read-only.
columnHidden boolean Represents if all columns of the current range are hidden.
columnIndex int Represents the column number of the first cell in the range. Zero-indexed. Read-only.
formulas Json Represents the formula in A1-style notation.
formulasLocal Json Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German.
formulasR1C1 Json Represents the formula in R1C1-style notation.
hidden boolean Represents if all cells of the current range are hidden. Read-only.
numberFormat Json Represents Excel's number format code for the given cell.
rowCount int Returns the total number of rows in the range. Read-only.
rowHidden boolean Represents if all rows of the current range are hidden.
rowIndex int Returns the row number of the first cell in the range. Zero-indexed. Read-only.
text Json Text values of the specified range. The Text value will not depend on the cell width. The # sign substitution that happens in Excel UI will not affect the text value returned by the API. Read-only.
valueTypes Json Represents the type of data of each cell. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only.
values Json Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

RangeBorder

Property Type Description
color string HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange").
id string Represents border identifier. The possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
sideIndex string Constant value that indicates the specific side of the border. The possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
style string One of the constants of line style specifying the line style for the border. The possible values are: None, Continuous, Dash, DashDot, DashDotDot, Dot, Double, SlantDashDot.
weight string Specifies the weight of the border around a range. The possible values are: Hairline, Thin, Medium, Thick.

RangeFill

Property Type Description
color string HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange")

RangeFont

Property Type Description
bold boolean Represents the bold status of font.
color string HTML color code representation of the text color. E.g. #FF0000 represents Red.
italic boolean Represents the italic status of the font.
name string Font name (e.g. "Calibri")
size double Font size.
underline string Type of underline applied to the font. The possible values are: None, Single, Double, SingleAccountant, DoubleAccountant.

RangeFormat

Property Type Description
columnWidth double Gets or sets the width of all colums within the range. If the column widths are not uniform, null will be returned.
horizontalAlignment string Represents the horizontal alignment for the specified object. The possible values are: General, Left, Center, Right, Fill, Justify, CenterAcrossSelection, Distributed.
rowHeight double Gets or sets the height of all rows in the range. If the row heights are not uniform null will be returned.
verticalAlignment string Represents the vertical alignment for the specified object. The possible values are: Top, Center, Bottom, Justify, Distributed.
wrapText boolean Indicates if Excel wraps the text in the object. A null value indicates that the entire range doesn't have uniform wrap setting

remoteItem

sharedDriveItem

Property Type Description
id String The unique identifier for the share being accessed.
name String The display name of the shared item.
owner identitySet Information about the owner of the shared item being referenced.

sharingInvitation

sharingLink

Property Type Description
application [identity][] The app the link is associated with.
preventsDownload Boolean If true then the user can only use this link to view the item on the web, and cannot use it to download the contents of the item. Only for OneDrive for Business and SharePoint.
scope String The scope of the link represented by this permission. Value anonymous indicates the link is usable by anyone, organization indicates the link is only usable for users signed into the same tenant.
type String The type of the link created.
webHtml String For embed links, this property contains the HTML code for an <iframe> element that will embed the item in a webpage.
webUrl String A URL that opens the item in the browser on the OneDrive website.

site

Property Type Description
createdDateTime DateTimeOffset The date and time the item was created. Read-only.
description string The descriptive text for the site.
displayName string The full title for the site. Read-only.
eTag string ETag for the item. Read-only.
id string The unique identifier of the item. Read-only.
lastModifiedDateTime DateTimeOffset The date and time the item was last modified. Read-only.
name string The name / title of the item.
root root If present, indicates that this is the root site in the site collection. Read-only.
sharepointIds sharepointIds Returns identifiers useful for SharePoint REST compatibility. Read-only.
siteCollection siteCollection Provides details about the site's site collection. Available only on the root site. Read-only.
webUrl string (url) URL that displays the item in the browser. Read-only.

sitePage

Property Type Description
contentType contentTypeInfo Inherited from baseItem.
createdBy identitySet Inherited from baseItem.
createdDateTime DateTimeOffset Inherited from baseItem.
description String Inherited from baseItem.
eTag String Inherited from baseItem.
id String Inherited from entity.
lastModifiedBy identitySet Inherited from baseItem.
lastModifiedDateTime DateTimeOffset Inherited from baseItem.
name String Inherited from baseItem.
pageLayout pageLayoutType The name of the page layout of the page. The possible values are: microsoftReserved, article, home, unknownFutureValue.
parentReference itemReference Inherited from baseItem.
promotionKind pagePromotionType Indicates the promotion kind of the sitePage. The possible values are: microsoftReserved, page, newsPost, unknownFutureValue.
publishingState publicationFacet The publishing status and the MM.mm version of the page.
reactions reactionsFacet Reactions information for the page.
showComments Boolean Determines whether or not to show comments at the bottom of the page.
showRecommendedPages Boolean Determines whether or not to show recommended pages at the bottom of the page.
thumbnailWebUrl String Url of the sitePage's thumbnail image
title String Title of the sitePage.
titleArea titleArea Title area on the SharePoint page.
webUrl String Inherited from baseItem.

subscription

Property Type Description
applicationId String Optional. Identifier of the application used to create the subscription. Read-only.
changeType String Required. Indicates the type of change in the subscribed resource that will raise a change notification. The supported values are: created, updated, deleted. Multiple values can be combined using a comma-separated list.

Note:
  • Drive root item and list change notifications support only the updated changeType.
  • User and group change notifications support updated and deleted changeType. Use updated to receive notifications when user or group is created, updated or soft deleted. Use deleted to receive notifications when user or group is permanently deleted.
  • clientState String Optional. Specifies the value of the clientState property sent by the service in each change notification. The maximum length is 128 characters. The client can check that the change notification came from the service by comparing the value of the clientState property sent with the subscription with the value of the clientState property received with each change notification.
    creatorId String Optional. Identifier of the user or service principal that created the subscription. If the app used delegated permissions to create the subscription, this field contains the id of the signed-in user the app called on behalf of. If the app used application permissions, this field contains the id of the service principal corresponding to the app. Read-only.
    encryptionCertificate String Optional. A base64-encoded representation of a certificate with a public key used to encrypt resource data in change notifications. Optional but required when includeResourceData is true.
    encryptionCertificateId String Optional. A custom app-provided identifier to help identify the certificate needed to decrypt resource data.
    expirationDateTime DateTimeOffset Required. Specifies the date and time when the webhook subscription expires. The time is in UTC, and can be an amount of time from subscription creation that varies for the resource subscribed to. For the maximum supported subscription length of time, see the table below.
    id String Optional. Unique identifier for the subscription. Read-only.
    includeResourceData Boolean Optional. When set to true, change notifications include resource data (such as content of a chat message).
    latestSupportedTlsVersion String Optional. Specifies the latest version of Transport Layer Security (TLS) that the notification endpoint, specified by notificationUrl, supports. The possible values are: v1_0, v1_1, v1_2, v1_3.
    For subscribers whose notification endpoint supports a version lower than the currently recommended version (TLS 1.2), specifying this property by a set timeline allows them to temporarily use their deprecated version of TLS before completing their upgrade to TLS 1.2. For these subscribers, not setting this property per the timeline would result in subscription operations failing.

    For subscribers whose notification endpoint already supports TLS 1.2, setting this property is optional. In such cases, Microsoft Graph defaults the property to v1_2.
    lifecycleNotificationUrl String Optional. The URL of the endpoint that receives lifecycle notifications, including subscriptionRemoved, reauthorizationRequired, and missed notifications. This URL must make use of the HTTPS protocol.
    notificationQueryOptions String Optional. OData query options for specifying value for the targeting resource. Clients receive notifications when resource reaches the state matching the query options provided here. With this new property in the subscription creation payload along with all existing properties, Webhooks will deliver notifications whenever a resource reaches the desired state mentioned in the notificationQueryOptions property. For example, when the print job is completed or when a print job resource isFetchable property value becomes true etc.

    Supported only for Universal Print Service. For more information, see Subscribe to change notifications from cloud printing APIs using Microsoft Graph.
    notificationUrl String Required. The URL of the endpoint that will receive the change notifications. This URL must make use of the HTTPS protocol.
    notificationUrlAppId String Optional. The app ID that the subscription service can use to generate the validation token. This allows the client to validate the authenticity of the notification received.
    resource String Required. Specifies the resource that will be monitored for changes. Do not include the base URL (https://graph.microsoft.com/v1.0/). See the possible resource path values for each supported resource.

    systemfacet

    Table

    Property Type Description
    highlightFirstColumn Boolean Indicates whether the first column contains special formatting.
    highlightLastColumn Boolean Indicates whether the last column contains special formatting.
    id string Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
    legacyId String Legacy Id used in older Excle clients. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
    name string Name of the table.
    showBandedRows Boolean Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.
    showBandedColumns Boolean Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.
    showFilterButton Boolean Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.
    showHeaders boolean Indicates whether the header row is visible or not. This value can be set to show or remove the header row.
    showTotals boolean Indicates whether the total row is visible or not. This value can be set to show or remove the total row.
    style string Constant value that represents the Table style. The possible values are: TableStyleLight1 thru TableStyleLight21, TableStyleMedium1 thru TableStyleMedium28, TableStyleStyleDark1 thru TableStyleStyleDark11. A custom user-defined style present in the workbook can also be specified.

    TableSort

    Property Type Description
    fields WorkbookSortField collection Represents the current conditions used to last sort the table. Read-only.
    matchCase boolean Represents whether the casing impacted the last sort of the table. Read-only.
    method string Represents Chinese character ordering method last used to sort the table. The possible values are: PinYin, StrokeCount. Read-only.

    Thumbnail

    Property Type Description
    content Stream The content stream for the thumbnail.
    height Int32 The height of the thumbnail, in pixels.
    sourceItemId String The unique identifier of the item that provided the thumbnail. This is only available when a folder thumbnail is requested.
    url String The URL used to fetch the thumbnail content.
    width Int32 The width of the thumbnail, in pixels.

    ThumbnailSet

    Property Type Description
    id String The id within the item. Read-only.
    large Thumbnail A 1920x1920 scaled thumbnail.
    medium Thumbnail A 176x176 scaled thumbnail.
    small Thumbnail A 48x48 cropped thumbnail.
    source Thumbnail A custom thumbnail image or the original image used to generate other thumbnails.

    uploadSession

    Property Type Description
    expirationDateTime DateTimeOffset The date and time in UTC that the upload session will expire. The complete file must be uploaded before this expiration time is reached.
    nextExpectedRanges String collection A collection of byte ranges that the server is missing for the file. These ranges are zero indexed and of the format "start-end" (e.g. "0-26" to indicate the first 27 bytes of the file). When uploading files as Outlook attachments, instead of a collection of ranges, this property always indicates a single value "{start}", the location in the file where the next upload should begin.
    uploadUrl String The URL endpoint that accepts PUT requests for byte ranges of the file.

    workbookApplication

    Property Type Description
    calculationMode string Returns the calculation mode used in the workbook. Possible values are: Automatic, AutomaticExceptTables, Manual.

    workbookChart

    Property Type Description
    height double Represents the height, in points, of the chart object.
    id string Gets a chart based on its position in the collection. Read-only.
    left double The distance, in points, from the left side of the chart to the worksheet origin.
    name string Represents the name of a chart object.
    top double Represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
    width double Represents the width, in points, of the chart object.

    workbookChartAxis

    Property Type Description
    id string Unique identifier. Read-only.
    majorUnit Json Represents the interval between two major tick marks. Can be set to a numeric value or an empty string. The returned value is always a number.
    maximum Json Represents the maximum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
    minimum Json Represents the minimum value on the value axis. Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.
    minorUnit Json Represents the interval between two minor tick marks. "Can be set to a numeric value or an empty string (for automatic axis values). The returned value is always a number.

    workbookChartAxisTitle

    Property Type Description
    text string Represents the axis title.
    visible boolean A boolean that specifies the visibility of an axis title.

    workbookChartDataLabels

    Property Type Description
    position string DataLabelPosition value that represents the position of the data label. The possible values are: None, Center, InsideEnd, InsideBase, OutsideEnd, Left, Right, Top, Bottom, BestFit, Callout.
    separator string String representing the separator used for the data labels on a chart.
    showBubbleSize boolean Boolean value representing if the data label bubble size is visible or not.
    showCategoryName boolean Boolean value representing if the data label category name is visible or not.
    showLegendKey boolean Boolean value representing if the data label legend key is visible or not.
    showPercentage boolean Boolean value representing if the data label percentage is visible or not.
    showSeriesName boolean Boolean value representing if the data label series name is visible or not.
    showValue boolean Boolean value representing if the data label value is visible or not.

    workbookChartFont

    Property Type Description
    bold boolean Represents the bold status of font.
    color string HTML color code representation of the text color. E.g. #FF0000 represents Red.
    italic boolean Represents the italic status of the font.
    name string Font name (e.g. "Calibri")
    size double Size of the font (e.g. 11)
    underline string Type of underline applied to the font. The possible values are: None, Single.

    workbookChartGridlines

    Property Type Description
    visible boolean Boolean value representing if the axis gridlines are visible or not.

    workbookChartLegend

    Property Type Description
    overlay boolean Boolean value for whether the chart legend should overlap with the main body of the chart.
    position string Represents the position of the legend on the chart. The possible values are: Top, Bottom, Left, Right, Corner, Custom.
    visible boolean A boolean value the represents the visibility of a ChartLegend object.

    workbookChartLineFormat

    Property Type Description
    color string HTML color code representing the color of lines in the chart.

    workbookChartPoint

    Property Type Description
    value Json Returns the value of a chart point. Read-only.
    id string unique identifier

    workbookChartSeries

    Property Type Description
    name string Represents the name of a series in a chart.

    workbookChartTitle

    Property Type Description
    overlay boolean Boolean value representing if the chart title will overlay the chart or not.
    text string Represents the title text of a chart.
    visible boolean A boolean value the represents the visibility of a chart title object.

    workbookComment

    Property Type Description
    content String The content of comment.
    contentType String Indicates the type for the comment.
    id String Represents the comment identifier. Read-only.

    workbookCommentReply

    Property Type Description
    content String The content of a comment reply.
    contentType String Indicates the type for the comment reply.
    id String Represents the comment identifier. Read-only.

    workbookIcon

    Property Type Description
    index int Represents the index of the icon in the given set.
    set string Represents the set that the icon is part of. Possible values are: Invalid, ThreeArrows, ThreeArrowsGray, ThreeFlags, ThreeTrafficLights1, ThreeTrafficLights2, ThreeSigns, ThreeSymbols, ThreeSymbols2, FourArrows, FourArrowsGray, FourRedToBlack, FourRating, FourTrafficLights, FiveArrows, FiveArrowsGray, FiveRating, FiveQuarters, ThreeStars, ThreeTriangles, FiveBoxes.

    workbookNamedItem

    Property Type Description
    name string The name of the object. Read-only.
    comment string Represents the comment associated with this name.
    scope string Indicates whether the name is scoped to the workbook or to a specific worksheet. Read-only.
    type string Indicates what type of reference is associated with the name. Possible values are: String, Integer, Double, Boolean, Range. Read-only.
    value string Represents the formula that the name is defined to refer to. E.g. =Sheet14!$B$2:$H$12, =4.75, etc. Read-only.
    visible boolean Specifies whether the object is visible or not.

    workbookOperation

    Property Type Description
    error workbookOperationError The error returned by the operation.
    id String The operation id. Read-only.
    resourceLocation String The resource URI for the result.
    status String The current status of the operation. Possible values are: NotStarted, Running, Completed, Failed.
    StatusCode integer Status code of the operation.

    pivotTable

    Property Type Description
    id String Id of the PivotTable. Read-only.
    name String Name of the PivotTable.

    workbookRange

    Property Type Description
    address string Represents the range reference in A1-style. Address value will contain the Sheet reference (e.g. Sheet1!A1:B4). Read-only.
    addressLocal string Represents range reference for the specified range in the language of the user. Read-only.
    cellCount int Number of cells in the range. Read-only.
    columnCount int Represents the total number of columns in the range. Read-only.
    columnHidden boolean Represents if all columns of the current range are hidden.
    columnIndex int Represents the column number of the first cell in the range. Zero-indexed. Read-only.
    formulas Json Represents the formula in A1-style notation.
    formulasLocal Json Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German.
    formulasR1C1 Json Represents the formula in R1C1-style notation.
    hidden boolean Represents if all cells of the current range are hidden. Read-only.
    numberFormat Json Represents Excel's number format code for the given cell.
    rowCount int Returns the total number of rows in the range. Read-only.
    rowHidden boolean Represents if all rows of the current range are hidden.
    rowIndex int Returns the row number of the first cell in the range. Zero-indexed. Read-only.
    text Json Text values of the specified range. The Text value will not depend on the cell width. The # sign substitution that happens in Excel UI will not affect the text value returned by the API. Read-only.
    valueTypes string Represents the type of data of each cell. Possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only.
    values Json Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

    workbookRangeBorder

    Property Type Description
    color string HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange").
    id string Represents border identifier. Possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
    sideIndex string Constant value that indicates the specific side of the border. Possible values are: EdgeTop, EdgeBottom, EdgeLeft, EdgeRight, InsideVertical, InsideHorizontal, DiagonalDown, DiagonalUp. Read-only.
    style string One of the constants of line style specifying the line style for the border. Possible values are: None, Continuous, Dash, DashDot, DashDotDot, Dot, Double, SlantDashDot.
    weight string Specifies the weight of the border around a range. Possible values are: Hairline, Thin, Medium, Thick.

    workbookRangeFill

    Property Type Description
    color string HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange")

    workbookRangeFont

    Property Type Description
    bold boolean Represents the bold status of font.
    color string HTML color code representation of the text color. E.g. #FF0000 represents Red.
    italic boolean Represents the italic status of the font.
    name string Font name (e.g. "Calibri")
    size double Font size.
    underline String Type of underline applied to the font. Possible values are: None, Single, Double, SingleAccountant, DoubleAccountant.

    workbookRangeFormat

    Property Type Description
    columnWidth double Gets or sets the width of all colums within the range. If the column widths are not uniform, null will be returned.
    horizontalAlignment string Represents the horizontal alignment for the specified object. Possible values are: General, Left, Center, Right, Fill, Justify, CenterAcrossSelection, Distributed.
    rowHeight double Gets or sets the height of all rows in the range. If the row heights are not uniform null will be returned.
    verticalAlignment string Represents the vertical alignment for the specified object. Possible values are: Top, Center, Bottom, Justify, Distributed.
    wrapText boolean Indicates if Excel wraps the text in the object. A null value indicates that the entire range doesn't have uniform wrap setting

    rangeView

    Property Type Description
    cellAddresses Json Represents the cell addresses
    columnCount Int32 Returns the number of visible columns. Read-only.
    formulas Json Represents the formula in A1-style notation.
    formulasLocal Json Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German.
    formulasR1C1 Json Represents the formula in R1C1-style notation.
    index Int32 Index of the range.
    numberFormat Json Represents Excel's number format code for the given cell. Read-only.
    rowCount Int32 Returns the number of visible rows. Read-only.
    text Json Text values of the specified range. The Text value will not depend on the cell width. The # sign substitution that happens in Excel UI will not affect the text value returned by the API. Read-only.
    valueTypes Json Represents the type of data of each cell. Read-only. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error.
    values Json Represents the raw values of the specified range view. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

    workbookSessionInfo

    Property Type Description
    id string Id of the workbook session.
    persistChanges boolean true for persistent session. false for non-persistent session (view mode)

    workbookTable

    Property Type Description
    id string Returns a value that uniquely identifies the table in a given workbook. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
    name string Name of the table.
    showHeaders boolean Indicates whether the header row is visible or not. This value can be set to show or remove the header row.
    showTotals boolean Indicates whether the total row is visible or not. This value can be set to show or remove the total row.
    style string Constant value that represents the Table style. Possible values are: TableStyleLight1 thru TableStyleLight21, TableStyleMedium1 thru TableStyleMedium28, TableStyleStyleDark1 thru TableStyleStyleDark11. A custom user-defined style present in the workbook can also be specified.
    highlightFirstColumn Boolean Indicates whether the first column contains special formatting.
    highlightLastColumn Boolean Indicates whether the last column contains special formatting.
    showBandedColumns Boolean Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.
    showBandedRows Boolean Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.
    showFilterButton Boolean Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.
    legacyId String Legacy Id used in older Excle clients. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.

    workbookTableColumn

    Property Type Description
    id string Returns a unique key that identifies the column within the table. This property should be interpreted as an opaque string value and should not be parsed to any other type. Read-only.
    index int Returns the index number of the column within the columns collection of the table. Zero-indexed. Read-only.
    name string Returns the name of the table column.
    values Json Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

    workbookTableRow

    Property Type Description
    index Int32 Returns the index number of the row within the rows collection of the table. Zero-indexed. Read-only.
    values Json Represents the raw values of the specified range. The data returned could be of type string, number, or a boolean. Cell that contain an error will return the error string.

    workbookTableSort

    Property Type Description
    matchCase boolean Represents whether the casing impacted the last sort of the table. Read-only.
    method string Represents Chinese character ordering method last used to sort the table. Possible values are: PinYin, StrokeCount. Read-only.

    workbookWorksheet

    Property Type Description
    id string Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved. Read-only.
    name string The display name of the worksheet.
    position int The zero-based position of the worksheet within the workbook.
    visibility string The Visibility of the worksheet. The possible values are: Visible, Hidden, VeryHidden.

    workbookWorksheetProtection

    Property Type Description
    options workbookWorksheetProtectionOptions Sheet protection options. Read-only.
    protected boolean Indicates if the worksheet is protected. Read-only.

    workbookWorksheetProtectionOptions

    Property Type Description
    allowAutoFilter boolean Represents the worksheet protection option of allowing using auto filter feature.
    allowDeleteColumns boolean Represents the worksheet protection option of allowing deleting columns.
    allowDeleteRows boolean Represents the worksheet protection option of allowing deleting rows.
    allowFormatCells boolean Represents the worksheet protection option of allowing formatting cells.
    allowFormatColumns boolean Represents the worksheet protection option of allowing formatting columns.
    allowFormatRows boolean Represents the worksheet protection option of allowing formatting rows.
    allowInsertColumns boolean Represents the worksheet protection option of allowing inserting columns.
    allowInsertHyperlinks boolean Represents the worksheet protection option of allowing inserting hyperlinks.
    allowInsertRows boolean Represents the worksheet protection option of allowing inserting rows.
    allowPivotTables boolean Represents the worksheet protection option of allowing using pivot table feature.
    allowSort boolean Represents the worksheet protection option of allowing using sort feature.

    Worksheet

    Property Type Description
    id string Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved. Read-only.
    name string The display name of the worksheet.
    position int The zero-based position of the worksheet within the workbook.
    visibility string The Visibility of the worksheet. The possible values are: Visible, Hidden, VeryHidden.

    WorksheetProtection

    Property Type Description
    options workbookWorksheetProtectionOptions Sheet protection options. Read-only.
    protected boolean Indicates if the worksheet is protected. Read-only.
    In This Article
    Back to top Created by merill | Submit feedback