Reading files from Azure Storage Account

Recently for a particular use case I needed to read a json file stored in my Azure blog account from SquaredUp to build dashboard on that data.

Simple steps:

Go to your file in the storage account > right click > generate SAS key.

Set expiry and the protocol.

You will get two keys - Blob SAS token and Blob SAS URL.

Copy the URL.

In SquaredUp, set up a WebAPI data source, and in the base URL, paste the SAS URL that you copied. Hit enter and that’s it. It should read your json file.

I haven’t tried for a .csv file yet, but it should work. Feel free to share your results!