Workday scheduled report trigger
How to use
This trigger is a combination of a Scheduler (advanced) and Workday RaaS action. When configured, it will run a report in Workday at pre-defined times and return results of the report in batches. The batch size limit is
The required inputs are naturally a combination of both the Scheduler trigger and Workday RaaS actions. First, provide a valid RaaS JSON URL. Refer to documentation about configuring Workday reports here.
Next, configure the schedule. Refer to documentation about configuring the advanced scheduler trigger here.
Scheduled report input
This trigger returns a number of fields:
- Scheduled time
- Total number of records
- Starting offset
- Ending offset
- First batch
- Last batch
This datapill tells you the time that the report was ran.
Total number of records
This datapill tells you the total number of rows generated in the scheduled run of the report. If this report has more than 200 rows, they will be split into batches of 200 rows per batch. Each batch will then be processed as individual jobs, in the same sequence as returned by the Workday RaaS endpoint.
Starting offset/ending offset
These 2 datapills are used to indicate the number of rows offset for this batch. For example, if there are a total of 1000 rows and the current job is on the 2th batch (rows
500), the Starting offset will be
200 and ending offset will be
First batch/last batch
These 2 datapills are boolean fields which indicate whether the batch is the first/last batch. This is useful in scenarios where you want to create a file from the output of a Workday report. Your recipe will contain the following logic:
First batch is
create a new file with contents of the first batch
First batch is
append lines to an existing file
Last batch is
Send notification about successful transfer of report content
Each batch of rows is returned as a list (array). Each item in this list corresponds to a row in the report. Similarly, each column in your report will be rendered as a field in the output datatree.
Scheduled report output