--- title: "How to export data from Workday to Pigment" slug: "export-workday" description: "Learn how to transfer data from Workday to Pigment with a three-step process, including custom reports and automated updates for seamless integration." tags: ["Automated Reporting", "Importing Exporting Data", "Pigment Data Transfer", "Workday Integration"] updated: 2025-05-30T13:33:49Z published: 2025-08-22T11:56:47Z --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.pigment.com/llms.txt > Use this file to discover all available pages before exploring further. # How to export data from Workday to Pigment ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(10).png) This article details the process of transferring data from Workday directly into Pigment and configuring an automatic data update based on a desired schedule. ## Building a Setup Transferring data from Workday into Pigment is a three-step process: 1. Build a `Custom Report` in Workday that includes the data you want to send to Pigment. 2. Build an Enterprise Interface Builder (EIB) in Workday which will connect the Workday report to a Pigment Block. 3. (Optional) Create an `Integration System User (ISU)`. ## Build a Custom Report in Workday Custom reports are built with the **Workday Report Writer**tool. There are two ways of creating one: 1. From scratch by using the `Create Custom Report` task 2. From a copy of an existing Standard report by using the `Copy Standard Report to Custom Report` task Make sure to activate the option "Enable as web service" to use the report in an EIB later. Go to the report’s Advanced settings to do it. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/3a316067-0751-4fa5-bcbb-d39fb19e41cb.png) ## Build an Enterprise Interface Builder (EIB) in Workday To create an EIB, use the Task `Create EIB` and select "Outbound” ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/88f7a978-933c-4cd6-9fe7-8d38f860d2af.png) In the "Get Data" step, select "Custom Report" then select the report you want to integrate *(note that if you forgot to enable the "Web service option" on your report you won't be able to find it).*In Details > "Alternate Output format", please select "CSV". ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/fd0bf0f6-7bac-43c9-a2bb-a412c6e76fb4.png) In the "Transform" step, do nothing and click next. In the "Deliver step", this is the configuration required: - *Delivery method*: HTTP/SSL - *HTTP Address*: put Pigment API URL with the API token as query parameter. - API URL template: `https://pigment.app/api/import/push/csv?configurationId={CONFIGURATION_ID}` - Replace **{CONFIGURATION_ID}** by a Pigment Configuration ID, follow [this tutorial](/v1/docs/generate-import-config-id) to learn more - Your final URL should look like this: `https://pigment.app/api/import/push/csv?configurationId=33d0d7d0-6125-47c4-b36a-882f4ed53b33` - *Web service Invocation Type:* Basic Auth - *User Id*: input a Pigment Import API Key, follow [this tutorial](/v1/docs/manage-api-keys) to learn more. - *Password:* enter anything in there. - *File Name:* leave blank ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/22505215-5526-4b7c-a3e7-60efdbdbe833.png) Once your EIB integration is created you can launch it to see if it works. Open the EIB you just created and click on "Action">"Integration" > "Launch / Schedule" ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/4960974b-0f83-405d-8ab3-c52576797e5d.png) ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/db991bb5-9fd0-4900-b49f-0a7a621c4135.png) Select "Run Now" and launch the EIB. **Your data should now appear in Pigment!** > [!NOTE] > ℹ️ **Note** > > If your data doesn't appear in Pigment, check the History Update panel: > > - If you see a failed import, it means that the data has been correctly sent to Pigment. You may need to adjust your import Pipeline configuration. > - If you don't see any import: it means that Pigment didn't receive the data. Double-check on the Workday side if the "API URL" is correct and if the EIB has run correctly. ## Schedule an automated export Open the EIB you just created and click on "Action">"Integration" > "Launch / Schedule". Then in "Run Frequency" select the desired frequency. For this example, we will take "Monthly Recurrence". ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/874ff9d5-71d8-4655-8620-d622c72e9fc9.png) Fill in the different information requested and Save. Thanks to this configuration, now Workday will automatically send this report to Pigment at the frequency chosen. ## (Optional) Create an Integration System User (ISU) We also recommend using an `Integration System User (ISU)` to run your Custom report. This way you can run it with different security profiles. Here are the steps to follow: 1. Create an Integration System User using the `Create Integration System User` task. Add this ISU to an existing `Integration System Security Group` (ISSG) or create a new one. 2. Using the `Maintain Password Rules task`, add this ISU account to the System Users exempt from the password expiration list 3. Update the relevant domain security policies so that the security group gets access to integration permissions 4. Activate pending security policy changes 5. Share the report with authorized users including the ISSG/ISU