Alteryx output to Azure Blob storage

Question

Hi, I'm very new to Alteryx. If I am incorrectly understanding something or am posting on the wrong discussion board, please let me know.

I need to directly upload an Alteryx output (in the form of an excel or CSV) to Azure Blob storage. Uploading directly from Alteryx is much preferable, but if that isn't possible than creating the excel file from Alteryx and then uploading the excel file afterwards to Azure Blob storage would be alright.

I've searched for help online already, but none of the information or tutorials match up quite to what I need.

Thank you.

pfiskrat · Answer

Read the Microsoft documentation for the PUT Blob: Put Blob (REST API) - Azure Storage | Microsoft Learn
The body of the response in Alteryx will tell you which is the unsupported header. It's hard to tell from your image but you appear to be missing a few required headers for this.

You are able to stream in a file directly, it does not have to be from URL as shown in the video. For this I used the blob input, followed immediately by an append to itself to duplicate the field, then convert the blob into HEX so that we can measure the bytes for the "Content-Length" required header.

I was able to get it to work from using the Microsoft documentation and using the YouTube video you linked, thank you for the video link.

For me, Alteryx was automatically adding the "Transfer-Encoding" header and that video showed me that I can add this header with an empty string value and that will overwrite the Alteryx auto-added header.

HelpAlwaysRequired · Answer

Alright, bit of a new issue. I am working with Alteryx Designer x64, version 2023.1.1.392 Patch 7, if that matters any. I found a tutorial that seemed like it fit my problem: https://www.youtube.com/watch?v=Ped4gHyAZ5o&t=310s.

This is the workflow in Alteryx that the tutorial helped me make.

However, when trying to run this I get the following error:

HTTP/1.1 400 One of the HTTP headers specified in the request is not supported.
Content-Length: 294
Content-Type: application/xml
Server: Windows-Azure-Blob/1.0 Microsoft-HTTPAPI/2.0
x-ms-request-id: 7dgv6c58-801f-88t8-6f0f-g9y035000000 // masked the id
x-ms-version: 2022-11-02
x-ms-error-code: UnsupportedHeader
Date: Thu, 18 Jul 2024 12:37:47 GMT

Does anyone know how to resolve this?

HelpAlwaysRequired · Answer

Hi, thanks for the reponse. I'll look into this!