Creating BMC Helix ITSM People records from Workday user records by using Jitterbit Harmony - Documentation for BMC Helix iPaaS
Daniel Cobb
(Optional) Task 6: To define a schedule to run the template
You can define a schedule to run the template automatically.
- In Workflows, select 1.0 Entry logic > Initial Data Load.
- Click ... and then click Settings.
- On the Schedules tab, complete the following fields:
- From the CONDITION list, select On Schedule.
- From the SCHEDULE list, select an existing schedule that suits your requirement.
- (Optional) If the existing schedules do not suffice, click Create New Schedule, complete the steps to create the schedule
and then repeat step 1 to step 3b.
- Click Assign.
To update the ReadCache function
The ReadCache function stores the date till which the Workday user records are fetched. By default, the ReadCache value expires every 1800 seconds. If you set a schedule, make sure that the time specified in the schedule is also added in the ReadCache function in seconds.
For example, if you set a schedule to fetch records every 30 days, add 2592000 (time in seconds for 30 days) in the ReadCache function.
To add the schedule time in ReadCache, perform the following steps in the template:
- In Workflows, select 1.0 Entry Logic > 1.0 Initial Data Load.
- On the design canvas, on the Initial Data Load element, click the ellipses ..., and then click View/Edit.
- In the script, navigate to the following function:
$Effective_from=ReadCache("lastModified"); - Add the schedule time in seconds in the following format:
$Effective_from=ReadCache("lastModified", "expirationseconds");
For example, enter $Effective_from=ReadCache("lastModified", "21600"). - To go back to the template, click Return to workflow
.
For more information about ReadCache, see Cache functions in the online Jitterbit documentation.