Currently, Connect iPaaS provides two triggers for MFT.
Extract Records From New Or Updated CSV Files¶
The workflow will be triggered when a CSV file is newly created, uploaded or updated in the selected directory of your SFTP file system. The CSV file will then be split into independent events for each record in the file and the events will be sent to the downstream action(s) for further processing.
Get New or Updated Files¶
The flow will be triggered when any type of file is newly created, uploaded or updated in the selected directory of your SFTP file system.
Set up Trigger for your Workflow¶
Once you select an MFT trigger, the common parts are the polling interval and the directory selection UI as shown below:
This is a scheduled time interval between each scanning process of the selected directory.
This shows the hierarchy of your source SFTP file system. It will show the root path by default when you first select your trigger. And you can step into any directories that you choose. If you want to step out back to the parent directory, click the three little dot symbol which is outlined blue in figure 2.
Guide to set up the trigger "Extract Records From New Or Updated CSV Files"¶
Once you set up the polling interval and choose the target directory, you need to give a target CSV file name that you are expecting the trigger to monitor. Beware that the trigger already considers ".csv" as the extension, so no need to type ".csv" extension in the form.
Next step is to set up all the values of the column header which you find at the top row in your CSV file. The trigger can validate the file first and break each record into independent events.
You can keep adding column headers along with column header type by clicking the plus button and delete the incorrect column header value by clicking the minus button. Column header types are the datatype of the column header provided to the user that are string, numeric, and boolean. Refer to the screenshot below.
Please make sure the column headers you put are matching the header column in the CSV file. Connect iPaaS will reject the file if the headers in the actual file don't match the column headers defined in Connect iPaaS.
Followed by the event filters which allow you to choose the incoming trigger event's attributes to define the selection criteria of events to process. See Event Filters to learn more about event event filter in MFT.
Guide to set up the trigger "Get New Or Updated Files"¶
Once you set up the polling interval and choose the target directory, you need to provide that what kind of file are you expecting.
Connect iPaaS provides two options:
Common File Pattern
Select from a drop-down option with 13 common file extensions. For eg: Text File, CSV File, PDF file, etc. Whenever a file with the selected extension is created or updated, the trigger will be processed.
Custom File Pattern
If you don't find your option in the Common file pattern, you can create a regular expression to denote the file extension you want to process. And, whenever a new file with the matched extension is created or updated, the trigger will be processed.