Microsoft Graph Functions is the Excel capability in Microsoft Graph that lets developers invoke hundreds of Excel worksheet functions through REST, running calculations directly on workbooks stored in OneDrive or SharePoint without opening the Excel app.
openapi: 3.1.0
info:
title: Microsoft Graph Functions
description: Needs a description.
paths:
/applications/{application-id}/synchronization/jobs/{synchronizationJob-id}/schema/functions():
description: Provides operations to call the functions method.
get:
tags:
- Applications.synchronization
summary: Microsoft Graph Invoke function functions
description: >-
List all the functions currently supported in the
attributeMappingSource.
externalDocs:
description: Find more info here
url: >-
https://learn.microsoft.com/graph/api/synchronization-synchronizationschema-functions?view=graph-rest-1.0
operationId: >-
applications.application.synchronization.jobs.synchronizationJob.schema.functions
parameters:
- $ref: '#/components/parameters/top'
- $ref: '#/components/parameters/skip'
- $ref: '#/components/parameters/search'
- $ref: '#/components/parameters/filter'
- $ref: '#/components/parameters/count'
- name: $select
in: query
description: Select properties to be returned
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
- name: $orderby
in: query
description: Order items by property values
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
- name: $expand
in: query
description: Expand related entities
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
responses:
2XX:
description: Success
content:
application/json:
schema:
title: Collection of attributeMappingFunctionSchema
type: object
allOf:
- $ref: '#/components/schemas/BaseCollectionPaginationCountResponse'
- type: object
properties:
value:
type: array
items:
$ref: >-
#/components/schemas/microsoft.graph.attributeMappingFunctionSchema
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: function
x-ms-pageable:
nextLinkName: '@odata.nextLink'
operationName: listMore
parameters:
- name: application-id
in: path
description: The unique identifier of application
required: true
schema:
type: string
x-ms-docs-key-type: application
- name: synchronizationJob-id
in: path
description: The unique identifier of synchronizationJob
required: true
schema:
type: string
x-ms-docs-key-type: synchronizationJob
x-ms-docs-grouped-path:
- >-
/applications/{application-id}/synchronization/templates/{synchronizationTemplate-id}/schema/functions()
/applications/{application-id}/synchronization/templates/{synchronizationTemplate-id}/schema/functions():
description: Provides operations to call the functions method.
get:
tags:
- Applications.synchronization
summary: Microsoft Graph Invoke function functions
description: >-
List all the functions currently supported in the
attributeMappingSource.
externalDocs:
description: Find more info here
url: >-
https://learn.microsoft.com/graph/api/synchronization-synchronizationschema-functions?view=graph-rest-1.0
operationId: >-
applications.application.synchronization.templates.synchronizationTemplate.schema.functions
parameters:
- $ref: '#/components/parameters/top'
- $ref: '#/components/parameters/skip'
- $ref: '#/components/parameters/search'
- $ref: '#/components/parameters/filter'
- $ref: '#/components/parameters/count'
- name: $select
in: query
description: Select properties to be returned
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
- name: $orderby
in: query
description: Order items by property values
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
- name: $expand
in: query
description: Expand related entities
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
responses:
2XX:
description: Success
content:
application/json:
schema:
title: Collection of attributeMappingFunctionSchema
type: object
allOf:
- $ref: '#/components/schemas/BaseCollectionPaginationCountResponse'
- type: object
properties:
value:
type: array
items:
$ref: >-
#/components/schemas/microsoft.graph.attributeMappingFunctionSchema
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: function
x-ms-pageable:
nextLinkName: '@odata.nextLink'
operationName: listMore
parameters:
- name: application-id
in: path
description: The unique identifier of application
required: true
schema:
type: string
x-ms-docs-key-type: application
- name: synchronizationTemplate-id
in: path
description: The unique identifier of synchronizationTemplate
required: true
schema:
type: string
x-ms-docs-key-type: synchronizationTemplate
x-ms-docs-grouped-path:
- >-
/applications/{application-id}/synchronization/jobs/{synchronizationJob-id}/schema/functions()
/drives/{drive-id}/items/{driveItem-id}/workbook/functions:
description: >-
Provides operations to manage the functions property of the
microsoft.graph.workbook entity.
get:
tags:
- drives.driveItem
summary: Microsoft Graph Get functions from drives
operationId: drives.items.workbook.GetFunctions
parameters:
- name: $select
in: query
description: Select properties to be returned
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
- name: $expand
in: query
description: Expand related entities
style: form
explode: false
schema:
uniqueItems: true
type: array
items:
type: string
responses:
2XX:
description: Retrieved navigation property
content:
application/json:
schema:
$ref: '#/components/schemas/microsoft.graph.workbookFunctions'
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: operation
patch:
tags:
- drives.driveItem
summary: Microsoft Graph Update the navigation property functions in drives
operationId: drives.items.workbook.UpdateFunctions
requestBody:
description: New navigation property values
content:
application/json:
schema:
$ref: '#/components/schemas/microsoft.graph.workbookFunctions'
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
$ref: '#/components/schemas/microsoft.graph.workbookFunctions'
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: operation
delete:
tags:
- drives.driveItem
summary: Microsoft Graph Delete navigation property functions for drives
operationId: drives.items.workbook.DeleteFunctions
parameters:
- name: If-Match
in: header
description: ETag
schema:
type: string
responses:
'204':
description: Success
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: operation
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/abs:
description: Provides operations to call the abs method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action abs
operationId: drives.drive.items.driveItem.workbook.functions.abs
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/accrInt:
description: Provides operations to call the accrInt method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action accrInt
operationId: drives.drive.items.driveItem.workbook.functions.accrInt
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
issue: {}
firstInterest: {}
settlement: {}
rate: {}
par: {}
frequency: {}
basis: {}
calcMethod: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/accrIntM:
description: Provides operations to call the accrIntM method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action accrIntM
operationId: drives.drive.items.driveItem.workbook.functions.accrIntM
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
issue: {}
settlement: {}
rate: {}
par: {}
basis: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/acos:
description: Provides operations to call the acos method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action acos
operationId: drives.drive.items.driveItem.workbook.functions.acos
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/acosh:
description: Provides operations to call the acosh method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action acosh
operationId: drives.drive.items.driveItem.workbook.functions.acosh
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/acot:
description: Provides operations to call the acot method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action acot
operationId: drives.drive.items.driveItem.workbook.functions.acot
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/acoth:
description: Provides operations to call the acoth method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action acoth
operationId: drives.drive.items.driveItem.workbook.functions.acoth
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/amorDegrc:
description: Provides operations to call the amorDegrc method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action amorDegrc
operationId: drives.drive.items.driveItem.workbook.functions.amorDegrc
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
cost: {}
datePurchased: {}
firstPeriod: {}
salvage: {}
period: {}
rate: {}
basis: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/amorLinc:
description: Provides operations to call the amorLinc method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action amorLinc
operationId: drives.drive.items.driveItem.workbook.functions.amorLinc
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
cost: {}
datePurchased: {}
firstPeriod: {}
salvage: {}
period: {}
rate: {}
basis: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/and:
description: Provides operations to call the and method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action and
operationId: drives.drive.items.driveItem.workbook.functions.and
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
values: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/arabic:
description: Provides operations to call the arabic method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action arabic
operationId: drives.drive.items.driveItem.workbook.functions.arabic
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
text: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/areas:
description: Provides operations to call the areas method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action areas
operationId: drives.drive.items.driveItem.workbook.functions.areas
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
reference: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/asc:
description: Provides operations to call the asc method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action asc
operationId: drives.drive.items.driveItem.workbook.functions.asc
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
text: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/asin:
description: Provides operations to call the asin method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action asin
operationId: drives.drive.items.driveItem.workbook.functions.asin
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/asinh:
description: Provides operations to call the asinh method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action asinh
operationId: drives.drive.items.driveItem.workbook.functions.asinh
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description: The unique identifier of drive
required: true
schema:
type: string
x-ms-docs-key-type: drive
- name: driveItem-id
in: path
description: The unique identifier of driveItem
required: true
schema:
type: string
x-ms-docs-key-type: driveItem
/drives/{drive-id}/items/{driveItem-id}/workbook/functions/atan:
description: Provides operations to call the atan method.
post:
tags:
- drives.driveItem
summary: Microsoft Graph Invoke action atan
operationId: drives.drive.items.driveItem.workbook.functions.atan
requestBody:
description: Action parameters
content:
application/json:
schema:
type: object
properties:
number: {}
required: true
responses:
2XX:
description: Success
content:
application/json:
schema:
anyOf:
- $ref: >-
#/components/schemas/microsoft.graph.workbookFunctionResult
- type: object
nullable: true
4XX:
$ref: '#/components/responses/error'
5XX:
$ref: '#/components/responses/error'
x-ms-docs-operation-type: action
parameters:
- name: drive-id
in: path
description:
# --- truncated at 32 KB (548 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/microsoft-graph/refs/heads/main/openapi/functions-openapi-original.yml