When using SharePoint Input I used a wildcard ("*") to allow for file name variations due to the existence of a version number in the source file name. There is a subfolder in the SharePoint input file folder to hold an archive of the previous version files; the goal is to NOT ingest the files in the archive subfolder.
Unfortunately the use of the wildcard is pulling all matching file names, including the files in the archive subfolder. To create the wildcard I started with an actual input file name and then manually modified the "File Path" to replace the variable text with a wildcard as is done with an Input Data tool.
If I move the archive folder up in the folder tree so that it is a sibling of the input folder instead of a subfolder of it, then it obviously does not pick them up, but it is preferred to have the archive folder as a subfolder of the input folder itself.
With the SharePoint Input is the function by default to search subfolders as well when wildcards are used or is there a way to stop this from happening? Thank you for any guidance and assistance.
