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 defaults to
200 and maximum size is
The required inputs are naturally a combination of both the Scheduler trigger and Workday RaaS actions.
First, configure the Workday report to retrieve.
- Provide the RaaS report URL of the Workday report. Click here to learn how to retrieve the RaaS URL.
- If the report requires inputs (e.g. filter parameters), additional input fields will be generated. Find out more about input configuration here.
- Configure output batch size using the Report batch size input field. Use this to adjust the size of each batch of rows to match the size limit of other actions in the recipe. Batch size default to
200and can be increased up to
Second, configure the scheduler.
- Refer to documentation about configuring the advanced scheduler trigger here.
Scheduled report configuration
This trigger returns a number of fields:
|Scheduled time||The time that the report was ran.|
|Total number of records||The total number of rows generated in the scheduled run of the report. If this report has more rows than the specified batch size, they will be split into multiple batches with the specified number of rows in each. Each batch will then be processed as individual jobs, in the same sequence as returned by the Workday RaaS endpoint.|
|Starting offset||The offset number for the first row of this batch. For example, if there are
|Ending offset||The offset number for the last row of this batch. For example, if there are
|First batch||A boolean value indicating if this is the first batch.|
|Last batch||A boolean value indicating if this is the last batch.|
|Rows||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.|
Using first/last batch in your recipe logic
You can use the values from first batch and last batch and integrate them into your recipe logic. For example, this is useful when 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