ExcelonlinebusinessClient
Classes
TableMetadata
dataclass
TableMetadata(*, name: Optional[str] = None, title: Optional[str] = None, x_ms_permission: Optional[str] = None, x_ms_capabilities: Optional[TableCapabilitiesMetadata | Mapping[str, Any]] = None, schema: Optional[ObjectEntity | Mapping[str, Any]] = None, referenced_entities: Optional[ObjectEntity | Mapping[str, Any]] = None, web_url: Optional[str] = None)
Response for Create table
Attributes
name
class-attribute
instance-attribute
Table name
title
class-attribute
instance-attribute
Table title
ItemsList
dataclass
ItemsList(*, value: Optional[List[Item | Mapping[str, Any]]] = None, sensitivity_label_info: Optional[List[SensitivityLabelMetadata | Mapping[str, Any]]] = None, next_link: Optional[str] = None)
Response for List rows present in a table
Attributes
value
class-attribute
instance-attribute
List of Items
CommentsList
dataclass
Comment
dataclass
Comment(*, id: Optional[str] = None, content: Optional[str] = None, content_type: Optional[str] = None)
Response for Get a comment present in a workbook
Attributes
id
class-attribute
instance-attribute
The unique identifier for the comment.
content
class-attribute
instance-attribute
The content of the comment.
GetItemResponse
dataclass
GetItemResponse(*, dynamic_properties: Optional[Dict[str, ObjectEntity | Mapping[str, Any]]] = None, sensitivity_label_info: Optional[List[SensitivityLabelMetadata | Mapping[str, Any]]] = None)
Response for Get a row
Item
dataclass
Response for Update a row
GetAllWorksheetsResponse
dataclass
GetAllWorksheetsResponse(*, value: Optional[List[WorksheetMetadata | Mapping[str, Any]]] = None, sensitivity_label_info: Optional[List[SensitivityLabelMetadata | Mapping[str, Any]]] = None)
Response for Get worksheets
CreateWorksheetInput
dataclass
WorksheetMetadata
dataclass
WorksheetMetadata(*, id: Optional[str] = None, name: Optional[str] = None, position: Optional[int] = None, visibility: Optional[str] = None)
Response for Create worksheet
Attributes
id
class-attribute
instance-attribute
Worksheet Id.
name
class-attribute
instance-attribute
Worksheet name.
position
class-attribute
instance-attribute
Worksheet position.
GetTablesResponse
dataclass
GetTablesResponse(*, value: Optional[List[Dict[str, Any]]] = None, sensitivity_label_info: Optional[List[SensitivityLabelMetadata | Mapping[str, Any]]] = None)
Response for Get tables
RunScriptProdInput
dataclass
RunScriptProdResponse
dataclass
GetSourcesResponse
dataclass
Response for Get sources
GetDrivesResponse
dataclass
Response for Get drives
GetColumnsResponse
dataclass
Response for Get table columns
GetSingleScriptResponse
dataclass
Response for Gets one script
CreateFileMetadata
dataclass
DataSetsMetadata
dataclass
DataSetsMetadata(*, tabular: Optional[TabularDataSetsMetadata | Mapping[str, Any]] = None, blob: Optional[BlobDataSetsMetadata | Mapping[str, Any]] = None)
Definition: DataSetsMetadata
TabularDataSetsMetadata
dataclass
TabularDataSetsMetadata(*, source: Optional[str] = None, display_name: Optional[str] = None, url_encoding: Optional[str] = None, table_display_name: Optional[str] = None, table_plural_name: Optional[str] = None)
Definition: TabularDataSetsMetadata
Attributes
source
class-attribute
instance-attribute
Dataset source
display_name
class-attribute
instance-attribute
display_name: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'displayName'})
Dataset display name
url_encoding
class-attribute
instance-attribute
url_encoding: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'urlEncoding'})
Dataset url encoding
BlobDataSetsMetadata
dataclass
BlobDataSetsMetadata(*, source: Optional[str] = None, display_name: Optional[str] = None, url_encoding: Optional[str] = None)
TablesList
dataclass
Table
dataclass
Table(*, name: Optional[str] = None, display_name: Optional[str] = None, dynamic_properties: Optional[Dict[str, ObjectEntity | Mapping[str, Any]]] = None)
Definition: Table
TableToCreate
dataclass
Definition: TableToCreate
TableCapabilitiesMetadata
dataclass
TableCapabilitiesMetadata(*, sort_restrictions: Optional[TableSortRestrictionsMetadata | Mapping[str, Any]] = None, filter_restrictions: Optional[TableFilterRestrictionsMetadata | Mapping[str, Any]] = None, select_restrictions: Optional[TableSelectRestrictionsMetadata | Mapping[str, Any]] = None, is_only_server_pagable: Optional[bool] = None, filter_function_support: Optional[List[str]] = None, server_paging_options: Optional[List[str]] = None)
Definition: TableCapabilitiesMetadata
Attributes
is_only_server_pagable
class-attribute
instance-attribute
is_only_server_pagable: Optional[bool] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'isOnlyServerPagable'})
Server paging restrictions
ObjectEntity
dataclass
TableSortRestrictionsMetadata
dataclass
TableSortRestrictionsMetadata(*, sortable: Optional[bool] = None, unsortable_properties: Optional[List[str]] = None, ascending_only_properties: Optional[List[str]] = None)
Definition: TableSortRestrictionsMetadata
Attributes
sortable
class-attribute
instance-attribute
Indicates whether this table has sortable columns
TableFilterRestrictionsMetadata
dataclass
TableFilterRestrictionsMetadata(*, filterable: Optional[bool] = None, non_filterable_properties: Optional[List[str]] = None, required_properties: Optional[List[str]] = None)
Definition: TableFilterRestrictionsMetadata
Attributes
filterable
class-attribute
instance-attribute
Indicates whether this table has filterable columns
TableSelectRestrictionsMetadata
dataclass
CommentDetails
dataclass
Definition: CommentDetails
Attributes
content
class-attribute
instance-attribute
The content of the comment.
TabularItemsList
dataclass
TabularItem
dataclass
Definition: TabularItem
ScriptParameters
dataclass
ScriptReturnValues
dataclass
RawAndFormattedTableSchema
dataclass
RawAndFormattedTableSchema(*, dynamic_properties: Optional[Dict[str, ObjectEntity | Mapping[str, Any]]] = None)
Definition: RawAndFormattedTableSchema
BlobMetadata
dataclass
BlobMetadata(*, id: Optional[str] = None, name: Optional[str] = None, display_name: Optional[str] = None, path: Optional[str] = None, media_type: Optional[str] = None, is_folder: Optional[bool] = None)
Definition: BlobMetadata
Attributes
id
class-attribute
instance-attribute
The unique id of the file or folder.
name
class-attribute
instance-attribute
The name of the file or folder.
display_name
class-attribute
instance-attribute
display_name: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'DisplayName'})
The display name of the file or folder.
path
class-attribute
instance-attribute
The path of the file or folder.
SensitivityLabelMetadata
dataclass
SensitivityLabelMetadata(*, sensitivity_label_id: Optional[str] = None, name: Optional[str] = None, display_name: Optional[str] = None, tooltip: Optional[str] = None, priority: Optional[int] = None, color: Optional[str] = None, is_encrypted: Optional[bool] = None, is_enabled: Optional[bool] = None, is_parent: Optional[bool] = None, parent_sensitivity_label_id: Optional[str] = None)
Definition: SensitivityLabelMetadata
Attributes
sensitivity_label_id
class-attribute
instance-attribute
sensitivity_label_id: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'sensitivityLabelId'})
SensitivityLabel Id.
name
class-attribute
instance-attribute
SensitivityLabel name.
display_name
class-attribute
instance-attribute
display_name: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'displayName'})
SensitivityLabel displayName info
tooltip
class-attribute
instance-attribute
SensitivityLabel details on tooltip.
priority
class-attribute
instance-attribute
SensitivityLabel priority.
color
class-attribute
instance-attribute
SensitivityLabel color.
is_encrypted
class-attribute
instance-attribute
is_encrypted: Optional[bool] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'isEncrypted'})
is SensitivityLabel Encrypted.
is_enabled
class-attribute
instance-attribute
is_enabled: Optional[bool] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'isEnabled'})
Whether SensitivityLabel is Enabled.
WorkbookRange
dataclass
WorkbookRange(*, address: Optional[str] = None, address_local: Optional[str] = None, cell_count: Optional[int] = None, column_count: Optional[int] = None, row_count: Optional[int] = None, column_index: Optional[int] = None, row_index: Optional[int] = None, values: Optional[List[List[Any]]] = None, text: Optional[List[List[str]]] = None, formulas: Optional[List[List[str]]] = None, number_format: Optional[List[List[str]]] = None, value_types: Optional[List[List[str]]] = None)
Definition: WorkbookRange
Attributes
address
class-attribute
instance-attribute
Range address including the sheet name, e.g. Sheet1!A1:D10.
values
class-attribute
instance-attribute
2-D array of cell values.
text
class-attribute
instance-attribute
2-D array of display text.
formulas
class-attribute
instance-attribute
2-D array of formulas.
ExcelonlinebusinessClient
ExcelonlinebusinessClient(connection_runtime_url: str, credential: AsyncTokenCredential | AzureKeyCredential, *, max_retry_attempts: int = 3, timeout: float = 30.0, use_exponential_backoff: bool = True, initial_retry_delay_seconds: float = 0.5, maximum_retry_delay_seconds: float = 120.0, retry_jitter_factor: float = 0.1, retry_unsafe_http_methods: bool = False, transport: Optional[AsyncHttpTransport] = None, **kwargs: Any)
Bases: ConnectorClientBase
Typed client for excelonlinebusiness connector.
Initialize a ExcelonlinebusinessClient.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
connection_runtime_url
|
str
|
The connection runtime URL from Azure Portal. |
required |
credential
|
AsyncTokenCredential | AzureKeyCredential
|
Caller-owned Azure Core credential. |
required |
max_retry_attempts
|
int
|
The maximum number of request attempts. |
3
|
timeout
|
float
|
The network timeout in seconds for each request. The value configures Azure Core retry and transport deadlines. Nonpositive values disable SDK and transport deadlines. |
30.0
|
use_exponential_backoff
|
bool
|
Whether retries use exponential backoff. |
True
|
initial_retry_delay_seconds
|
float
|
The initial retry delay in seconds. |
0.5
|
maximum_retry_delay_seconds
|
float
|
The maximum retry delay in seconds. |
120.0
|
retry_jitter_factor
|
float
|
The jitter fraction applied to retry delays. |
0.1
|
retry_unsafe_http_methods
|
bool
|
Whether unsafe HTTP methods may be retried. |
False
|
transport
|
Optional[AsyncHttpTransport]
|
Optional Azure Core async HTTP transport closed by the client through its asynchronous lifecycle. |
None
|
**kwargs
|
Any
|
Optional Azure Core pipeline policy settings. |
{}
|
Methods:
create_table
async
create_table(input: TableToCreate | Mapping[str, Any], drive: str, file: str, source: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Create table
Create a new table in the Excel workbook.
Swagger operation ID: CreateTable.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
TableToCreate | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
create_id_column
async
create_id_column(drive: str, file: str, table: str, source: str, *, id_column: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> None
Add a key column to a table
Add a key column to an Excel table. The new column will be appended to the right.
Swagger operation ID: CreateIdColumn.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
id_column
|
Optional[str]
|
Provide the key column name. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Name | Type | Description |
|---|---|---|
None |
None
|
The operation completes without a response body. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_items
list_items(drive: str, file: str, table: str, source: str, *, filter: Optional[str] = None, orderby: Optional[str] = None, top: Optional[int] = None, skip: Optional[int] = None, select: Optional[str] = None, date_time_format: Optional[str] = None, extract_sensitivity_label: Optional[bool] = None, fetch_sensitivity_label_metadata: Optional[bool] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
List rows present in a table
List rows present in a table.
Returns an Azure Core async pager that follows the connector continuation URL.
Swagger operation ID: GetItems.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
filter
|
Optional[str]
|
An ODATA filter query to restrict the entries returned. |
None
|
orderby
|
Optional[str]
|
An ODATA orderBy query for specifying the order of entries. |
None
|
top
|
Optional[int]
|
Total number of entries to retrieve (default = all). |
None
|
skip
|
Optional[int]
|
The number of entries to skip (default = 0). |
None
|
select
|
Optional[str]
|
Comma-separated list of columns to retrieve (first 500 by default). |
None
|
date_time_format
|
Optional[str]
|
DateTime Format. |
None
|
extract_sensitivity_label
|
Optional[bool]
|
A boolean whether to extract sensitivity label Id for associated artefact. |
None
|
fetch_sensitivity_label_metadata
|
Optional[bool]
|
A boolean whether to fetch sensitivity label Metadata for associated LabelId. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_comments
list_comments(drive: str, file: str, *, source: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
List all comments present in a workbook
List all comments present in a workbook.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetComments.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Ask user to select a document library from the drop-down. |
required |
file
|
str
|
Ask user to select an Excel file through File Browse. |
required |
source
|
Optional[str]
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
get_comment
async
get_comment(drive: str, file: str, commentid: str, *, source: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Get a comment present in a workbook
Get a comment present in a workbook.
Swagger operation ID: GetComment.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
commentid
|
str
|
Provide a comment Id . |
required |
source
|
Optional[str]
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
reply_comment
async
reply_comment(input: CommentDetails | Mapping[str, Any], drive: str, file: str, commentid: str, *, source: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Reply to a comment present in a workbook
Reply to a comment present in a workbook.
Swagger operation ID: ReplyComment.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
CommentDetails | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
drive
|
str
|
Ask user to select a document library from the drop-down. |
required |
file
|
str
|
Ask user to select an Excel file through File Browse. |
required |
commentid
|
str
|
Provide a comment Id . |
required |
source
|
Optional[str]
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
get_item
async
get_item(drive: str, file: str, table: str, id: str, source: str, id_column: str, *, date_time_format: Optional[str] = None, extract_sensitivity_label: Optional[bool] = None, fetch_sensitivity_label_metadata: Optional[bool] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Get a row
Get a row using a key column.
Swagger operation ID: GetItem.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
id
|
str
|
Enter the key value. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
id_column
|
str
|
Select a column from the drop-down. |
required |
date_time_format
|
Optional[str]
|
DateTime Format. |
None
|
extract_sensitivity_label
|
Optional[bool]
|
A boolean whether to extract sensitivity label Id for associated artefact. |
None
|
fetch_sensitivity_label_metadata
|
Optional[bool]
|
A boolean whether to fetch sensitivity label Metadata for associated LabelId. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
delete_item
async
delete_item(drive: str, file: str, table: str, id: str, source: str, id_column: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> None
Delete a row
Delete a row using a key column.
Swagger operation ID: DeleteItem.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
id
|
str
|
Enter the key value. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
id_column
|
str
|
Select a column from the drop-down. |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Name | Type | Description |
|---|---|---|
None |
None
|
The operation completes without a response body. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
patch_item
async
patch_item(input: Item | Mapping[str, Any], drive: str, file: str, table: str, id: str, source: str, id_column: str, *, date_time_format: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Update a row
Update a row using a key column. The input value will overwrite the specified cells and columns left blank will not be updated. In order to append (instead of overwrite) a value, use the "Get a row" action to retrieve the content first.
Swagger operation ID: PatchItem.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
Item | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
id
|
str
|
Enter the key value. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
id_column
|
str
|
Select a column from the drop-down. |
required |
date_time_format
|
Optional[str]
|
DateTime Format. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_all_worksheets
list_all_worksheets(drive: str, file: str, source: str, *, extract_sensitivity_label: Optional[bool] = None, fetch_sensitivity_label_metadata: Optional[bool] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
Get worksheets
Get a list of worksheets in the Excel workbook.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetAllWorksheets.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
extract_sensitivity_label
|
Optional[bool]
|
A boolean whether to extract sensitivity label Id for associated artefact. |
None
|
fetch_sensitivity_label_metadata
|
Optional[bool]
|
A boolean whether to fetch sensitivity label Metadata for associated LabelId. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
create_worksheet
async
create_worksheet(input: CreateWorksheetInput | Mapping[str, Any], drive: str, file: str, source: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Create worksheet
Create a new worksheet in the Excel workbook.
Swagger operation ID: CreateWorksheet.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
CreateWorksheetInput | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_tables
list_tables(drive: str, file: str, source: str, *, extract_sensitivity_label: Optional[bool] = None, fetch_sensitivity_label_metadata: Optional[bool] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
Get tables
Get a list of tables in the Excel workbook.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetTables.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
extract_sensitivity_label
|
Optional[bool]
|
A boolean whether to extract sensitivity label Id for associated artefact. |
None
|
fetch_sensitivity_label_metadata
|
Optional[bool]
|
A boolean whether to fetch sensitivity label Metadata for associated LabelId. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
add_row
async
add_row(input: Item | Mapping[str, Any], drive: str, file: str, table: str, source: str, *, date_time_format: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Add a row into a table
Add a new row into the Excel table.
Swagger operation ID: AddRowV2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
Item | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
date_time_format
|
Optional[str]
|
DateTime Format. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
run_script_prod
async
run_script_prod(input: RunScriptProdInput | Mapping[str, Any], drive: str, file: str, script_drive: str, script_id: str, source: str, script_source: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Run script from SharePoint library
Runs an Office Script against an Excel workbook. Use this action when the script is saved outside of the default location.
Swagger operation ID: RunScriptProdV2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
RunScriptProdInput | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel workbook through File Browse. |
required |
script_drive
|
str
|
Select the SharePoint library of your Office Script file (.osts) from the drop-down. |
required |
script_id
|
str
|
Select an Office Script file (.osts) in a SharePoint library from the drop-down. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
script_source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (the colons are required). |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_sources
list_sources(*, top: Optional[str] = None, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
Get sources
Get a list of sources.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetSources.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
top
|
Optional[str]
|
Top. |
None
|
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_drives
list_drives(source: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
Get drives
Get a list of drives.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetDrives.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_columns
list_columns(drive: str, file: str, table: str, source: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> AsyncItemPaged[dict[str, Any]]
Get table columns
Get table columns.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetColumns.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
AsyncItemPaged[dict[str, Any]]
|
AsyncItemPaged[dict[str, Any]]: An Azure Core pager over connector
results. Consume it with |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
get_table
async
get_table(drive: str, file: str, table: str, source: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Get metadata of a table
Get metadata of a table.
Swagger operation ID: GetTable.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
drive
|
str
|
Select a document library from the drop-down. |
required |
file
|
str
|
Select an Excel file through File Browse. |
required |
table
|
str
|
Select a table from the drop-down. |
required |
source
|
str
|
Select from the drop-down or specify one of the following: - "me" - "SharePoint Site URL" - "users/someone's UPN" - "groups/group Id" - "sites/SharePoint Site URL:/teams/team name:" (colons are required). |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
get_single_script
async
get_single_script(script_source: str, script_drive: str, script_id: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> dict[str, Any] | None
Gets one script
Gets one of the scripts.
Swagger operation ID: GetSingleScriptV2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
script_source
|
str
|
script source. |
required |
script_drive
|
str
|
script drive. |
required |
script_id
|
str
|
Script chosen to use. |
required |
timeout
|
Optional[float]
|
The request timeout in seconds. |
None
|
headers
|
Optional[Mapping[str, str]]
|
Additional HTTP request headers. |
None
|
client_request_id
|
Optional[str]
|
A caller-provided request identifier. |
None
|
response_hook
|
Optional[ConnectorResponseHook]
|
A callback invoked with the connector response. |
None
|
Returns:
| Type | Description |
|---|---|
dict[str, Any] | None
|
dict[str, Any] | None: The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |