How you will get data from tenant to studio in Workday?

How you will get data from tenant to studio in Workday?

Here’s a step-by-step guide to transfer data from Workday Tenant to Workday Studio:

Method 1: Using Workday Web Services (SOAP/REST API)

Steps:
Identify the Required API
Check Workday’s Web Services Directory (e.g., Get_Workers, Get_Custom_Report_Data).
Use Report-As-A-Service (RaaS) for custom datasets.
Set Up Security
Create an Integration System User (ISU) in Workday.
Assign proper security groups (e.g., Integration - SOAP API Access).
Get API Details
Obtain the WSDL (for SOAP) or Endpoint URL (for REST).
Note authentication method (OAuth 2.0 or Basic Auth).
Configure Workday Studio
Open Workday Studio and create a new Integration Project.
Use "Web Service Consumer" connector.
Enter the API endpoint URL and authentication details.
Call the API & Fetch Data
Send a request (e.g., SOAP envelope for Get_Workers).
Capture the XML/JSON response in Studio.
Transform & Process Data
Use XSLT or Groovy scripts for data mapping.
Store data in a file/database or send to another system.
Test & Deploy
Run in Sandbox Tenant first.
Schedule the integration (if recurring).

Method 2: Using Report-as-a-Service (RaaS)

Steps:
Create a Workday Report
Go to Report Writer and design a report with required fields.
Publish as RaaS
Click "Enable as Web Service" (RaaS).
Note the RaaS URL (e.g., .../Report_ServiceName).
Call RaaS from Studio
Use HTTP Connector in Studio.
Pass ISU credentials in headers.
Set Accept: application/json (or XML).
Process Data
Parse JSON/XML response.
Transform data if needed.

Method 3: Using EIB (Enterprise Interface Builder)

Steps:
Create an EIB in Workday
Go to "Create EIB" under Integrations.
Select "Custom Report" as the data source.
Generate & Export Data
Run the EIB manually or schedule it.
Output format: CSV/XML.
Transfer File to Studio
Save to SFTP/Shared Drive.
Use File Inbound Connector in Studio to read.
Process in Studio
Parse CSV/XML.
Apply business logic.

Key Tips

✔ Always test in Sandbox first.
✔ Log errors & set up alerts.
✔ Use Workday Studio’s debugging tools.