Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data.

Connect Azure Storage with LogicHub

1. Navigate to Automations > Integrations.
2. Search for Azure Storage.
3. Click Details, then the + icon. Enter the required information in the following fields.
   • Label: Enter a connection name.
   • Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
   • Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
   • Remote Agent: Run this integration using the LogicHub Remote Agent.
   • Connection String: Connection string to which connection will be made.
4. After you've entered all the details, click Connect.

Actions for Azure Compute

Create Container

Create a container with specific details.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

The only possible values in the parent table will be {None, container, blob}. if not passed. No public access policy will be applied on all rows of the parent table.

Output

A JSON object containing Success/Failure message.

Upload File

Upload file on a given container.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

A JSON object containing Success/Failure message.

Download File

Download file from the given container.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

A JSON object containing Success/Failure message.

List File

List file in a given container.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

Returns a collection of dicts, each containing file details.

Set Access Policy

Add access Policy on the container.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

A JSON object containing Success/Failure message.

Get File Access URL

Get file URL with access as per the access policy.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

Returns the URL of the blob with the access policy that was applied.

Query all Tables in Account

The query tables operation returns a list of tables under the specified account

Input Field

Choose a connection that you have previously created.

Output

JSON containing the following items:

{
   "tables": [
      {
         "name": "BineetTest"
      },
      {
         "name": "IndrajeetTest"
      },
      {
         "name": "IndraTest1"
      },
      {
         "name": "SumitTest"
      }
   ],
   "has_error": false,
   "error": null
}

Create Table in Account

Creates a new table under the current account.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

JSON containing the following items:

{
   "has_error": false,
   "table_name": "IndraTest123",
   "error": null
}

Delete Table in Account

Deletes the table under the current account. No error will be raised if the given table is not found.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

JSON containing the following items:

{
   "has_error": false,
   "table_name": "IndraTest123",
   "error": null
}

Upsert Merge Entity in Table

Add new properties to an existing entity it will not delete an existing properties

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

JSON containing the following items:

{
   "message": "Updated successfully.",
   "has_error": false,
   "error": null
}

Upsert Replace Entity in Table

Replace the existing entity with the given one, deleting any existing properties not included in the submitted entity

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

JSON containing the following items:

{
   "message": "Updated successfully.",
   "has_error": false,
   "error": null
}

Delete an Entity from the Table

Delete an entity from the table

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Output

JSON containing the following items:

{
   "message": "Deleted entity successfully.",
   "has_error": false,
   "error": null
}

Release Notes

• v2.1.4 - Added six new actions on azure storage tables.
• v2.0.0 - Updated architecture to support IO via filesystem