Access Data in Azure Blob Storage

Question

Solution to access files residing in Azure Blob Storage using Alteryx Designer

Requirements

1. Create a Blob Storage Account in Azure

2. Follow instructions in the link below to create a container:

https://docs.microsoft.com/en-us/azure/storage/common/storage-create-storage-account

3. Create a shared access signature:

https://docs.microsoft.com/en-us/azure/storage/common/storage-dotnet-shared-access-signature-part-1

Pre-requisites to creating workflows in Alteryx

* Copy the shared access signature
* The Download Tool in Alteryx does not work with encoded URL. Use the signature value from a decoded URL. Any web browser developer tool can be used for decoding

Workflow to upload a file to Azure Blob Storage using the Alteryx Designer

In the attached workflow, UploadFileToBlobStorage, the Blob Account Storage name is durgastorage and the container name is sa2. A file by name oneGigFile.csv is uploaded to the container sa2. The file is saved as azureoneGig.csv

Workflow to download a file from Azure Blob Storage using the Alteryx Designer

In the attached workflow, DownloadFileFromBlobStorage a file named myfile.txt, residing in the container named sa2, is downloaded

coderockride · Answer

I'm trying the upload using the workflow template above but getting the following error. Any ideas?

HTTP/1.1 100 Continue

HTTP/1.1 403 Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
Content-Length: 408
Content-Type: application/xml
Server: Microsoft-HTTPAPI/2.0 ...

I'm also happy to try the REST API approach but my oh my is the documentation for this things are nightmare to comb through.

seenu433 · Answer

This is not currently supported. We have couple of options though, where you can host an Azure Function or a REST API which can receive the File via POST and further upload it to Azure Storage. Alternatively you could use AZCopy and invoke a Command task to copy the file over to Azure Storage. Hope this helps.

Drew_Moore · Answer

Also getting the content-length header issue.  I tried adding the content-length header, with no clue what to enter as a value, and the error message changes from HTTP/1.1 411 Content-Length HTTP header is missing. to HTTP/1.1 400 The value for one of the HTTP headers is not in the correct format.

Anyone know what the issue might be?