Connect Workday to Pigment and keep headcount plans current
Bring headcount and compensation data from Workday reports into Pigment on a schedule you set, so workforce plans start from the latest numbers. HR leaders get a headcount plan that keeps pace with hiring and attrition, and Finance gets workforce costs it can trace to Workday.

Workday
Send Workday custom report data to Pigment on a schedule for headcount and workforce cost planning
Category
Integration method
Best for
Headcount planning · Workforce cost forecasting · Compensation modeling
What can you do with Workday and Pigment?
- Track headcount against plan each month. An HR planning lead schedules a monthly Workday run, then compares actual headcount to plan in Pigment.
- Start comp planning from current figures. A compensation manager adds pay fields to the report, then builds next year's comp plan from the latest Workday data
- Bring attrition into the cost forecast. A Finance leader asks HR to add terminations to the report, so each import updates the forecast with real departures
- Refresh numbers before a budget review. An HR systems admin runs the Workday job on demand, so leadership reviews the plan against that morning's headcount
How the Workday integration works
In Workday, you build a custom report with Report Writer and turn on “Enable as web service.” An outbound Enterprise Interface Builder (EIB) outputs that report as CSV and delivers it over HTTP/SSL to Pigment’s import endpoint.
In Pigment, a Workspace Admin creates an Import API key, which the EIB uses as the user ID for Basic Auth. A user with the Import Data permission imports a sample CSV once into a List or Metric and saves the mapping as an import configuration. Its ID goes into the EIB’s delivery URL. This setup imports data into Pigment and doesn’t write back to Workday.
Key capabilities
- Choose fields with a custom report. Build the report from scratch or copy a Workday standard report HR already uses. Fields you leave out stay in Workday.
- Set the refresh cadence in Workday. Pick a run frequency, such as monthly recurrence, and Workday sends the report automatically.
- Map once, reuse every run. The import configuration saved from your sample CSV tells Pigment how to read each later file, so nobody remaps columns.
- Control what the report can read. Reports can run under an Integration System User (ISU) with its own Workday security profile.
- Limit when and where keys work. Each Import API key has an expiration date, and Workspace Admins can add an IP allow list.
- Diagnose import problems. A failed import in Pigment points to the import configuration. If no import appears at all, check the Workday side.
- Split setup between Workday and Pigment. Workday admins own the report and EIB, while Pigment admins issue the key and build the import configuration.
Frequently Asked Questions
What Workday data can I import into Pigment?
Pigment imports whatever your Workday custom report contains. Your team decides the fields, such as headcount, position, or compensation data, when it builds or copies the report in Workday Report Writer.
How often does Workday data refresh in Pigment?
You set the frequency in the EIB's Launch / Schedule settings in Workday, such as a monthly recurrence. Workday then sends the report to Pigment automatically, and you can choose Run Now whenever you need an extra update.
Do I have to remap the Workday import every cycle?
No. You import a sample CSV into Pigment once and save the mapping as an import configuration. Every scheduled push from Workday uses that configuration, as long as the report keeps the same headers and delimiter.
Can Finance work with Workday headcount data without Workday access?
Yes. Once the import runs, the report's data sits in a Pigment List or Metric, so Finance can work with it without needing Workday access. Your Workday team controls what reaches Pigment through the report’s fields and the ISU’s security profile, if you use one. Within Pigment, access rights control who sees the data.
Related integrations
See Pigment in action
The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

From 8 days to 4 min
Update P&L actuals & financial forecasting
80%
Time cut on data aggregation
12 hours
Saved per month on executive reporting
6 days faster
For scenarios creation and analysis