Microsoft Azure Storage Query

You can use this activity to download files or list the shares, directories, and files.

Configuration

This tab has the following fields.

Field Description
Connection Lists all connections for a Microsoft Azure Storage account.
Service Lists the service provided.
Operation Lists all operations available for the File service:
  • List Shares: Lists all the file shares in a Microsoft Azure Storage account.
  • 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.
  • Get File: Downloads a file from the File service and provides the file content in base64 encoded format.

Input

This tab has the following fields:

Field Operation Description
shareName List Directories and Files, Get File Name of a share in a Microsoft Azure storage account.
directoryPath List Directories and Files, Get File (optional) Path to the parent directory.
fileName Get File Name of the file to be downloaded.
prefix List Shares, List Directories and Files (optional) Filtered results from the list of directories and files which return only files and directories whose name starts with the specified prefix.
maxresults List Shares, List Directories and Files (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 List Shares, List Directories and Files (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.

Output

The Output tab displays the output schema of the activity in a tree structure format. The output is read-only. 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.
Field Operation Description
isSuccess Get File Displays the success status of the activity in the form of boolean datatype.
shareName Get File Displays the name of share in a Microsoft Azure Storage account.
directoryPath Get File Displays the path to the parent directory.
fileName Get File Displays the name of the file.
statusCode Get File Displays the http status code of the operation.
statusMessage Get File Displays the status message of the operation.
fileContent Get File Returns the content of the file in base64 encoded format.
Directory array List Directories and Files Displays the properties of directories.
File array List Directories and Files Displays the properties of files.
Shares array List Shares Displays the metadata properties of the shares.
NextMarker List Shares, List Directories and Files 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.