# Microsoft OneDrive Drives.drive.Functions API

**Canonical:** https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-drive-functions-api/  
**Provider:** Microsoft OneDrive — https://apis.io/providers/microsoft-onedrive/  
**Base URL:** https://graph.microsoft.com/v1.0  
**Documentation:** https://learn.microsoft.com/en-us/onedrive/developer/controls/file-pickers/

Microsoft OneDrive Drives.drive.Functions API is one of 13 APIs that [Microsoft OneDrive](https://apis.io/providers/microsoft-onedrive/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. This API exposes 4 JSON Schema definitions. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, and 4 JSON Schemas.

The drives.drive.Functions API from Microsoft OneDrive — 599 operation(s) for drives.drive.functions.

## Operations (60 of 599)

| Method | Path | Summary |
|---|---|---|
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/boundingRect(anotherRange='{anotherRange}')` | Invoke function boundingRect |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/cell(row={row},column={column})` | Invoke function cell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/column(column={column})` | Invoke function column |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsAfter()` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsAfter(count={count})` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsBefore()` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/columnsBefore(count={count})` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/entireColumn()` | Invoke function entireColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/entireRow()` | Invoke function entireRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/intersection(anotherRange='{anotherRange}')` | Invoke function intersection |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastCell()` | Invoke function lastCell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastColumn()` | Invoke function lastColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/lastRow()` | Invoke function lastRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})` | Invoke function offsetRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})` | Invoke function resizedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/row(row={row})` | Invoke function row |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsAbove()` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsAbove(count={count})` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsBelow()` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/rowsBelow(count={count})` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/usedRange()` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/usedRange(valuesOnly={valuesOnly})` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/names/{workbookNamedItem-id}/range()/visibleView()` | Invoke function visibleView |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/boundingRect(anotherRange='{anotherRange}')` | Invoke function boundingRect |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/cell(row={row},column={column})` | Invoke function cell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/column(column={column})` | Invoke function column |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter()` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsAfter(count={count})` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore()` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/columnsBefore(count={count})` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireColumn()` | Invoke function entireColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/entireRow()` | Invoke function entireRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/intersection(anotherRange='{anotherRange}')` | Invoke function intersection |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastCell()` | Invoke function lastCell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastColumn()` | Invoke function lastColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/lastRow()` | Invoke function lastRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})` | Invoke function offsetRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/resizedRange(deltaRows={deltaRows},deltaColumns={deltaColumns})` | Invoke function resizedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/row(row={row})` | Invoke function row |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove()` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsAbove(count={count})` | Invoke function rowsAbove |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow()` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/rowsBelow(count={count})` | Invoke function rowsBelow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange()` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/usedRange(valuesOnly={valuesOnly})` | Invoke function usedRange |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/dataBodyRange()/visibleView()` | Invoke function visibleView |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/boundingRect(anotherRange='{anotherRange}')` | Invoke function boundingRect |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/cell(row={row},column={column})` | Invoke function cell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/column(column={column})` | Invoke function column |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter()` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsAfter(count={count})` | Invoke function columnsAfter |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore()` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/columnsBefore(count={count})` | Invoke function columnsBefore |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireColumn()` | Invoke function entireColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/entireRow()` | Invoke function entireRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/intersection(anotherRange='{anotherRange}')` | Invoke function intersection |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastCell()` | Invoke function lastCell |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastColumn()` | Invoke function lastColumn |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/lastRow()` | Invoke function lastRow |
| GET | `/drives/{drive-id}/items/{driveItem-id}/workbook/tables/{workbookTable-id}/columns/{workbookTableColumn-id}/headerRowRange()/offsetRange(rowOffset={rowOffset},columnOffset={columnOffset})` | Invoke function offsetRange |

…and 539 more operations. The page lists the first 250; the full set of 599 is in the OpenAPI linked below.

## Machine-readable artifacts (7)

- **OpenAPI** — https://artifacts.apis.io/microsoft-onedrive/openapi/microsoft-onedrive-drives-drive-functions-api-openapi.yml
- **Documentation** — https://learn.microsoft.com/en-us/onedrive/developer/rest-api/
- **Reference** — https://learn.microsoft.com/en-us/graph/api/resources/onedrive
- **JSONSchema** — https://artifacts.apis.io/microsoft-onedrive/json-schema/microsoft-onedrive-microsoft-graph-drive-item-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-onedrive/json-schema/microsoft-onedrive-microsoft-graph-workbook-range-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-onedrive/json-schema/microsoft-onedrive-microsoft-graph-workbook-range-view-schema.json
- **JSONSchema** — https://artifacts.apis.io/microsoft-onedrive/json-schema/microsoft-onedrive-base-collection-pagination-count-response-schema.json

## Other Microsoft OneDrive APIs (12)

- [OneDrive File Picker](https://apis.io/apis/microsoft-onedrive/file-picker/)
- [OneDrive](https://apis.io/apis/microsoft-onedrive/onedrive/)
- [Microsoft OneDrive Drives.drive.Actions API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-drive-actions-api/)
- [Microsoft OneDrive Drives.drive API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-drive-api/)
- [Microsoft OneDrive Drives.drive Item API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-driveitem-api/)
- [Microsoft OneDrive Drives.list API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-list-api/)
- [Microsoft OneDrive Drives.user API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-user-api/)
- [Microsoft OneDrive Groups.drive API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-groups-drive-api/)
- [Microsoft OneDrive Groups.site API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-groups-site-api/)
- [Microsoft OneDrive Me.drive API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-me-drive-api/)
- [Microsoft OneDrive Sites.drive API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-sites-drive-api/)
- [Microsoft OneDrive Users.drive API](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-users-drive-api/)

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/microsoft-onedrive/microsoft-onedrive-drives-drive-functions-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/microsoft-onedrive/.