다음을 통해 공유

Azure Table Storage

  • Reference

Connect to your Azure Table Storage to create, query and update, table entries and tables.

This article describes the operations for the Azure Table Storage built-in connector, which is available only for Standard workflows in single-tenant Azure Logic Apps. If you're looking for the Azure Table Storage managed connector operations instead, see Azure Table Storage managed connector reference.

Built-in connector settings

In a Standard logic app resource, the Azure Table Storage built-in connector includes settings that control various thresholds for performance, timeout, execution time, and so on. For example, you can change the timeout value for table storage requests from the Azure Logic Apps runtime. For more information, review Reference for host settings - host.json - Table and queue storage.

Authentication

Connection String

The connection string for Azure Storage.

Parameters

Name Description Type Required Allowed Values
Connection String The connection string for Azure Storage. securestring True

Active Directory OAuth

Active Directory OAuth

Parameters

Name Description Type Required Allowed Values
Table Storage endpoint Table Storage endpoint eg: https://[tablename].table.core.windows.net/ string True
Active Directory OAuth Active Directory OAuth string True
Authority Active Directory authority string False
Tenant Active Directory tenant string True
Credential type Active Directory credential type string False Certificate, Secret
Client ID Active Directory client ID string True
Client secret Active Directory client secret securestring True
Pfx Active Directory pfx securestring True
Password Active Directory password securestring True

Managed identity

Managed identity

Parameters

Name Description Type Required Allowed Values
Table Storage endpoint Table Storage endpoint eg: https://[tablename].table.core.windows.net/ string True
Managed identity Managed identity string True
Managed identity Managed identity string False

Actions

Create table

Creates a table in Azure Table Storage.
Delete Entity

Deletes the entity in the table.
Delete table

Deletes a table in Azure Table Storage.
Get Entity

Gets an entity in the table.
Insert or Update Entity

Inserts or updates an entity in the table.
List tables

Lists tables from Azure Table Storage.
Query Entities

Queries the table for entities.
Update Entity

Updates an entity in the table.

Create table

Operation ID:
createTable

Creates a table in Azure Table Storage.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.
Fail if table exists
 failIfTableExists string

The flag to fail the operation if table already exists.

Returns

Name Path Type Description
Table Name
 tableName string

The name of the table.

Delete Entity

Operation ID:
deleteEntity

Deletes the entity in the table.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.
Partition Key
 partitionKey True string

The partition key for the entity in the table.
Row Key
 rowKey True string

The row key for the entity in the table.
If Match
 ifMatch string

The ETag value to be used for conditionally performing the operation.

Delete table

Operation ID:
deleteTable

Deletes a table in Azure Table Storage.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.

Get Entity

Operation ID:
getEntity

Gets an entity in the table.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.
Partition Key
 partitionKey True string

The partition key for the entity in the table.
Row Key
 rowKey True string

The row key for the entity in the table.
Selected Properties
 select string

Specify the list of properties to be included in result.

Returns

Name Path Type Description
Partition Key
 PartitionKey string
Row Key
 RowKey string
Timestamp
 Timestamp string
ETag
 odata.etag string

Insert or Update Entity

Operation ID:
upsertEntity

Inserts or updates an entity in the table.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.
Entity
 entity True string

The table entity in JSON format. The properties 'PartitionKey' and 'RowKey' must be specified.
Fail if entity exists
 failIfEntityExists string

The flag to fail the operation if the entity already exists.
Update Mode
 updateMode string

The option to either merge with or replace the existing entity while updating it.

List tables

Operation ID:
listTables

Lists tables from Azure Table Storage.

Parameters

Name Key Required Type Description
Continuation Token
 continuationToken string

The continuation token from a previous call.
Filter
 filter string

The operation only returns the values that satisfy the specified filter contitions.
Top
 top string

Top

Returns

Name Path Type Description
Tables
 tables string

The list of tables from Azure Table Storage.
continuationToken
 continuationToken string

Query Entities

Operation ID:
queryEntities

Queries the table for entities.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.
Continuation Token
 continuationToken string

The continuation token from a previous call.
Filter
 filter string

The operation only returns the values that satisfy the specified filter contitions.
Selected Properties
 select string

Specify the list of properties to be included in result.
Top
 top string

Top

Returns

Name Path Type Description
Entities
 entities string
continuationToken
 continuationToken string

Update Entity

Operation ID:
updateEntity

Updates an entity in the table.

Parameters

Name Key Required Type Description
Table Name
 tableName True string

The name of the table.
Entity
 entity True string

The table entity in JSON format. The properties 'PartitionKey' and 'RowKey' must be specified.
Update Mode
 updateMode string

The option to either merge with or replace the existing entity while updating it.
If Match
 ifMatch string

The ETag value to be used for conditionally performing the operation.