Microsoft Azure Storage Query

You can use this activity to download files or list the shares, directories, and files. You can also list blobs in a container and download a blob from a container.

Settings

This tab has the following fields.

Field Description
Connection Lists all connections for a Microsoft Azure Storage account.
Service Lists the service provided. The following services are available :
  • File.
  • Blob.
Operation Lists all operations available for a service.
The following operations are available for File service:
  • Get File: Downloads a file from the File service and provides the file content in base64 encoded format.
  • List Directories and Files: Lists directories and files within the share or specified directory. It also lists the contents only for a single level of the directory hierarchy.
  • List Shares: Lists all the file shares in a Microsoft Azure Storage account.
The following operations are available for Blob service:
  • List Blobs: Lists the blobs in a container.
  • Download Blob: Downloads the blob from a container.

Input

The Input tab for File Service has the following fields:
Operation Field Description
Get File shareName Name of a share in a Microsoft Azure storage account.
directoryPath (optional) Path to the parent directory.
fileName Name of the file to be downloaded.
List Directories and Files shareName Name of a share in a Microsoft Azure storage account.
directoryPath (optional) Path to the parent directory.
prefix (optional) Filtered results from the list of directories and files which return only files and directories whose name starts with the specified prefix.
maxresults (optional) Maximum number of files and directories that can return from the server. If your request specifies a number greater than 5000, the server will return only 5000 files.
nextmarker (optional) The operation returns a marker value within the response body if there are more list items to retrieve than what is currently returned. This marker value is then used in the consequent operation to request the next set of list items.
List Shares prefix (optional) Filtered results from the list of directories and files which return only files and directories whose name starts with the specified prefix.
maxresults (optional) Maximum number of files and directories that can return from the server. If your request specifies a number greater than 5000, the server will return only 5000 files.
nextmarker (optional) The operation returns a marker value within the response body if there are more list items to retrieve than what is currently returned. This marker value is then used in the consequent operation to request the next set of list items.
The Input tab for Blob Service has the following fields:
Operation Field Description
List Blobs containerName Name of a container in a Microsoft Azure storage account.
Download Blob containerName Name of the container from where blob is to be downloaded.
relativePath (optional) Path to the blob.
blobName Name of the blob to be downloaded.

Output

The Output tab displays the output schema of the activity in a tree structure format. The information in the schema varies based on the fields selected on the Configuration tab. The properties that are displayed in the schema correspond to the output of this activity and can be used as input by subsequent activities in the flow.

The Output tab for File Service has the following fields:
Operation Field Description
Get File isSuccess Displays the success status of the activity in the form of boolean datatype.
shareName Displays the name of share in a Microsoft Azure Storage account.
directoryPath Displays the path to the parent directory.
fileName Displays the name of the file.
statusCode Displays the http status code of the operation.
statusMessage Displays the status message of the operation.
fileContent Returns the content of the file in base64 encoded format.
List Directories and Files Directory array Displays the properties of directories.
File array Displays the properties of files.
NextMarker The operation returns a marker value within the response body if there are more list items to retrieve than what is currently returned. This marker value is then used in the consequent operation to request the next set of list items.
Note: When the NextMarker element is empty, the listing operation is completed.
Note: To return the next set of results in a subsequent operation, pass the value returned in the NextMarker tag as the nextmarker parameter has an input field to the subsequent Microsoft Azure Storage Query activity.
List Shares Shares array Displays the metadata properties of the shares.
NextMarker The operation returns a marker value within the response body if there are more list items to retrieve than what is currently returned. This marker value is then used in the consequent operation to request the next set of list items.
Note: When the NextMarker element is empty, the listing operation is completed.
Note: To return the next set of results in a subsequent operation, pass the value returned in the NextMarker tag as the nextmarker parameter has an input field to the subsequent Microsoft Azure Storage Query activity.
The Output tab for Blob Service has the following fields:
Field Description
List Blobs listofBlobs Lists the blobs present in the container.
containerName Displays the name of the container in a Microsoft Azure Storage account.
statusMessage Displays the status message of the operation.
Download Blob containerName Displays the name of the container in a Microsoft Azure Storage account.
blobName Displays the name of the blob.
blobContent Returns the content of the blob in base64 encoded format.
statusMessage Displays the status message of the operation.

Loop

If you would like this activity to iterate multiple times within the flow, enter an expression that evaluates to the iteration details. Select a type of iteration from the Type menu. The default type is None, which means the activity will not iterate. Refer to the "Using the Loop Feature in an Activity" topic in the TIBCO Flogo® Enterprise documentation.