question

VSHIVAM avatar image
0 Votes"
VSHIVAM asked MayankBargali-MSFT commented

Case Sentive issue while using Create SAS URI by path (V2) in Logic app

Hi I tried to use Create SAS URI by path (V2) for generating the SAS token URL to the file that is stored in the Blob storage.

I have used the triggerOutput field as shown below
131397-image.png



But when the WebURL is generated the url is generated ignoring the case sensitivity and I am not able to download the file with the generated WebURL link.


Please let me know how can I get the exact URL when the output filed "List of Files Id is used"

azure-logic-apps
image.png (15.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MayankBargali-MSFT avatar image
1 Vote"
MayankBargali-MSFT answered MayankBargali-MSFT commented

@VSHIVAM It looks like you are using When a blob is added or modified (properties only) (V2) trigger as I can see it returns the List of files blob meta data and using this output in your create sas uri by path (v2). Please confirm if my understanding is correct. If this is the case then create sas uri by path (v2) accepts the blob path where as you are passing the List of Files Id. You need to pass List of Files Path i.e. Path parameter that has the path of the file or folder of BlobMetadata.

131513-image.png


image.png (31.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the update @MayankBargali-MSFT

We have used this parameter "List of files path" it is giving us the complete file path including the folders that are stored in the Blob when WebURL is generated.

But as per our requirement we should not show the file path , so instead I tried to generate the SAS URI with List of Files Id, as a result I got the URL as below which is in accessible

https://xxxxxxxxxxxxxxxxx.blob.core.windows.net/jtjmbmv3y28taw52b2ljzxmtymlsbgluzyuyzm91dhb1dcuyzk5ldytnawnyb3nvznqrv29yzcteb2n1bwvudcstk0nvchkrkdiyks5kb2n4?sv=2018-03-28&sr=c&sig=8LWqYODUdgVk2lKG0kwldGuaqNjhSaDWDNEh6Xw91WA%3D&st=2021-09-13T08%3A53%3A48Z&se=2021-09-13T08%3A58%3A48Z&sp=r

So do we need to use only List of Files Path i.e. Path parameter instead List of Files Id in that case Logic app execution should be failed as the URL generated is not a valid one

I

0 Votes 0 ·

@VSHIVAM The Create SAS URL by path (v2) creats SAS link for a blob using the path and not at the container. The SAS URL generated by this action will only valid for the blob for which it was created and not for other containers/blobs. If you tried to use the same SAS link then you should get the AuthenticationFailed error.

If your requirement is that you want to generate the SAS token and used it for all blobs/contaniors level then you need to use Storage REST API to generate the token using HTTP triger.

If you still want only the SAS signature without the path/blob name then you can use substring to get your desire string format. But as I aleady mentioned that this SAS is only valid for the blob for which it was created and not for other containers/blobs.

0 Votes 0 ·