Azure Blob Storage

Microsoft Azure Storage provides a massively scalable, durable, and highly available storage for data on the cloud, and serves as the data storage solution for modern applications. Connect to Blob Storage to perform various operations such as create, update, get and delete on blobs in your Azure Storage account.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions
Flow Premium All Flow regions
PowerApps Premium All PowerApps regions

Azure Data Lake Storage Gen2

The Azure Blob Storage connector now supports connecting to Azure Data Lake Storage Gen2 (ADLS Gen2) accounts, using multi-protocol access. You can read more about this new feature, including the availability and known limitations in this blog.

Known issues and limitations

  1. The action Extract archive to folder ignores empty files and folders in the archive, they are not extracted to the destination.
  2. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

General Limits

Name Value
Maximum file size with enabled chunking (in MB) 1024
Maximum file size with disabled chunking, maximum archive size for extraction, maximum size of a source for copy blob operation in case of absolute Uri (in MB) 50
Maximum number of files in archive 100
Maximum total size of files in archive (in MB) 750
Maximum page size for List blobs 5000
Maximum trackable number of items inside of a virtual folder for trigger 30000
Maximum blob size for copy blob within one storage account (source is a relative path) unlimited

Creating a connection

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

Name Type Description
Azure Storage Account name string

Name of the storage account the connector should use.

Azure Storage Account Access Key securestring

Specify a valid primary/secondary storage account access key.

Throttling Limits

Name Calls Renewal Period
API calls per connection120060 seconds

Actions

Copy blob

This operation copies a blob. If blob is being deleted/renamed on server right after it was copied, connector may return HTTP 404 error by it's design. Please use a delay for 1 minute before deleting or renaming newly created blob.

Create blob

This operation uploads a blob to Azure Blob Storage.

Create block blob

This operation uploads a block blob to Azure Blob Storage.

Create SAS URI by path

This operation creates a SAS link for a blob using the path.

Delete blob

This operation deletes a blob.

Extract archive to folder

This operation extracts an archive blob into a folder (example: .zip).

Get available access policies

This operation gets available shared access policies for a blob.

Get blob content

This operation retrieves blob contents using id.

Get blob content using path

This operation retrieves blob contents using path

Get Blob Metadata

This operation retrieves blob metadata using blob id.

Get Blob Metadata using path

This operation retrieves blob metadata using path.

List blobs

This operation lists blobs in a container.

List blobs in root folder

This operation lists blobs in the Azure Blob Storage root folder.

Set blob tier by path

This operation sets a tier for a block blob on a standard storage account using the path.

Update blob

This operation updates a blob in Azure Blob Storage.

Copy blob

This operation copies a blob. If blob is being deleted/renamed on server right after it was copied, connector may return HTTP 404 error by it's design. Please use a delay for 1 minute before deleting or renaming newly created blob.

Parameters

Name Key Required Type Description
Source url
source True string

Specify the Url to source blob

Destination blob path
destination True string

Specify the destination blob path, including target blobname

Overwrite?
overwrite boolean

Should the destination blob be overwritten (true/false)?

Returns

Blob metadata

Create blob

This operation uploads a blob to Azure Blob Storage.

Parameters

Name Key Required Type Description
Folder path
folderPath True string

Specify folder path to upload

Blob name
name True string

Specify name of the blob to create

Blob content
body True binary

Specify content of the blob to upload

Content-Type
Content-Type string

Specify content-type of the blob to upload.

Returns

Blob metadata

Create block blob

This operation uploads a block blob to Azure Blob Storage.

Parameters

Name Key Required Type Description
Specify folder path to upload
folderPath True string

Specify folder path to upload.

Specify name of the blob to create
name True string

Specify name of the blob to create.

Blob content
body True binary

Specify content of the blob to upload.

Content-Type
Content-Type string

Specify content-type of the blob to upload.

Create SAS URI by path

This operation creates a SAS link for a blob using the path.

Parameters

Name Key Required Type Description
Blob path
path True string

The unique path of the blob.

Group Policy Identifier
GroupPolicyIdentifier string

The string identifying a stored access policy.

Permissions
Permissions string

The permissions specified on the SAS (Values separated by comma).

Start Time
StartTime date-time

The date and time at which the SAS becomes valid (example: '2017-11-01T15:30:00+00:00'). Default = now().

Expiry Time
ExpiryTime date-time

The date and time after which the SAS is no longer valid (example: '2017-12-01T15:30:00+00:00'). Default = now() + 24h.

Shared Access Protocol
AccessProtocol string

The allowed protocols (https only, or http and https). Null if you don't want to restrict protocol.

IP address or IP address range
IpAddressOrRange string

The allowed IP address or IP address range. Null if you don't want to restrict based on IP address.

Returns

Shared access signature

Delete blob

This operation deletes a blob.

Parameters

Name Key Required Type Description
Blob
id True string

Specify the blob to delete

Extract archive to folder

This operation extracts an archive blob into a folder (example: .zip).

Parameters

