Download The Workday App LINK
Carlie Bhairo
To help protect against potential hiring scams, please be aware that all email communications from the Workday team and/or hiring managers will come only from an @workday.com email address. Our assessment process includes multiple phone and/or video or in person interview rounds, and we will never ask you for personal payment, require you to purchase equipment, or extend a job offer without the completion of this interview process. If you are unsure about the validity of a Workday job posting on another website, we strongly encourage you to instead apply directly through our website.
This can be used to make daily automations that act differently on workdays than non-workdays. For example, you could make your bedroom lights turn on (gently) at 7 in the morning if it is a workday but wait until 11 if it is a non-working day.
Take note of the holiday keyword. Your first instinct might be to add it to the exclude configuration, thinking it means skipping the holidays. But it is meant to exclude the days in the holiday list from the workdays. So, when you exclude holiday and a workday falls on that day, that workday is excluded, and the sensor will be off. If you want every workday flagged with no regard to holidays, ensure that there is something in your Excludes configuration other than holiday.
We did this implementation for many clients. Once you got all the setups and creds on workday side, you connect to their DB and recreate the workday tables in the OS as custom tables (select * into...). Essentially you use connector BR that feeds the data into the respective data source.
Please pay attention to the parameters you need to call (for example for the terminated employees table). Sometimes you need them sometimes you don't. A workday admin will usually provide you with the list of the links to every particular table including required parameters and their format.
Pay very close attention to the date formats in parameters (as mentioned above), case used (workday is painfully case sensitive) and underscores "_" in the table names that you will be querying. They might be weird and sometime double, which isn't always apparent to a naked eye
Other than that, the scope and solution to workday integration is much more that can be covered in community thread. But to give you the general idea, for the sake of good coding principles (separation of concerns primarily) a data management sequence calls an extensibility business rule, which in turn executes connector business rule, that references finance BR library.
The problem with 'workdays' is that they tend to have some specificty to your geographic region and even your specific company. I'm in the US and work for a bank, so there are about a dozen weekdays throughout they year that shouldn't get counted as 'workdays' if I was building something like an analytics process to track projects.
I would consider inputting a calendar datasource (make your own in excel if you have to, then input it to Alteryx) that had full identification of each day as a workday or not and then you could blend that and use it for a more precise calculation.