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.