ClockLap + Workday: people in sync from a worker report

Have Workday write a worker report (a custom report, or an EIB or Core Connector: Worker output saved as CSV). Upload it, or have it dropped on SFTP, and ClockLap keeps people in step.

HRFileCAUSGlobalBeta
Dry run before the first syncBeta

What syncs

Workday is the source of truth for people. On each sync ClockLap reads:

  • Workers: ID, name, work email, supervisory organisation, location, manager (by employee ID), hire and termination dates, status, hourly pay rate

Columns recognised without mapping include Employee_ID Primary_Work_Email Supervisory_Organization Manager_Employee_ID Hire_Date Termination_Date Worker_Status.

Time off. Time off balances aren’t read from a worker file, and approved time off isn’t sent to Workday.

How it works

  1. Create the worker report in WorkdayA custom report or an EIB / Core Connector: Worker output, saved as CSV.
  2. Upload it, or point ClockLap at SFTPHost, user, password or private key, folder and a name pattern like workers_*.csv; the newest match wins.
  3. Match columns onceStandard Workday columns are recognised automatically; anything else you map once and it’s remembered.
  4. Map supervisory organisationsTo ClockLap sites and teams.
  5. Review the dry runThen apply it, and schedule the sync.

Matching people

Matched by earlier links, then email, employee number and Workday worker ID.

  • Who wins, per field. The HR system by default: ClockLap is updated to match. Set any field to “ClockLap” and it’s only filled in when the person is added.
  • New people. Added automatically, without an invite unless you turn invites on. You choose the role they get.
  • People who leave. Suggested for turning off (default), or turned off automatically. Their history stays.
  • Sites and teams. Map the HR system’s locations or departments to ClockLap sites once; moves follow on every sync.
  • Single sign-on users. People your identity provider manages through SCIM keep what SCIM writes; the sync skips those fields and says so.
  • Schedule. Hourly, daily (default) or manual. A scheduled sync can apply itself or only prepare a preview for an admin.
A dry run first. The first sync is always a dry run: a list of the people who would be added, updated or suggested for turning off, field by field. Nothing changes until an admin applies it, and scheduled syncs wait for that first approval.

What you need

  • A Workday report that exports workers as CSV (UTF-8; comma, semicolon or tab separated)
  • Optional: an SFTP server Workday writes to, with a password or private key for ClockLap

Every run keeps a history: who and what was sent, per-line results, plain-language errors with a fix, and a redacted request log for admins. Webhooks fire on people_sync.completed.

Questions

Is this a direct Workday API connection?

No. It reads a worker file, which most Workday teams can schedule without an integration project. The SFTP host key is pinned on first connect.

What if someone’s termination date is in the past but their status says active?

A past end date wins: they’re treated as having left.

Is people sync included in the price?

Yes. HR connections are part of every ClockLap plan, with no add-ons.

Is ClockLap affiliated with Workday?

No. ClockLap connects to Workday using files it can import; it isn’t affiliated with or endorsed by Workday. The connection is in beta while we verify it with live accounts.

Clock in by arriving. Paid without retyping.

Try ClockLap free for 30 days with your own Workday account. No card needed.