Skip to content

ADP Triggers

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.

Currently, Connect iPaaS provides one vital Trigger for ADP. The ADP trigger works as a Polling Trigger, enabling the workflow to retrieve data from CSV files at regular intervals from a specific directory.

ADP Trigger

Figure 1. Trigger for ADP Application on Connect iPaaS

Extract Records From New Or Updated CSV Files

The 'Extract Records From New Or Updated CSV Files' trigger activates your workflow when a new CSV file is created, uploaded or updated in the selected directory of your SFTP file system. It will split the CSV file into independent events for each record in the file and send the data 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

  • Polling Interval is the scheduled time interval between each scan of the selected directory for the target file.

Directory UI

  • This shows the hierarchy of your SFTP file system.
  • It will show the home directory 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 a RegEx expression or name of the ADP extract file so the file listener knows what file it needs to listen for. Beware that the trigger already considers ".csv" as the extension, 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 ADP.

ADP Triggers - Extract Records From New Or Updated CSV Files

Figure 3. The set up for ADP Triggers "Extract Records From New Or Updated CSV Files"

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 to the downstream action application(s) to process.