CommondataserviceClient
Attributes
TRIGGER_OPERATIONS
module-attribute
TRIGGER_OPERATIONS: Dict[str, Dict[str, Any]] = {'GetOnDeletedItems_V2': {'operation_id': 'GetOnDeletedItems_V2', 'path': '/{connectionId}/v2/datasets/{dataset}/tables/{table}/ondeleteditems', 'method': 'get', 'required_parameters': ['dataset', 'table'], 'callback_payload_type': 'ItemsList'}, 'GetOnNewItems_V2': {'operation_id': 'GetOnNewItems_V2', 'path': '/{connectionId}/v2/datasets/{dataset}/tables/{table}/onnewitems', 'method': 'get', 'required_parameters': ['dataset', 'table'], 'callback_payload_type': 'ItemsList'}, 'GetOnUpdatedItems_V2': {'operation_id': 'GetOnUpdatedItems_V2', 'path': '/{connectionId}/v2/datasets/{dataset}/tables/{table}/onupdateditems', 'method': 'get', 'required_parameters': ['dataset', 'table'], 'callback_payload_type': 'ItemsList'}}
Classes
DataSetsMetadata
dataclass
DataSetsMetadata(*, tabular: Optional[TabularDataSetsMetadata | Mapping[str, Any]] = None, blob: Optional[BlobDataSetsMetadata | Mapping[str, Any]] = None)
Response for GetDataSetsMetadata
AssociateRecordsPatchItemInput
dataclass
Item
dataclass
Response for Associates one row to another on the provided relationship
ItemsList
dataclass
ItemsList(*, value: Optional[List[Item | Mapping[str, Any]]] = None, next_link: Optional[str] = None)
Response for Retrieves all collection valued relationship items as an expand would
Attributes
value
class-attribute
instance-attribute
List of Items
DataSetsList
dataclass
GetItemResponse
dataclass
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 Get table metadata - Patch
Attributes
name
class-attribute
instance-attribute
Table name
title
class-attribute
instance-attribute
Table title
ObjectEntity
dataclass
Response for Retrieves the metadata for multi select column metadata
TablesList
dataclass
PatchItemInput
dataclass
PatchItemResponse
dataclass
PostItemInput
dataclass
PostItemResponse
dataclass
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)
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
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
SubscriptionRequest
dataclass
SubscriptionResponse
dataclass
SubscriptionResponse(*, id: Optional[str] = None, resource: Optional[str] = None, notification_type: Optional[str] = None, notification_url: Optional[str] = None)
Definition: SubscriptionResponse
Attributes
id
class-attribute
instance-attribute
Id of the subscription
resource
class-attribute
instance-attribute
Resource of the subscription request
UpdateTriggerSubscriptionRequest
dataclass
UpdateTriggerSubscriptionRequest(notification_url: str, *, attribute_filters: Optional[List[str]] = None)
DataSet
dataclass
DataSet(*, name: Optional[str] = None, display_name: Optional[str] = None, query: Optional[List[PassThroughNativeQuery | Mapping[str, Any]]] = None)
Table
dataclass
Table(*, name: Optional[str] = None, display_name: Optional[str] = None, dynamic_properties: Optional[Dict[str, str]] = None)
Definition: Table
Procedure
dataclass
Definition: Procedure
Attributes
name
class-attribute
instance-attribute
Procedure name
PassThroughNativeQuery
dataclass
DisplayCollectionName
dataclass
DisplayCollectionName(*, user_localized_label: Optional[UserLocalizedLabel | Mapping[str, Any]] = None)
Definition: DisplayCollectionName
EntitiesDynamicValuesList
dataclass
EntitiesDynamicValuesListItem
dataclass
EntitiesDynamicValuesListItem(*, metadata_id: Optional[str] = None, entity_set_name: Optional[str] = None, logical_name: Optional[str] = None, display_collection_name: Optional[DisplayCollectionName | Mapping[str, Any]] = None)
Definition: EntitiesDynamicValuesListItem
Attributes
metadata_id
class-attribute
instance-attribute
metadata_id: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'metadataId'})
The metadata id.
entity_set_name
class-attribute
instance-attribute
entity_set_name: Optional[str] = dataclass_field(default=None, kw_only=True, metadata={'wire_name': 'entitySetName'})
The name of the table.
OrganizationsDynamicValuesList
dataclass
OrganizationsDynamicValuesListItem
dataclass
OrganizationsDynamicValuesListItem(*, id: Optional[str] = None, friendly_name: Optional[str] = None, url: Optional[str] = None)
Definition: OrganizationsDynamicValuesListItem
EntityMetadata
dataclass
EntityItemList
dataclass
EntityItemList(*, value: Optional[List[EntityItem | Mapping[str, Any]]] = None, next_link: Optional[str] = None)
Definition: EntityItemList
Attributes
value
class-attribute
instance-attribute
List of Items
EntityItem
dataclass
Definition: EntityItem
CallbackRegistration
dataclass
CallbackRegistration(version: int, url: str, entityname: str, message: int, scope: int, *, name: Optional[str] = None, sdkmessagename: Optional[str] = None, filteringattributes: Optional[str] = None, filterexpression: Optional[str] = None, postponeuntil: Optional[str] = None, runas: Optional[int] = None)
Definition: CallbackRegistration
Attributes
url
instance-attribute
Callback url to the flow engine. Expected as part of the request and provided by Flow.
name
class-attribute
instance-attribute
Callback registration name. Value will be replaced with workflow id
sdkmessagename
class-attribute
instance-attribute
Choose an option or add your own
filteringattributes
class-attribute
instance-attribute
Enter a comma-separated list of column unique names. The flow triggers if any of them are modified
filterexpression
class-attribute
instance-attribute
Enter an OData style filter expression to determine which rows can trigger the flow
postponeuntil
class-attribute
instance-attribute
Enter a time to delay the trigger evaluation, eg. 2020-01-01T10:10:00Z
UserLocalizedLabel
dataclass
WebhookNotificationContent
dataclass
EntityRelationshipsDynamicValuesList
dataclass
AssociateEntityRequest
dataclass
Definition: AssociateEntityRequest
ActionsDynamicValuesList
dataclass
SearchRequestBody
dataclass
SearchRequestBody(search: str, *, searchtype: Optional[str] = None, searchmode: Optional[str] = None, top: Optional[int] = None, filter: Optional[str] = None, entities: Optional[List[str]] = None, orderby: Optional[List[str]] = None, facets: Optional[List[str]] = None, skip: Optional[int] = None, returntotalrecordcount: Optional[bool] = None)
Definition: SearchRequestBody
Attributes
search
instance-attribute
Enter a search term, eg. Contoso. Searches modifiers like boolean operators, wildcards, fuzzy search, proximity search etc. require the search type full
searchtype
class-attribute
instance-attribute
Enter whether simple or full search syntax should be used (default is simple)
searchmode
class-attribute
instance-attribute
Enter whether any or all of the search terms must be matched (default is any)
top
class-attribute
instance-attribute
Enter the number of search results to be listed (default = 50)
filter
class-attribute
instance-attribute
Enter an OData style filter expression to narrow the search
entities
class-attribute
instance-attribute
Enter a comma-separated list of tables to be searched (default is all tables)
orderby
class-attribute
instance-attribute
Enter a comma-separated list of column unique names followed by asc or desc
facets
class-attribute
instance-attribute
Enter a comma-separated list of facet queries to narrow the search
skip
class-attribute
instance-attribute
Enter the number of search results to be skipped
SearchOutput
dataclass
SearchOutput(*, value: Optional[List[Dict[str, Any]]] = None, totalrecordcount: Optional[int] = None, facets: Optional[Dict[str, Any]] = None)
Definition: SearchOutput
Attributes
value
class-attribute
instance-attribute
List of rows
totalrecordcount
class-attribute
instance-attribute
Total count of results (-1 if returntotalrecordcount is set to false)
WhenAnActionIsPerformedSubscriptionRequest
dataclass
WhenAnActionIsPerformedSubscriptionRequest(version: int, url: str, scope: int, entityname: str, sdkmessagename: str, *, name: Optional[str] = None)
Definition: WhenAnActionIsPerformedSubscriptionRequest
Attributes
url
instance-attribute
Callback url to the flow engine. Expected as part of the request and provided by Flow.
name
class-attribute
instance-attribute
Callback registration name. Value will be replaced with workflow id.
WebhookNotificationContentForWhenAnActionIsPerformed
dataclass
CommondataserviceClient
CommondataserviceClient(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 commondataservice connector.
Initialize a CommondataserviceClient.
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:
get_data_sets_metadata
async
get_data_sets_metadata(*, 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
GetDataSetsMetadata
Swagger operation ID: GetDataSetsMetadata.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
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_next_page
async
get_next_page(next_link: 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
Follows nextLink to retrieve next page of data
This operation gets the next page of data.
Swagger operation ID: GetNextPage.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
next_link
|
str
|
OData nextLink. |
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. |
associate_records_patch_item
async
associate_records_patch_item(input: AssociateRecordsPatchItemInput | Mapping[str, Any], dataset: str, table: str, id: str, relationship: 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
Associates one row to another on the provided relationship
Associates one row to another on the provided relationship
Swagger operation ID: AssociateRecordsPatchItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
AssociateRecordsPatchItemInput | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Name of the table. |
required |
id
|
str
|
Id of the table row. |
required |
relationship
|
str
|
Relationship on which to associate. |
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_attachment
async
create_attachment(input: bytes, dataset: str, table: str, id: str, display_name: 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
Creates Note (annotation) for specified table row
Creates Note (annotation) for specified table row.
Swagger operation ID: CreateAttachment_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
bytes
|
The binary request body. |
required |
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Table on which to create Note (annotation). |
required |
id
|
str
|
Id of the table row on which to create a Note (annotation). |
required |
display_name
|
str
|
Filename. |
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. |
delete_attachment
async
delete_attachment(dataset: str, table: str, id: str, attachment_id: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> None
Deletes specified attachment on the Note (annotation)
Deletes specified attachment on the Note (annotation).
Swagger operation ID: DeleteAttachment_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Table on which to delete Note (annotation). |
required |
id
|
str
|
Id of the table row on which to delete a Note (annotation). |
required |
attachment_id
|
str
|
Note (annotation) id. |
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. |
delete_item
async
delete_item(dataset: str, table: str, id: 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 (legacy)
This operation deletes a row from a table collection
Swagger operation ID: DeleteItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
required |
id
|
str
|
Identifier for the row. |
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. |
disassociate_records_post_item
async
disassociate_records_post_item(dataset: str, table: str, id: str, relationship: str, related_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
Disassociates a row from a multi-valued relationship
Disassociates a row from a multi-valued relationship
Swagger operation ID: DisassociateRecordsPostItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Name of the table. |
required |
id
|
str
|
Id of the table row. |
required |
relationship
|
str
|
Relationship on which to associate. |
required |
related_id
|
str
|
The item to disassociate. |
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. |
disassociate_single_value_record_delete_item
async
disassociate_single_value_record_delete_item(dataset: str, table: str, id: str, relationship: 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
Disassociates a row from a single-valued relationship
Disassociates a row from a single-valued relationship
Swagger operation ID: DisassociateSingleValueRecordDeleteItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Name of the table. |
required |
id
|
str
|
Id of the table row. |
required |
relationship
|
str
|
Relationship on which to associate. |
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_attachment_content
async
get_attachment_content(dataset: str, table: str, id: str, attachment_id: str, *, timeout: Optional[float] = None, headers: Optional[Mapping[str, str]] = None, client_request_id: Optional[str] = None, response_hook: Optional[ConnectorResponseHook] = None) -> bytes
Retrieves file content for specified Note (annotation)
Retrieves file content for specified Note (annotation).
Swagger operation ID: GetAttachmentContent_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Table for which to get Note (annotation) content. |
required |
id
|
str
|
Id of the table row for which to get Notes (annotations). |
required |
attachment_id
|
str
|
Note (annotation) id. |
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 |
|---|---|---|
bytes |
bytes
|
The connector operation result. |
Raises:
| Type | Description |
|---|---|
ConnectorException
|
If the connector request fails. |
list_collection_relationships
list_collection_relationships(dataset: str, table: str, id: str, collection_type: str, relationship: str, target: 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]]
Retrieves all collection valued relationship items as an expand would
Retrieves all collection valued relationship items as an expand would
Returns a single-page Azure Core async collection.
Swagger operation ID: GetCollectionRelationships_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Name of the table. |
required |
id
|
str
|
Id of the table row. |
required |
collection_type
|
str
|
many to many or not. |
required |
relationship
|
str
|
Relationship on which to expand. |
required |
target
|
str
|
Target table. |
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_data_sets
list_data_sets(*, 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]]
GetDataSets
Returns a single-page Azure Core async collection.
Swagger operation ID: GetDataSets_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
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_item
async
get_item(dataset: str, table: str, 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
Get row (legacy)
This operation retrieves the specified row for a table
Swagger operation ID: GetItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
required |
id
|
str
|
Identifier for the row. |
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_item_attachments
list_item_attachments(dataset: str, table: str, id: 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]]
Retrieves all Notes (annotations) for the provided table row Id
Retrieves all Notes (annotations) for the provided table row Id.
Returns a single-page Azure Core async collection.
Swagger operation ID: GetItemAttachments_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Table for which to get Notes (annotations). |
required |
id
|
str
|
Id of the table row for which to get Notes (annotations). |
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_items
list_items(dataset: str, table: str, *, apply: Optional[str] = None, filter: Optional[str] = None, orderby: Optional[str] = None, top: Optional[int] = None, expand: 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 rows (legacy)
This operation gets rows for a table
Returns an Azure Core async pager that follows the connector continuation URL.
Swagger operation ID: GetItems_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
required |
apply
|
Optional[str]
|
A sequence of OData aggregation transformations. |
None
|
filter
|
Optional[str]
|
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). |
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
|
expand
|
Optional[str]
|
Related entries to include with requested entries (default = none). |
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_metadata_for_patch_item
async
get_metadata_for_patch_item(dataset: str, table: 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 table metadata - Patch
Gets table metadata for patch operation
Swagger operation ID: GetMetadataForPatchItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
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_metadata_for_post_item
async
get_metadata_for_post_item(dataset: str, table: 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 table metadata - Post
Gets table metadata for post operation
Swagger operation ID: GetMetadataForPostItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
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_multi_select_metadata
async
get_multi_select_metadata(dataset: str, table: str, item: 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
Retrieves the metadata for multi select column metadata
Retrieves the metadata for multi select column metadata.
Swagger operation ID: GetMultiSelectMetadata_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
org name. |
required |
table
|
str
|
table name. |
required |
item
|
str
|
id. |
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_option_set_metadata
async
get_option_set_metadata(dataset: str, table: str, item: str, type_: 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
Retrieves the metadata for choice column metadata
Retrieves the metadata for choice column metadata.
Swagger operation ID: GetOptionSetMetadata_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
org name. |
required |
table
|
str
|
table name. |
required |
item
|
str
|
id. |
required |
type_
|
str
|
type of choice. |
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_table
async
get_table(dataset: str, table: 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 table metadata
Gets table metadata
Swagger operation ID: GetTable_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select atable. |
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(dataset: 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]]
GetTables
Returns a single-page Azure Core async collection.
Swagger operation ID: GetTables_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
dataset
|
str
|
dataset. |
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. |
patch_item
async
patch_item(input: PatchItemInput | Mapping[str, Any], dataset: str, table: str, 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
Update a row (legacy)
This operation updates an existing row for a table
Swagger operation ID: PatchItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
PatchItemInput | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
required |
id
|
str
|
Identifier for the row. |
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. |
post_item
async
post_item(input: PostItemInput | Mapping[str, Any], dataset: str, table: 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
Add a new row (legacy)
This operation adds a new row of a table
Swagger operation ID: PostItem_V2.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
input
|
PostItemInput | Mapping[str, Any]
|
The request body. Mapping keys use serialized Swagger wire names. |
required |
dataset
|
str
|
Select an Environment. |
required |
table
|
str
|
Select a table. |
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. |