filePath with Get Metadata

Ziani_Az 21 Reputation points
2021-08-26T07:27:57.793+00:00

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

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

Thank you

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,477 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,765 questions
0 comments No comments
{count} votes

Accepted answer
  1. Samy Abdul 3,366 Reputation points
    2021-08-26T07:38:04.49+00:00

    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


2 additional answers

Sort by: Most helpful
  1. Ziani_Az 21 Reputation points
    2021-08-26T09:30:51.443+00:00

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

    126677-image.png

    0 comments No comments

  2. Samy Abdul 3,366 Reputation points
    2021-09-01T10:30:36.343+00:00

    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.

    0 comments No comments