Share via

using azure data factory to retrieve blobs urls from a container

youssef125 266 Reputation points
2021-12-13T08:54:22.487+00:00

I'm using Azure, I have some blobs in a container, what I'm looking for is to copy the urls of these blobs in a json file using azure data factory or data flow.

heres as example of a url :

157086-image001.png

the expected result is :

[{'ur':'urltObLOB1'},{'ur':'urltObLOB2'},{'ur':'urltObLOB3'},..... ]

is there a way to achieve that using azure data factory or data flow please ?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,850 questions
0 comments
Accepted answer
  1. ShaikMaheer-MSFT 38,301 Reputation points Microsoft Employee
    2021-12-13T14:29:12.347+00:00

    Hi @youssef125 ,

    Thank you for posting query in Microsoft Q&A Platform.

    Blob URLs will be having format as https://<storage account name>.blob.core.windows.net/<container name>/<folder path>/<file name>.

    So, you can consider below approach to frame your URL.

    GetMetaData activity to get file name form your dataset. and then use set variable activity to form your URL as per above format. You can consider concat() function to frame your URL.

    157139-image.png

    Below video help to give an idea about GetMetaData activity functionality.
    https://www.youtube.com/watch?v=_VNOabanIV4

    Hope this will help. Please let us know if any further queries.

    ---------------

    Please consider hitting Accept Answer button. Accepted answers helps community as well.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest