Skip to main content
All CollectionsPlatform setup
Workday HRIS integration (Custom reports)
Workday HRIS integration (Custom reports)

How to customize my Workday integration?

David William avatar
Written by David William
Updated yesterday

Prerequisites

Ensure you are an admin of your Workday account before starting.

  1. Log into Workday

  2. Search for "View API Clients"

  3. If you can not see this menu item, you are not an admin of the Workday account.

  4. If you do not see this menu item, figure out who your Workday Admin is and ask them to give your account sufficient permissions or to take over the integration process.

Create an integration system user (ISU)

  1. Click on the "Search" field at the top and enter "Create Integration System User"

  2. Click on the task "Create Integration System User" that just appeared

    Workday_create_ISU.png

  3. In the dialog that just opened, enter a username and generate a secure password.
    You can leave the other fields untouched

  4. At the bottom of the dialog, click "OK"

    Workday_configure_ISU.png

Add the ISU to your list of system users

While the newly created ISU will work for linking your Workday account its password will expire after some time unless you add it to your list of system users.

Create a security group and assign the ISU to it

  1. Click on the "Search" field at the top and enter "Create Security Group"

  2. Click the task "Create Security Group" that just appeared

    Workday_create_security_group.png

  3. On the page that just appeared locate the dropdown "Type of Tenanted Security Group" and select "Integration System Security Group (Unconstrained)"

  4. For the "Name" enter the value of the "User Name" when creating the ISU earlier (in this case it would be test_isu, but yours will be different)

  5. At the bottom of the page, click "OK"

    Workday_configure_security_group.png

  6. On the next page, the only thing you have to do is go to the field "Integration System Users" and add the user you created earlier. You can do this by clicking on the field and typing in the name of the ISU (in this case test_isu)

After that, go ahead and click "OK"

Workday_edit_security_group.png

Add the required permissions to the security group

  1. Click on the "Search" field at the top and enter "Maintain Permission for Security Group"

  2. Click on the task "Maintain Permission for Security Group" that just appeared

    Workday_maintain_permissions_of_security_gruop.png

  3. In the window that just appeared, make sure you have the option "Maintain" selected

  4. Click the field "Source Security Group", enter the name of the group (in this case test_isu) and hit enter. Then click on the security group to select it.

  5. Click "OK"

    Workday_select_security_group_to_maintain.png

  6. Add the Domain Security Policy: "Worker Data: Current Staffing Information" with "Get Only" access:

  7. Click on Done at the bottom

Activate your changes

After making any changes to your Workday security policy settings, make sure to apply those changes by executing the "Activate Pending Security Policy Changes" task. Without that, none of your changes with take effect.

  1. Click on the "Search" field at the top and enter "Activate Pending Security Policy Changes"

  2. Click on the task "Activate Pending Security Policy Changes" that just appeared

    Workday_activate_pending_security_changes_task.png

  3. In the window that just appeared, add any comment for applying the changes (i.e. "Grant ISU test_isu necesssary permissions for integratons"

  4. Click "OK"

    Workday_activate_pending_security_task_comment.png

  5. In the new window, check the box "Confirm"

  6. Click "OK"

    Workday_activate_pending_security_policy_changes_confirm.png

How to create a ( webservice ) custom report?

  1. Find the right Task to Create Custom Report

  2. Give your report a descriptive name

  3. Choose Advanced as your Report Type

  4. Enable it as a Web Service so we can access it later

  5. Disable the optimization toggle so we can explore more fields

  6. Search for “All workers” and press enter

  7. Verify your settings

  8. Create your report by pressing OK

  9. You should get redirected to the Edit Custom Report page

How to setup the custom report?

Optional: Open the custom report to edit it

  1. Search for Edit Custom Report

  2. Find the custom report you want to edit in the context menu

  3. Press OK to open the custom report

The basics ( tables, search )

  1. In the view you open you will find two tables.

  2. In the first one you will be setting up the basic fields of the report. We will refer to it as the Business Object Table

  3. You can easily find any business object and field by searching it. To search it first enter the value and then confirm your search and press enter.

  4. This search works for every Field and Business Object in the report and will help you set it up quickly.

  5. We will call the table at the bottom the Overrides Table

Business objects table

  1. Now you can open the connection flow and check which fields are required in your report:

  2. For every required field, please find the correct Business Object, Field and based on our guidelines enter the correct Column Heading Override XML Alias.

  3. The complete Business Object Table would look like in the image below given the fields described in the connection flow:

Overrides table

  1. Once you finished the Business Object Table you will have to map some fields from other entities

  2. The final table would in this case look like this:

Enable sharing

So that we can access the custom report you will have to setup the user for it.

  1. Go to the Share tab

  2. Choose Share with specific authorized groups and users

  3. Find your user and group that you created before

  4. Save your report

Get the link to the report

  1. Open your custom report.

  2. Click those dots to access actions

  3. Go to Web Service > View URLs

  4. Click on JSON and send us the link that opened


Did this answer your question?