Excel Office365connector v1 | OneTeg Documentation

Version 1

Connector Overview: This page documents all 13 actions for the Excel Office365connector v1.

General (11)

POST Copy File

/drives/{driveId}/items/{itemId}/copy

Parameters

Parameter Name	Description
`Content Type`	N/A
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Driveid`	N/A
`Itemid`	N/A
`Response Type`	N/A

Options (1)

Option Name	Description
`Name`	N/A

GET Get File Details

/me/drive/root:/{fileName}

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Filename`	N/A
`Response Type`	N/A

GET Get Folders

/me/drive/root/children

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`$filter`	N/A
`Response Type`	N/A

GET Get Item By Id

/drives/{driveId}/items/{itemId}

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Driveid`	N/A
`Itemid`	N/A
`Response Type`	N/A

GET Get Used Range

/me/drive/root:/{work_book_name}:/workbook/worksheets/{sheetId}/usedRange

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Work Book Name`	N/A
`Sheetid`	N/A
`Response Type`	N/A

GET Get Worksheet Id

/me/drive/items/{item_id}/workbook/worksheets/{sheet_name}

Retrieve details of a specific worksheet in an Excel workbook stored in OneDrive.

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Item Id`	The unique identifier of the workbook item.
`Sheet Name`	The name or ID of the worksheet.
`Response Type`	N/A

GET Get a folder

/drives/{DriveID}/root:/{path}

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Driveid`	N/A
`Path`	N/A
`Response Type`	N/A

GET Get drive Id

/sites/{siteId}/drives

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Siteid`	N/A
`Response Type`	N/A

GET List Worksheets In a Workbook

/me/drive/root:/{work_book_name}:/workbook/worksheets

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Work Book Name`	N/A
`Response Type`	N/A

PATCH Patch Worksheet

/me/drive/root:/{work_book_name}:/workbook/worksheets/{sheetId}/{range}

Parameters

Parameter Name	Description
`Content Type`	N/A
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Work Book Name`	N/A
`Sheetid`	N/A
`Range`	N/A
`Workbook-session-id`	N/A
`Prefer`	N/A
`Response Type`	N/A

Options (1)

Option Name	Description
`Values`	N/A

GET Search Files

/me/drive/root/{query}

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Query`	N/A
`Response Type`	N/A

Session

POST Close Session

/me/drive/items/{item_id}/workbook/closeSession

Close Session

Parameters

Parameter Name	Description
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Item Id-test`	N/A
`Workbook-session-id`	N/A
`Response Type`	N/A

Table

POST Add Table Rows

/me/drive/root:/{work_book_name}:/workbook/tables/{id}/rows/add

Add Table Rows

Parameters

Parameter Name	Description
`Content Type`	N/A
`headers`	N/A
`headers.Header Key`	N/A
`headers.Header Value`	N/A
`Work Book Name`	N/A
`Id`	N/A
`Workbook-session-id`	N/A
`Prefer`	N/A
`Response Type`	N/A

Options (1)

Option Name	Description
`Values`	N/A