A comma-separated list of filters to include from the set of files.

Data Type

string

Default Value

"*"

Remarks

This connection property only takes effect if the URI connection property is set to a folder, rather than a workbook file.

The URI and IncludeSubdirectories connection properties determine which folders the server sources workbooks from when listing metadata.

By default, all workbooks in the specified folders are used to calculate metadata.

However, using this connection property, you can refine this list further to only include certain workbook files based on filters. If you want to use multiple filters, you can provide them in a comma-separated list.

Supported filters include:

• Filename filters (wildcards supported). For example, October*.xlsx includes all .xlsx files whose names start with "October".
• Creation date filters. The syntax for these filters is CreatedDate<comparison operator><timestamp>. For example, CreatedDate<=2020-11-26T07:39:34-05:00 includes all workbook files created before November 26th 2020.
• Modified date filters. The syntax for these filters is CreatedDate<comparison operator><timestamp>. For example, ModifiedDate<=2020-11-26T07:39:34-05:00 includes all workbook files modified before November 26th 2020.

The server also supports the use of DATE Functions to calculate portions of date filters. For example:

ModifiedDate>=DATETIMEFROMPARTS(2020, 11, 26, 7, 40, 49, 000),ModifiedDate<=CURRENT_TIMESTAMP()