Store files in Azure storage

As there is currently no option to connect to Azure Storage, would it be possible to use an external library like https://cdn.jsdelivr.net/npm/@azure/storage-blob@12.14.0/dist/index.min.js ?

Or is it not possible because of 'require' in the script (in a mobile app)?

If possible, how would I reference to the library within a JS Query?
I've added it now here:
image

Hey @mbruijnpff!

Like you mentioned, you currently need to use the UMD build of a JavaScript library with Retool. The current workaround I know of for interacting with Azure Storage is to use their REST API - is that something you've explored already?

(Our docs on connecting to REST API's are here for anyone who's curious!)

OK, I will give that a try. Forgot about that possibilty.

I am trying to do this now and running into a documentation wall. is there any decent walkthrough on how to set this up?

Hey @Shegs, I don't believe we have a specific walkthrough for this. What blockers are you hitting?

just getting the API to work. its a million steps and requires SHA256 encryption of signatures and multiple steps to just create files and I just can't get it to work with the convoluted documentation at MS.

I was able to get a response from the API using Shared Access Signature, but now I am unable to get the binary data of an image to send.
when using base64 data results as a binary body in the API.
error: Cannot destructure property 'data' of 'e' as it is undefined.

Anyone that has done this, I would like to pick your brain a bit.

Having similar issues, struggling to find much about it here in the forums. Posted here too: Azure Storage Account REST API Endpoints. I'm simply trying to send a PDF (passed from a file import component to a workflow) to Azure Storage, but it's getting all fouled up in the middle somehow.

Have you found any solutions to send the right information in the body?

1 Like

I've been sitting on this draft for way too long - in case future travelers come upon this thread, just want to share that my solution was to import the Azure Storage SDK for Python (Azure Storage Blobs client library for Python | Microsoft Learn) and use that. :snake:

1 Like

Adding on another possible workaround:

I use an SSIS package (using the Azure nodes provided by MSFT) that handles Azure blob file processing which is triggered via a call to a stored procedure through Retool. It allows an app or module to be a step to prepare backend DBs to process new changes on Submit (which could be used to store base64 data to then send up to Azure containers).

1 Like