Workday Reports

Laatst bijgewerkt: 20-10-2026

Workday is a cloud-based enterprise resource planning (ERP) platform that provides human capital management, financial management, and analytics capabilities. Workday Reports (Report-as-a-Service) is a Workday feature that exposes custom reports as web service endpoints, making report data available for external consumption via API.

Workday Reports integration replicates data using the Workday RaaS Public Web Services API. Each report you configure becomes its own dataset in the destination.

See the Schema section for a list of objects available for replication.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Zorg dat het account dat u gebruikt leestoegang heeft voor de tabellen die u wilt ophalen.

The connector supports two authentication methods:

Client Credentials (default): Use a Workday integration account and the existing username and password flow.
Authorization Code: Use the OAuth browser-based sign-in flow to authorize the connection.

To set up your Workday Reports account, you need:

A Workday tenant with one or more custom reports to replicate.
Each report must be enabled as a web service in Workday.
Permission to run the Register API Client task in Workday, or a Workday administrator who can run it for you.
A Workday user name and password with access to run each report, or a Workday integration account to use with the Client Credentials flow.
The web service URL for each report.

To enable a report as a web service:

Log into your Workday account.
Search for and run the Edit Custom Report task for the report you want to replicate.
Open the Advanced tab.
Select Enable As Web Service.
Save the report.

To register the Workday API client:

Log into your Workday account.
Search for and run the Register API Client task.
Use the Register API Client task, not Register API Client for Integrations. Only the first task supports the redirection URI required by the Qlik sign-in flow.
Enter a Client Name, such as Qlik Talend Cloud.
Set Client Grant Type to Authorization Code Grant.
Set Access Token Type to Bearer.
Set Redirection URI to https://connector.qlik.com/auth/oauth/v3.htm.
Select the Scope (Functional Areas) that cover the data you intend to replicate. Select the functional areas corresponding to the Workday modules that you need. If you do not grant a scope, the matching tables are excluded from discovery.
Save the task. Workday displays the Client ID and Client Secret once. Copy and paste them into a secured file.

To get the report URL:

Copy the JSON web service URL from the report's web service definition in Workday. The URL has the following form:

https://<host>/ccx/service/customreport2/<tenant>/<owner>/<Report_Name>

The host must use HTTPS and end in workday.com or myworkday.com. For example:

https://wd2-impl-services1.workday.com/ccx/service/customreport2/mytenant/owner/MyReport
https://wd5-services1.myworkday.com/ccx/service/customreport2/mytenant/owner/MyReport

Creating the connection

For more information, see Verbinding maken met SaaS-applicaties.

Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
TipYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	Selecteer een Data Movement gateway als dit is vereist voor uw usecase. Informatie Dit veld is niet beschikbaar met het Qlik Talend Cloud Starter-abonnement, omdat het geen ondersteuning biedt voor Data Movement gateway. Als u een ander abonnementsniveau hebt en Data Movement gateway niet wilt gebruiken, selecteer dan Geen. Raadpleeg Qlik Gegevensgateway - Gegevensverplaatsing voor informatie over de voordelen van Data Movement gateway en usecases waarvoor deze is vereist. Optional.
Start Date	Voer de datum in, in het formaat `MM/DD/YYYY`, vanaf wanneer de gegevens van uw gegevensbron naar uw doel moeten worden gerepliceerd.
Authentication Method	Select the authentication method to use: Authorization Code or Client Credentials.
Host Name	API hostname, such as wd2-impl-services1.workday.com. Enter the host name only, without https:// or a path.
Tenant	Tenant name, such as company_1.
Client ID	Client ID.
Client Secret	Client secret.
Report Name	Enter one or more reports to replicate. Add a row per report; each row requires the following fields: Report Name (required): A unique name for the report within this connection. The report name is used as the dataset name in the destination. Report URL (required): The JSON web service URL for the report. Informatie If a report's name changes, the change is not reflected in an existing task. Create a new task to replicate the report under the new name.

Limitations and considerations

Different Workday users customize their reports differently, so treat each report's schema as unique.
If the configured Workday account loses access to a report or its underlying data, that report will return fewer columns, return no rows, or fail.
Reports that are not enabled as a web service in Workday cannot be replicated.

Do not change the authentication method for a connection associated with an active task. Create a new task with the other authentication method instead.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

For every report you configure, the available fields are determined by the data points defined in the Workday report. If a field you expect is missing, verify that the report in Workday includes that field.

Datasets and columns are generated dynamically. Because Workday reports are customer-defined, there is no consistent output across reports or tenants.
Reload only. Reports are replicated in reload (full table) mode. Each run re-reads the report's current output in full; incremental replication is not available.
A primary key is required. Qlik Talend Cloud does not assign a primary key automatically. You must designate a primary key for each report before you prepare and run the task, or the storage task fails.

Was deze pagina nuttig?

Als u problemen ervaart op deze pagina of de inhoud onjuist is – een tikfout, een ontbrekende stap of een technische fout – laat het ons weten!

Geef hier uw feedback