Azure Table Storage

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.

Throttling Limits

Name Calls Renewal Period
API calls per connection 1200 60 seconds

Creating a connection

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

Storage Account Name
string
The name of your storage account
Shared Storage Key
securestring
The shared storage key of your storage account

Actions

Create table

This operation adds a table to the storage account.

Required Parameters

Table
string
Specify the new table

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.

Returns

Table metadata
getTableResponse

The metadata for the table

Delete Entity

Operation to delete an entity.

Required Parameters

Table
string
Specify the table.
Partition Key
string
The partition id containing this entity
Row Key
string
The row id containing this entity

Optional Parameters

Client Request Id
string
A client supplied identifier for the operation, which will be echoed in the server response.
ETag
string
Etag to match for concurrency. * to match all values.

Returns

Table metadata
getTableResponse

The metadata for the table

Delete a table

Delete a table.

Required Parameters

Table
string
Specify the table.

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.

Returns

Table metadata
getTableResponse

The metadata for the table

Get a table

This operation gets the metadata of a table.

Required Parameters

Table
string
Specify the table.

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.

Returns

Table metadata
getTableResponse

The metadata for the table

Get entities

This operation queries the entities in a table.

Required Parameters

Table
string
Specify the table.

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.
Filter Query
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
string
OData select query for the columns to be returned. Example: Column, PartitionKey

Returns

Get entities result
getEntitiesResponse

Entity Response Object

Get entity

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

Required Parameters

Table
string
Specify the table.
Partition Key
string
The partition id containing this entity
Row Key
string
The row id containing this entity

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.
Select Query
string
OData select query for the columns to be returned. Example: Column, PartitionKey

Returns

An entity
getEntityResponse

An entity

Insert Entity

Operation to add an entity to a table.

Required Parameters

Table
string
Specify the table.

Optional Parameters

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

Returns

Entity
InsertEntityResponse

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.

Required Parameters

Table
string
Specify the table.
Partition Key
string
The partition id containing this entity
Row Key
string
The row id containing this entity

Optional Parameters

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

Returns

Table metadata
getTableResponse

The metadata for the table

Insert or Replace Entity

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

Required Parameters

Table
string
Specify the table.
Partition Key
string
The partition id containing this entity
Row Key
string
The row id containing this entity

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request..

Returns

Table metadata
getTableResponse

The metadata for the table

List tables

This operation lists the tables in the account.

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.

Returns

Body
getTablesResponse

Table query response object

Merge Entity

Operation to merge data with an entity in a table.

Required Parameters

Table
string
Specify the table.
Partition Key
string
The partition id containing this entity
Row Key
string
The row id containing this entity
ETag
string
Etag to match for concurrency. * to match all values.

Optional Parameters

Client Request Id
string
Unique identifier for tracking the request.

Returns

Table metadata
getTableResponse

The metadata for the table

Replace Entity

Operation to replace an entity in a table.

Required Parameters

Table
string
Specify the table.
Partition Key
string
The partition id containing this entity
Row Key
string
The row id containing this entity
ETag
string
ETag to match for concurrency. * to match all values.

Optional Parameters

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

Returns

Table metadata
getTableResponse

The metadata for the table

Definitions

getTablesResponse

Table query response object

Account metadata location
string
URL to the account metadata
List of tables
array of object
List of tables
Table Name
string
Table Name
Table location
string
URL to the Table data

getTableResponse

The metadata for the table

Table Name
string
Table Name
Table location
string
URL to the Table data

Item

An entity

Entity data
string
The unique columns for the entity
Partition Key
string
Partition Key
Row Key
string
Row Key

getEntitiesResponse

Entity Response Object

List of Entities
array of Item
List of Entities
Table Metadata location
string
Table Metadata location

getEntityResponse

An entity

Entity data
string
The unique columns for the entity
Partition Key
string
Partition Key
Row Key
string
Row Key
Table Metadata location
string
Table Metadata location

InsertEntityResponse

Data for a single entity

Entity Metadata location
string
Entity Metadata location
Entity data
string
The unique columns for the entity
Partition Key
string
Partition Key
Row Key
string
Row Key