A Trigger in a
Connect iPaaS workflow serves as the starting point of the workflow. The conditions defined in this trigger will activate the workflow and create an action in the downstream application.
Connect iPaaS provides one trigger for Workday. The Workday trigger works as a Polling Trigger, enabling the workflow to retrieve data from CSV files at regular intervals from a specific directory.
Extract Records From New Or Updated CSV Files¶
It triggers your workflow when a CSV file is newly created, uploaded, or updated in the selected directory of your SFTP file system. Then it will split the CSV file into independent events for each record in the file and send it to the downstream action(s) for further processing.
Setting up Trigger for your Workflow¶
Once you select the trigger, there are four parts to set up this trigger.
- Polling Interval is the scheduled time interval between each scanning process of the selected directory for the target file.
- This shows the hierarchy of your 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.
CSV file name pattern
- You need to give the target CSV a filename that you are expecting the trigger to process. Beware the trigger is already in the ".csv" format, so no need to type ".csv" extension in the form.
Column Header fields
- You need to set up manually all of the values for the column header. In this way, the trigger can validate the file first and then break each record into an independent event. You can keep adding column headers by clicking on the plus button and delete the column header value you don't need by clicking on 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 Workday.
After you deploy the flow with this trigger, it starts to detect the target directory for the newly uploaded or updated CSV file. Once the trigger finds the target CSV file, it will split the CSV file into independent events for each row in the files and then send it to the downstream action application(s) for further processing.