How to copy only .csv files from a folder to azure blob . The folder is containing another folder inside and .csv files

Question

HI,
I have an adf copy activity pipeline which is copying files from aws S3 bucket to azure blob. Now the S3 bucket has a folder A and inside folder A there are 10 .csv files and another folder B which is again having 3 .csv files. I want to copy only 10 .csv files inside folder A and want to skip folder B. I tried wild card as -

But this is not working because i believe sionce the folder B inside folder A also containing 3 .,csv files that's why wild card is picking up 10 .csv files from folder A and also folder B with 3 .csv files. I want to pick only 10 .csv files from folder A. Hope my question is clear. Please suggest a way to achieve this .

Answer 1

Hey,
You can use Get Meta Data activity and get the child items :

In child items filter for type=file and then iterate it in for loop