Azure Actions
Actions for interacting with Microsoft Azure Table, Blob, Queue, File & Cosmos storage and the Azure Form Recognizer service.
Azure File
Download or Upload files to Azure Storage shares.
Specify your Azure Storage Account Name and Access Key and click the Connect button to connect.
Select the Share that you want to upload to or download from.
Select Upload or Download from the Operation selector.
Downloading
In the Remote Files navigator you can navigate folders and files in the Azure Share. Double-click a file to add it to the Download Files entry. Multiple files can be downloaded within the same action. Separate each file with a comma.
You can also specify the Downloaded Files directly by entering the paths (or use %variable% replacements). Each file must specify the full path (beginning with /).
Specify the Save To folder where you want the downloaded files saved to.
The Assign To variable will receive the local path/filename where the file(s) have been downloaded to. Multiple files will be separated by commas.
Uploading
In the Remote Files navigator you can navigate folders and files in the Azure Share. Select the folder where you want to upload files to.
In the Upload Files entry enter or select the local files to upload (use %variable% replacements if required). Multiple files should be separated by commas. File paths can include wildcards.
You also have the option of uploading Attachments. Select the Include Incoming Attachments option and specify the Mask.
The Assign To variable will receive the Azure path names for the uploaded files(s). Multiple files will be separated by commas.
Azure File Get Link
Get URLs to files in an Azure Storage share.
This action can be used to generate a read-only URL to a file in an Azure Share. You can specify the number of minutes that the URL will be active for.
Specify your Azure Storage Account Name and Access Key and click the Connect button to connect.
Select the Share that you want to use.
In the Remote Files navigator you can navigate folders and files in the Azure Share. Double-click a file to add it to the Get Link(s) For Files entry. Multiple URLs can be generated within the same action.
You can also specify the Get Link(s) For Files directly by entering the paths (or use %variable% replacements). Each file must specify the full path (beginning with /). If using this action after the Azure File - Upload action you can use the %variable% previously returned from the Upload - this will then get links to the files just uploaded.
In the Links Valid For Minutes entry, specify the number of minutes that the link is usable for. This defaults to 1440 (24 hours).
In the Links Valid Only For IP Addresses entry you can optionally specify an IP address or range. The link will then only work when requested from the IP. IP ranges should be in the format (for example): 168.1.5.60-168.1.5.70
The Assign Links To variable will receive the URL. If multiple files are used then each URL will be separated with a comma.
You can then send this URL with an outgoing email to give the recipient time-limited access to the file(s).
Azure Cosmos DB
Update or query Json documents from an Azure Cosmos DB.
Specify your Azure Cosmos DB Endpoint and Access Key and click the Connect button to connect.
Enter or select the Database and Container within the selected database.
Enter the Partition Key that you have defined for the Database\Container.
If the database or container do not exist they will be created if the Create option is enabled.
Operation
Insert or Update Document
This option will add a new document or update an existing one.
Set the Document Json to the Json text for the document. If the Json contains an id field then an existing document will be updated if one exists with the same id. If no id field is specified in the Json document the Cosmos will insert a new record and add the id field to the Json stored in the database.
You can build Json using the Create Json action and then set the Document Json to the %variable% name containing the Json, or you can specify it directly.
To store the incoming message you can set the Document Json to %Msg_Json%. The %Msg_Json% built-in variable returns a Json document representing the incoming message (including attachments).
Query Document
This option will query the selected database/container. The returned query results (in Json format) can be assigned to a variable from the Assign To list.
Enter the Query SQL Select Statement, for example:
SELECT *
FROM Families f
WHERE f.id = "AndersenFamily"
The SQL statement must be compatible with the Cosmos SQL specifications.
You can use %variable% replacements:
SELECT *
FROM Families f
WHERE f.id = "%FamilyId%"
You can also use parameters:
SELECT *
FROM Families f
WHERE f.id = @id
If parameters are used you must the assign each parameter name a type and value in the Parameters grid.
When the Automation executes the Json returned from the query will be assigned to the variable specified. If multiple documents are returned the Json will contain an array of documents. If a single document is returned then the Json will be set to the document json.
You can assign the count of documents returned to a variable from the Assign Count To list.
Azure Blob
Read from or write to Azure Blob Storage.
Specify your Azure Storage Account Name and Access Key and click the Connect button to connect.
Select the blob Container to read from or write to.
Select the Operation - Get Blob to read a blob or Put Blob to upload new blobs.
Get
Enter the Blob Name to read. This can contain %variable% replacements.
You can specify a Save To where the Blob will be saved. The saved blob path & name can then be assigned to a variable from the Assign To list.
If no Save To path is specified then the blob data itself will be assigned to the Assign To variable without being saved to a file.
Put
You can Put either Files & Attachments or Blob Data:
Files & Attachments
Enter a Blob Name - this is optional. If no name is specified then the file names will be used.
In the Upload Files entry, specify local files to upload. You can specify multiple files separated by commas. Leave blank to only upload attachments
Enable the Include Incoming Attachments to upload attachments and specify the Matching Mask (eg: *.pdf).
Enable the Ensure Unique option to append a timestamp to the uploaded file names to ensure they are unique. Otherwise any existing blob with the same name will be overwritten.
Enable the Append Filenames To Blob Name option to append uploaded file names to the Blob Name specified. This is only applicable if a Blob Name has been specified. For example: If the Blob Name is set to 'orders' and the attachment '1234.pdf' is uploaded, then the Blob name in your storage account will be set to 'orders1234.pdf'.
Each uploaded Blob is given a unique URL. You can assign the URL to a variable from the Assign Url(s) To list. If multiple files are uploaded then the multiple URL's will be returned, separated by commas.
Blob Data
This option allows you to upload raw blob data. The Blob Name & Blob Data must be specified. Any existing Blob with the same name will be overwritten.
Azure Table
Read from or write to Azure Table Storage.
Specify your Azure Storage Account Name and Access Key and click the Connect button to connect.
Select the Table Name to read from or write to.
Select the Operation - Get Entity to read a table row or Put Entity to write a new table row.
Get
Specify the Partition Key and Row Key for the table entity you want to read. These can contain %variable% replacements.
Once the table entity has been read you can then map entity property names to ThinkAutomation variables. Select the ThinkAutomation variable name from the Assign To list - and then enter or select the table entity property name in the Assign From column.
Put
Specify the Partition Key and Row Key for the new table entity you want to write. These can contain %variable% replacements.
You must then map entity property names to ThinkAutomation variables. Select the ThinkAutomation variable name from the Assign From list. Select the property Type, and then enter or select the table entity property name in the Assign To column.
You can also assign the URL to the newly created Table entity by selecting from the Assign Url To list.
Azure Queue
Get or Add to an Azure Queue.
Specify your Azure Storage Account Name and Access Key and click the Connect button to connect.
Select the Queue Name to use.
Select the Operation - Get Message to take the next message from the queue or Put Message to add to the queue.
Get Message
This will take the next message from the queue. Select the variable to receive the queue message from the Assign To list.
Put Message
This will add a message to the queue. Specify the Message Data.
Azure Form Recognize
Extract text, key-value pairs and tables from documents, forms, receipts, invoices and business cards without manual labelling using the Azure Form Recognizer service. See: Form Recogniser – Automated Data Processing Systems | Microsoft Azure
Specify your Azure Form Recognizer Endpoint and Access Key.
Select the Model. This can be:
- Layout - for generic documents.
- Invoice - for invoices.
- Business Card - for business cards and ID documents.
- Receipt - for paper receipts.
Select the Locale/Language.
For the Layout model you can select a Pages range. This can be in the format 1-3, or 1,3,5. Leave blank for all pages.
Select the Analyze File. This can be any local file or a %variable% replacement. The following file types are supported: PDF, BMP, PNG, JPEG or TIF.
Select the variable to receive the result from the Assign Result To list.