Create file filtering conditions for FTP exports

You can set file filtering conditions to define the filename and size characteristics of files in the source FTP server to transfer into your flow.

If you don't provide any file filtering conditions, then integrator.io will export all files located in the directory path you defined for the export.

Click Add condition or Add conditions group to configure settings for your export transfer. You can also add multiple conditions and groups of conditions that will behave according to the Boolean operator settings you define.

1. Boolean selector: AND is enabled by default, meaning that if you add multiple conditions, all configured conditions must be met for the file to be transferred from the source. 
2. File name: Select File name if the file(s) you want to export must have certain filename characteristics. 
3. File name operator: Apply any of the following conditional operators to the filter:

   • contains: Filters by filenames that contain the specified string (case-insensitive). For example, if your operand is “Order”, the filter returns “LastOrder”, “Firstorder”, and “order123”.

   • does not contain: Filters by filenames that do not contain the specified string (case-insensitive). For example, if your operand is “Order” the filter excludes “LastOrder”, “Firstorder”, and “border123”.

   • equals: Filters by filenames that exactly match the specified string (case-sensitive). For example, if your operand is “Order123”, the filter returns only “Order123”, not “FirstOrder123” or “order123”.

   • not equals: Filters by filenames that do not exactly match the specified string (case-sensitive). For example, if your operand is “Order123”, the filter excludes only “Order123”, but does not exclude “FirstOrder123” and “order123”.

   • starts with: Filters by filenames that start with the specified string (case-insensitive). For example, if your operand is “Order”, the filter includes “Order123” and “order345”, but does not include “FirstOrder123” and “border456”.

   • does not start with: Filters by filenames that do not start with the specified string (case-insensitive). For example, if your operand is “Order”, the filter excludes “Order123” and “order345”, but does not exclude “FirstOrder123” and “border456”.

   • ends with: Filters by filenames that end with the specified string (case-insensitive). For example, if your operand is “Order”, the filter includes “123Order” and “345order”, but does not include “Order123” and “border456”.

4. Operand string: The string referenced by the operator.
5. File size: Select File size if the file(s) you want to export must meet certain file size characteristics. 
6. File size operator: Apply any of the following conditional operators to the filter:
   • equals: Filters by file sizes that are equal to the specified size (in bytes). For example, if your operand is 50 and your file size units are set to KB, the filter returns any file that has a size that is equal to 50 KB. If your operand is 10 and your file size units are set to MB, the filter returns any file that has a size equal to 10 MB.
   • not equals: Filters by file sizes that are equal to the specified size (in bytes). For example, if your operand is 50 and your file size units are set to KB, the filter returns any file that has a size that is not equal to 50 KB. If your operand is 10 and your file size units are set to MB, the filter returns any file that has a size that is not equal to 10 MB.

   • is greater than: Filters by file sizes that exceed the specified size (in KB or MB). For example, if your operand is 50 and your file size units are set to KB, the filter returns any file that has a size greater than 50 KB. If your operand is 10 and your file size units are set to MB, the filter returns any file that has a size greater than 10 MB.

   • is greater than or equals: Filters by file sizes that are equal to or exceed the specified size (in KB or MB). For example, if your operand is 50 and your file size units are set to KB, the filter returns any file that has a size equal to or greater than 50 KB. If your operand is 10 and your file size units are set to MB, the filter returns any file that has a size equal to or greater than 10 MB.
   • is less than: Filters by file sizes that do not exceed the specified size (in bytes). For example, if your operand is 50 and your file size units are set to KB, the filter returns any file that has a size less than 50 KB. If your operand is 10 and your file size units are set to MB, the filter returns any file that has a size less than 10 MB.
   • is less than or equals: Filters by file sizes that are equal to or less than the specified size (in bytes). For example, if your operand is 50 and your file size units are set to KB, the filter returns any file that has a size equal to or less than 50 KB. If your operand is 10 and your file size units are set to MB, the filter returns any file that has a size equal to or less than 10 MB.
7. Size value and units of measurement: Enter the size value in the first field and select the units of measurements from the next field. You can select Bytes, KB MB, GB, or TB.