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] = None, blob: Optional[BlobDataSetsMetadata] = None)
Response for GetDataSetsMetadata
AssociateRecordsPatchItemInput
dataclass
Item
dataclass
Response for Associates one row to another on the provided relationship
ItemsList
dataclass
Response for Retrieves all collection valued relationship items as an expand would
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] = None, schema: Optional[ObjectEntity] = None, referenced_entities: Optional[ObjectEntity] = None, web_url: Optional[str] = None)
Response for Get table metadata - Patch
Attributes
x_ms_permission
class-attribute
instance-attribute
Table permission
ObjectEntity
dataclass
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
display_name
class-attribute
instance-attribute
Dataset display name
url_encoding
class-attribute
instance-attribute
Dataset url encoding
table_display_name
class-attribute
instance-attribute
Table display name
BlobDataSetsMetadata
dataclass
BlobDataSetsMetadata(source: Optional[str] = None, display_name: Optional[str] = None, url_encoding: Optional[str] = None)
Definition: BlobDataSetsMetadata
Attributes
display_name
class-attribute
instance-attribute
Blob dataset display name
TableCapabilitiesMetadata
dataclass
TableCapabilitiesMetadata(sort_restrictions: Optional[TableSortRestrictionsMetadata] = None, filter_restrictions: Optional[TableFilterRestrictionsMetadata] = None, select_restrictions: Optional[TableSelectRestrictionsMetadata] = 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] = field(default=None, 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
resource
class-attribute
instance-attribute
Resource of the subscription request
notification_type
class-attribute
instance-attribute
Notification Type
UpdateTriggerSubscriptionRequest
dataclass
UpdateTriggerSubscriptionRequest(attribute_filters: Optional[List[str]] = None, notification_url: Optional[str] = None)
DataSet
dataclass
DataSet(name: Optional[str] = None, display_name: Optional[str] = None, query: Optional[List[PassThroughNativeQuery]] = None)
Definition: DataSet
Attributes
name
class-attribute
instance-attribute
Dataset name
display_name
class-attribute
instance-attribute
Dataset display name
Table
dataclass
Table(name: Optional[str] = None, display_name: Optional[str] = None, dynamic_properties: Optional[Dict[str, Any]] = None)
Definition: Table
Attributes
name
class-attribute
instance-attribute
The name of the table. The name is used at runtime.
display_name
class-attribute
instance-attribute
The display name of the table.
Procedure
dataclass
Definition: Procedure
PassThroughNativeQuery
dataclass
DisplayCollectionName
dataclass
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] = None)
Definition: EntitiesDynamicValuesListItem
Attributes
metadata_id
class-attribute
instance-attribute
The metadata id.
entity_set_name
class-attribute
instance-attribute
The name of the table.
logical_name
class-attribute
instance-attribute
The logical name of the table.
OrganizationsDynamicValuesList
dataclass
OrganizationsDynamicValuesListItem
dataclass
OrganizationsDynamicValuesListItem(id: Optional[str] = None, friendly_name: Optional[str] = None, url: Optional[str] = None)
Definition: OrganizationsDynamicValuesListItem
Attributes
id
class-attribute
instance-attribute
The organization id.
friendly_name
class-attribute
instance-attribute
The name of the organization.
EntityMetadata
dataclass
EntityItemList
dataclass
Definition: EntityItemList
EntityItem
dataclass
Definition: EntityItem
CallbackRegistration
dataclass
CallbackRegistration(version: Optional[int] = None, url: Optional[str] = None, name: Optional[str] = None, entityname: Optional[str] = None, message: Optional[int] = None, sdkmessagename: Optional[str] = None, scope: Optional[int] = None, filteringattributes: Optional[str] = None, filterexpression: Optional[str] = None, postponeuntil: Optional[str] = None, runas: Optional[int] = None)
Definition: CallbackRegistration
Attributes
version
class-attribute
instance-attribute
The callback registration table version
url
class-attribute
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
message
class-attribute
instance-attribute
Choose when the flow triggers
sdkmessagename
class-attribute
instance-attribute
Choose an option or add your own
scope
class-attribute
instance-attribute
Choose a scope to limit which rows can trigger the flow
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: Optional[str] = None, 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
class-attribute
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
totalrecordcount
class-attribute
instance-attribute
Total count of results (-1 if returntotalrecordcount is set to false)
WhenAnActionIsPerformedSubscriptionRequest
dataclass
WhenAnActionIsPerformedSubscriptionRequest(version: Optional[int] = None, url: Optional[str] = None, name: Optional[str] = None, scope: Optional[int] = None, entityname: Optional[str] = None, sdkmessagename: Optional[str] = None)
Definition: WhenAnActionIsPerformedSubscriptionRequest
Attributes
version
class-attribute
instance-attribute
The callback registration table version.
url
class-attribute
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.
scope
class-attribute
instance-attribute
Choose a scope to limit which rows can trigger the flow.
entityname
class-attribute
instance-attribute
Choose a table to filter actions.
WebhookNotificationContentForWhenAnActionIsPerformed
dataclass
CommondataserviceClient
CommondataserviceClient(connection_runtime_url: str, token_provider: Optional[TokenProvider] = None, options: Optional[ConnectorClientOptions] = None)
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 |
token_provider
|
Optional[TokenProvider]
|
Optional token provider. Defaults to ManagedIdentityTokenProvider. |
None
|
options
|
Optional[ConnectorClientOptions]
|
Optional connector client options. |
None
|
Methods:
get_data_sets_metadata_async
async
GetDataSetsMetadata
get_next_page_async
async
Follows nextLink to retrieve next page of data
This operation gets the next page of data.
associate_records_patch_item_async
async
associate_records_patch_item_async(input: AssociateRecordsPatchItemInput, dataset: str, table: str, id: str, relationship: str) -> dict[str, Any] | None
Associates one row to another on the provided relationship
Associates one row to another on the provided relationship
create_attachment_async
async
create_attachment_async(input: bytes, dataset: str, table: str, id: str, display_name: str) -> dict[str, Any] | None
Creates Note (annotation) for specified table row
Creates Note (annotation) for specified table row.
delete_attachment_async
async
Deletes specified attachment on the Note (annotation)
Deletes specified attachment on the Note (annotation).
delete_item_async
async
Delete a row (legacy)
This operation deletes a row from a table collection
disassociate_records_post_item_async
async
disassociate_records_post_item_async(dataset: str, table: str, id: str, relationship: str, related_id: str) -> dict[str, Any] | None
Disassociates a row from a multi-valued relationship
Disassociates a row from a multi-valued relationship
disassociate_single_value_record_delete_item_async
async
disassociate_single_value_record_delete_item_async(dataset: str, table: str, id: str, relationship: str) -> dict[str, Any] | None
Disassociates a row from a single-valued relationship
Disassociates a row from a single-valued relationship
get_attachment_content_async
async
Retrieves file content for specified Note (annotation)
Retrieves file content for specified Note (annotation).
get_collection_relationships_async
async
get_collection_relationships_async(dataset: str, table: str, id: str, collection_type: str, relationship: str, target: str) -> dict[str, Any] | None
Retrieves all collection valued relationship items as an expand would
Retrieves all collection valued relationship items as an expand would
get_item_async
async
Get row (legacy)
This operation retrieves the specified row for a table
get_item_attachments_async
async
Retrieves all Notes (annotations) for the provided table row Id
Retrieves all Notes (annotations) for the provided table row Id.
get_items_async
async
get_items_async(dataset: str, table: str, apply: Optional[str] = None, filter: Optional[str] = None, orderby: Optional[str] = None, top: Optional[int] = None, expand: Optional[str] = None) -> AsyncIterator[dict[str, Any]]
List rows (legacy)
This operation gets rows for a table
Yields items from every response page and automatically follows the connector continuation URL.
get_metadata_for_patch_item_async
async
Get table metadata - Patch
Gets table metadata for patch operation
get_metadata_for_post_item_async
async
Get table metadata - Post
Gets table metadata for post operation
get_multi_select_metadata_async
async
Retrieves the metadata for multi select column metadata
Retrieves the metadata for multi select column metadata.
get_option_set_metadata_async
async
get_option_set_metadata_async(dataset: str, table: str, item: str, type_: str) -> dict[str, Any] | None
Retrieves the metadata for choice column metadata
Retrieves the metadata for choice column metadata.
get_table_async
async
Get table metadata
Gets table metadata
patch_item_async
async
Update a row (legacy)
This operation updates an existing row for a table