Name Key Required Type Description
Source archive blob path
source True string

Specify the path to the archive blob

Destination folder path
destination True string

Specify the path in Azure Blob Storage to extract the archive contents

Overwrite?
overwrite boolean

Should destination blob be overwritten (true/false)?

Returns

Get available access policies

This operation gets available shared access policies for a blob.

Parameters

Name Key Required Type Description
Blob path
path True string

The unique path of the blob.

Returns

Get blob content

This operation retrieves blob contents using id.

Parameters

Name Key Required Type Description
Blob
id True string

Specify the blob

Infer Content Type
inferContentType boolean

Infer content-type based on extension

Returns

The content of the file.

File Content
binary

Get blob content using path

This operation retrieves blob contents using path

Parameters

Name Key Required Type Description
Blob path
path True string

Specify unique path to the blob

Infer Content Type
inferContentType boolean

Infer content-type based on extension

Returns

The content of the file.

File Content
binary

Get Blob Metadata

This operation retrieves blob metadata using blob id.

Parameters

Name Key Required Type Description
Blob
id True string

Specify the blob

Returns

Blob metadata

Get Blob Metadata using path

This operation retrieves blob metadata using path.

Parameters

Name Key Required Type Description
Blob path
path True string

Specify unique path to the blob

Returns

Blob metadata

List blobs

This operation lists blobs in a container.

Parameters

Name Key Required Type Description
Folder
id True string

Specify the folder

Paging Marker
nextPageMarker string

A marker that identifies the portion of the list to be returned with the list operation

Flat Listing
useFlatListing boolean

Whether or not to list blobs in flat listing

Returns

Represents a page of blob metadata.

List blobs in root folder

This operation lists blobs in the Azure Blob Storage root folder.

Parameters

Name Key Required Type Description
Paging Marker
nextPageMarker string

A marker that identifies the portion of the list to be returned with the list operation

Returns

Represents a page of blob metadata.

Set blob tier by path

This operation sets a tier for a block blob on a standard storage account using the path.

Parameters

Name Key Required Type Description
Blob path
path True string

The unique path of the blob.

Blob Tier
newTier True string

The new tier for the blob.

Update blob

This operation updates a blob in Azure Blob Storage.

Parameters

Name Key Required Type Description
Blob
id True string

Specify the blob to update

Blob content
body True binary

Specify the content of the blob to update

Content-Type
Content-Type string

Specify content-type of the blob to update.

Returns

Blob metadata

Triggers

When a blob is added or modified (properties only)

This operation triggers a flow when one or more blobs are added or modified in a container. This trigger will only fetch the file metadata. To get the file content, you can use the "Get file content" operation. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

When a blob is added or modified (properties only)

This operation triggers a flow when one or more blobs are added or modified in a container. This trigger will only fetch the file metadata. To get the file content, you can use the "Get file content" operation. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

Parameters

Name Key Required Type Description
Container
folderId True string

Select a container

Number of blobs to return from the trigger
maxFileCount integer

Max blob count (1-100)

Returns

Blob metadata

List of Files
BlobMetadata

Definitions

SharedAccessSignatureBlobPolicy

The set of parameters to generate a SAS link.

Name Path Type Description
Group Policy Identifier
GroupPolicyIdentifier string

The string identifying a stored access policy.

Permissions
Permissions string

The permissions specified on the SAS (Values separated by comma).

Start Time
StartTime date-time

The date and time at which the SAS becomes valid (example: '2017-11-01T15:30:00+00:00'). Default = now().

Expiry Time
ExpiryTime date-time

The date and time after which the SAS is no longer valid (example: '2017-12-01T15:30:00+00:00'). Default = now() + 24h.

Shared Access Protocol
AccessProtocol string

The allowed protocols (https only, or http and https). Null if you don't want to restrict protocol.

IP address or IP address range
IpAddressOrRange string

The allowed IP address or IP address range. Null if you don't want to restrict based on IP address.

SharedAccessSignature

Shared access signature

Name Path Type Description
Web Url
WebUrl uri

A URL to an object with access token.

BlobMetadata

Blob metadata

Name Path Type Description
Id
Id string

The unique id of the file or folder.

Name
Name string

The name of the file or folder.

DisplayName
DisplayName string

The display name of the file or folder.

Path
Path string

The path of the file or folder.

LastModified
LastModified date-time

The date and time the file or folder was last modified.

Size
Size integer

The size of the file or folder.

MediaType
MediaType string

The media type of the file or folder.

IsFolder
IsFolder boolean

A boolean value (true, false) to indicate whether or not the blob is a folder.

ETag
ETag string

The etag of the file or folder.

FileLocator
FileLocator string

The filelocator of the file or folder.

BlobMetadataPage

Represents a page of blob metadata.

Name Path Type Description
value
value array of BlobMetadata

Blob metadata collection.

nextLink
nextLink string

An Url which can be used to retrieve the next page.

Next page marker
nextPageMarker string

A marker which can be used to retrieve the next page.