List files in a folder by extension

Lists only files whose names match the given extensions (e.g. .csv, .txt, .dat). Use the Filter parameter with a JSONPath expression that filters by .tag and name pattern.

SELECT *
FROM list_files
WITH (Path='/myfolder'
     ,Filter='$.entries[?(@[''.tag'']==''file'' && @name=~/(\.csv|\.txt|\.dat)$/)]')