Hi.
One of our customers is getting some statistical data from PowerBI, and it's stored in CSV file in an Azure File Storage account.
I can open the URL in Azure Storage Explorer and download the file without any problem, but of course we need to do this in code, in PB2019.
The URL provided is at this format:
https://<accountname>.file.core.windows.net/<foldername>?sp=rl&st=2021-03-16T09:49:45Z&se=2049-12-31T23:00:00Z&sv=2020-02-10&sig=<signature/shared key>&sr=s
My plan is to use this URL in an HttpClient object and store the CSV file in the given folder.
There is no other authorization provided than the shared key (SAS - Shared Access Key).
I need to calculate some sort of Authorization Token using this key, but I cannot seem to figure it out.
Has anyone made this type of request work from PB2019?
Regards,
Bjarne
Maritech
Norway