Feedback

Azure Table Storage

  • Reference

Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Sign into your Storage account to create, update, and query tables and more.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions and Integration Service Environments (ISEs)
Power Automate Premium All Power Automate regions
Power Apps - Not available
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Connector Metadata
Publisher Microsoft
Website https://azure.microsoft.com/services/storage/tables/

To use this integration, you will need access to an Azure storage account. More information can be found here. When trying to make a connection, you will be prompted to provide your storage account name and your storage key. The name of your storage account can be found in the URL, for example if your URL is https://myaccount.table.core.windows.net then the account name would be "myaccount". If you have multiple accounts, provide the one you would like to use and select Create. If you see an error during creation, check the account name and the key and try again. You're now ready to start using this integration.

Known issues and limitations

  1. Logic apps can't directly access storage accounts that are behind firewalls if they're both in the same region. As a workaround, you can have your logic apps and storage account in different regions. For more information about enabling access from Azure Logic Apps to storage accounts behind firewalls, see the Access storage accounts behind firewalls

Creating a connection

The connector supports the following authentication types:
Logic Apps Managed Identity Create a connection using a Managed Identity LOGICAPPS only Shareable
Default Log in with your credentials. All regions except LOGICAPPS Not shareable

Logic Apps Managed Identity

Auth ID: managedIdentityAuth

Applicable: LOGICAPPS only

Create a connection using a Managed Identity

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
Managed Identity managedIdentity Sign in with a Managed Identity True

Default

Applicable: All regions except LOGICAPPS

Log in with your credentials.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
Storage Account Name string The name of your storage account True
Shared Storage Key securestring The shared storage key of your storage account True

Throttling Limits

Name Calls Renewal Period
API calls per connection120060 seconds

Actions

Create table

This operation adds a table to the storage account.
Delete a table

Delete a table.
Delete Entity

Operation to delete an entity.
Get a table

This operation gets the metadata of a table.
Get entities

This operation queries the entities in a table.
Get entity

This operation gets the entity in a table based on the partition and row key.
Insert Entity

Operation to add an entity to a table.
Insert or Merge Entity

Operation to merge data with an entity in a table, creating a new entity if needed.
Insert or Replace Entity

Operation to replace an entity in a table, creating a new entity if needed.
List tables

This operation lists the tables in the account.
Merge Entity

Operation to merge data with an entity in a table.
Replace Entity

Operation to replace an entity in a table.

Create table

Operation ID:
CreateTable

This operation adds a table to the storage account.

Parameters

Name Key Required Type Description
Table
 TableName True string

Specify the new table
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.

Returns

The metadata for the table

Table metadata
getTableResponse

Delete a table

Operation ID:
DeleteTable

Delete a table.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.

Delete Entity

Operation ID:
DeleteEntity

Operation to delete an entity.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Partition Key
 PartitionKey True string

The partition id containing this entity
Row Key
 RowKey True string

The row id containing this entity
Client Request Id
 x-ms-client-request-id string

A client supplied identifier for the operation, which will be echoed in the server response.
ETag
 If-Match string

Etag to match for concurrency. * to match all values.

Get a table

Operation ID:
GetTable

This operation gets the metadata of a table.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.

Returns

The metadata for the table

Table metadata
getTableResponse

Get entities

Operation ID:
GetEntities

This operation queries the entities in a table.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.
Filter Query
 $filter string

OData filter query for which entities to return. Example: Column eq 'Value' and Column2 ne 2. Invalid OData queries, such as not wrapping string values in quotes will return 501.
Select Query
 $select string

OData select query for the columns to be returned. Example: Column, PartitionKey

Returns

Entity Response Object

Get entities result
getEntitiesResponse

Get entity

Operation ID:
GetEntity

This operation gets the entity in a table based on the partition and row key.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Partition Key
 PartitionKey True string

The partition id containing this entity
Row Key
 RowKey True string

The row id containing this entity
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.
Select Query
 $select string

OData select query for the columns to be returned. Example: Column, PartitionKey

Returns

An entity

An entity
getEntityResponse

Insert Entity

Operation ID:
CreateEntity

Operation to add an entity to a table.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Client Request Id
 x-ms-client-request-id string

A client supplied identifier for the operation, which will be echoed in the server response.

Returns

Data for a single entity

Entity
InsertEntityResponse

Insert or Merge Entity

Operation ID:
InsertMergeEntity

Operation to merge data with an entity in a table, creating a new entity if needed.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Partition Key
 PartitionKey True string

The partition id containing this entity
Row Key
 RowKey True string

The row id containing this entity
Client Request Id
 x-ms-client-request-id string

A client supplied identifier for the operation, which will be echoed in the server response.

Insert or Replace Entity

Operation ID:
InsertReplaceEntity

Operation to replace an entity in a table, creating a new entity if needed.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Partition Key
 PartitionKey True string

The partition id containing this entity
Row Key
 RowKey True string

The row id containing this entity
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request..

List tables

Operation ID:
GetTables

This operation lists the tables in the account.

Parameters

Name Key Required Type Description
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.

Returns

Table query response object

Body
getTablesResponse

Merge Entity

Operation ID:
MergeEntity

Operation to merge data with an entity in a table.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Partition Key
 PartitionKey True string

The partition id containing this entity
Row Key
 RowKey True string

The row id containing this entity
ETag
 If-Match True string

Etag to match for concurrency. * to match all values.
Client Request Id
 x-ms-client-request-id string

Unique identifier for tracking the request.

Replace Entity

Operation ID:
ReplaceEntity

Operation to replace an entity in a table.

Parameters

Name Key Required Type Description
Table
 tableName True string

Specify the table.
Partition Key
 PartitionKey True string

The partition id containing this entity
Row Key
 RowKey True string

The row id containing this entity
ETag
 If-Match True string

ETag to match for concurrency. * to match all values.
Client Request Id
 x-ms-client-request-id string

A client supplied identifier for the operation, which will be echoed in the server response.

Definitions

getTablesResponse

Table query response object

Name Path Type Description
Account metadata location
 odata.metadata string

URL to the account metadata
List of tables
 value array of object

List of tables
Table location
 value.odata.id string

URL to the Table data
Table Name
 value.TableName string

Table Name

getTableResponse

The metadata for the table

Name Path Type Description
Table location
 odata.id string

URL to the Table data
Table Name
 TableName string

Table Name

Item

An entity

Name Path Type Description
Partition Key
 PartitionKey string

Partition Key
Row Key
 RowKey string

Row Key
Entity data
 additionalProperties string

The unique columns for the entity

getEntitiesResponse

Entity Response Object

Name Path Type Description
Table Metadata location
 odata.metadata string

Table Metadata location
List of Entities
 value array of Item

List of Entities

getEntityResponse

An entity

Name Path Type Description
Table Metadata location
 odata.metadata string

Table Metadata location
Partition Key
 PartitionKey string

Partition Key
Row Key
 RowKey string

Row Key
Entity data
 additionalProperties string

The unique columns for the entity

InsertEntityResponse

Data for a single entity

Name Path Type Description
Entity Metadata location
 odata.metadata string

Entity Metadata location
Partition Key
 PartitionKey string

Partition Key
Row Key
 RowKey string

Row Key
Entity data
 additionalProperties string

The unique columns for the entity