MySQL - Scheduled query trigger
New/updated batch of rows via scheduled custom SQL
This trigger picks up rows that are returned from a user defined query which is run at an interval which is user defined. It is a batch action trigger and handles these returned rows in batches.
New/updated row trigger
|SQL||Custom SQL query to be executed at each poll interval to pick up new rows.|
|Schedule||Choose how often you want the SQL to be run.|
|Timezone||Choose the timezone for the schedule to be set in.|
|Hour||Configure the hour of the day you wish to execute the SQL query.|
|Minute||Configure the minute in the hour you wish to execute the SQL query.|
|Day of month||Configure the day of the month you wish to execute the SQL query.|
|Days of week||Select the days of the week you wish to execute the SQL query.|
|Batch size||Configure the batch size to process in each individual job for this recipe. This defaults to 100.|
Input field details
Provide the SQL to be executed to select rows. The SQL here will be used to generate the output datatree. To do this, the SQL will be executed once when you provide it. You can map datapills here to execute dynamically changing SQL statements. Remember to wrap datapills in quotes (
''). Be sure to include some
WHERE clauses which can help prevent retrieving rows you have already processed in an earlier job run if that is your intention. This can be done by qualifying rows based on their
created_at timestamp columns in your table.
select * from contacts where contacts.created_at between now() and now() + INTERVAL 1 DAY;
Avoid using limit clauses like
TOP in your SQL. This is because the limit to the number of rows returned in the query is based on the value defined in the Batch size input field. Adding your own limit clause will cause the action to fail.
Select the type of schedule you want for your integration use case. This input fields is a pick list with the following available choices:
Select the timezone for the scheduler to be set in. This is a required field.
Configure the hour of the day you wish to execute the scheduled SQL query. This is required only if you selected daily or monthly as the Schedule.
Configure the minute in the hour you wish to execute the scheduled SQL query. This is always required.
Day of month
Provide a value between 1 to 31 for the day of the month. In shorter months, the values may be rounded down to the last day of the month. For example: if you use the value 31 and the month ends before the 31st, the trigger will run the SQL query on the last day of the month (e.g. 28th Feb, 31st Mar, 30th Apr, and so on)
Needed only if you selected monthly as the Schedule. This is an optional field that defaults to first day of the month if left empty.
Days of week
Choose the days of the week you wish to execute the scheduled SQL query. This is required only if you selected hourly and daily as the Schedule. If you selected hourly, the trigger will execute the SQL hourly on days that are selected here.
Batch size of rows to return in each job. This can be any number between 1 and the maximum batch size. Maximum batch size is 100 and default is 100.
In any given poll, if there are less rows than the configured batch size, this trigger will deliver all rows as a smaller batch.