Is it possible to delete Files in blob based on a size

Question

I have around 10k files stored in a container. End goal is to merge them into a single file. But there are a lot of file with no data and just headers resulting in size being 50bytes. Is it possible in ADF (using delete activity) to delete all files that are less than 50bytes in size.

Answer 1

Hey,
You can try the below logic:

1. Use Get Meta Data activity to get the list of all files
2. Then use foreach activity and within for each activity, use Get meta data activity again for that individual file and get the file size
3. Use If activity to check whether the size is less than your ask and then use delete activity to delete that file

Note: This seems to be a crude way but the way which I can think of