Azure Table Storage

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
Flow Standard All Flow regions
PowerApps Standard All PowerApps regions

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.

Creating a connection

To connect your account, you will need the following information:

Name Type Description
Storage Account Name string

The name of your storage account

Shared Storage Key securestring

The shared storage key of your storage account

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

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

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 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

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

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

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 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

Insert or Merge Entity

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 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

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

Merge Entity

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 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