filePath with Get Metadata

Question

Good morning,
How retrieve this access path with GetMetaData in Azure Data Factory(Data Flwos) :

folderPath": "myfolder/subfolder/pre/file.csv"?

Thank you

Answer 1

Hi Bazouzou, you have to first use lookup activity to read through the metadata and get file names iteratively from ForEach activity then pass inputs in to GetMetaData activity. Thanks

Answer 2

HI Samy,
Don't exist in field list : forlderPath

Answer 3

Hi Hi Bazouzou, the Copy and GetMetaData activity would not give file path directly.

Please go through below post , for the possible workarounds:

https://stackoverflow.com/questions/64431813/dynamically-grab-filepath-from-azure-data-factory-copy-activity-output

https://stackoverflow.com/questions/59505781/getmetadata-to-get-the-full-file-directory-in-azure-data-factory

Thank you.