Using Workday RaaS to Extract Data
Using Workday RaaS to Extract Data Workday has a Reporting as a Service (RaaS) interface which allows you to export most data from Workday by creating a custom report within Workday then exposing it as a web service. The output can be various formats such as RSS, XML or JSON format and you can even modify the filters within the URI. RaaS are faster because they are pre-gathered because the actual data gathering happens in Workday cloud whenever the report runs and delivered as the preferred output format of XML or JSON. That’s why it’s faster. Reports are a live look into Workday, and pulls the data as of the current moment just like the WWS which is used by the Workday snap. If you depend on live data, use the Workday snap. Also remember that using reports you’re just shifting the load-debt. It’s still calling Workday, just at a time you may or may not be expecting instead of at the time of the call. Below are high-level instructions on how to retrieve data from Workday within SnapLogic using Workday’s RaaS interface. Step 1 - Create Custom Report in Workday You need to login to a Workday instance Click on Reporting & Analytics Button Click on Create Custom Report Provide some Report Name Report Type: Advanced Data Source: Journal Lines Under Custom Report Data Source Filter: Journal Lines for Financial Reporting and Reporting Time Period Under Columns Journal Number Company Accounting Date Ledger/Budget Debit Amount Ledger/Budget Credit Amount Ledger Currency Journal Source Ledger Line Memo Created By Be sure to share it with the account that you are querying the report with. Some reports Data Sources will enable filters on them so that the data retrieved is indexed and offers some performance benefits. In this report it will prompt you to enable Data source filter Now click on the Prompts tab to populate the default prompts. Once the checkbox is clicked, the prompt defaults are populated. Accept the defaults and if you wish to change the names, please do rename that makes sense for your project. Click OK at bottom to save Step 2 - Ask customer what data do they want. The default behavior is to pull the data as of the current moment. If the customer has a different requirement then please follow this link (Workday Report Data Prompts) to understand how you can control what type of data can be pulled from Workday reports. The above behavior is only possible with Workday Advanced Reports. Step 3 - Get Web Service URL Next to the name of your custom report you’ll see a button … click it and under Actions select Web Services and View URLs You need to set filters for the ones that are mandatory (red asterisk *) Period: 2013 - Jan Ledger: Actuals Amount Type: Activity Time Period: Current Period Company: Global Modern Services, Inc. (USA) Click OK button Workday delivers in multiple formats. (REST - Workday XML, WSDL, JSON, etc). Choose the format you like and copy the URL. It is important to copy the URL for that specific format. REST https://wd2-impl-services1.workday.com/ccx/service/customreport2/tenant_name/nganapathiraju/NG_Journal?Perform_Intercompany_Eliminations=0&Perform_Interworktag_Eliminations=0&Company!WID=cb550da820584750aae8f807882fa79a&Time_Period!WID=ac6e82a2e2d01000180ca7cad7770051&Calculate_Current_Year_Retained_Earnings=0&Calculate_Translation_Gain_or_Loss=0&Amount_Type!WID=dcfe0be6bdf044da8781b873631c71c4&Ledger!WID=93553555942b4b448defb264c084d0fa&Eliminations_Only=0&Period!WID=4facd2281c9a4b2794afc7559475359f WSDL https://wd2-impl-services1.workday.com/ccx/service/customreport2/tenant_name/nganapathiraju/NG_Journal?wsdl JSON https://wd2-impl-services1.workday.com/ccx/service/customreport2/tenant_name/nganapathiraju/NG_Journal?Perform_Intercompany_Eliminations=0&Perform_Interworktag_Eliminations=0&Company!WID=cb550da820584750aae8f807882fa79a&Time_Period!WID=ac6e82a2e2d01000180ca7cad7770051&Calculate_Current_Year_Retained_Earnings=0&Calculate_Translation_Gain_or_Loss=0&Amount_Type!WID=dcfe0be6bdf044da8781b873631c71c4&Ledger!WID=93553555942b4b448defb264c084d0fa&Eliminations_Only=0&Period!WID=4facd2281c9a4b2794afc7559475359f&format=json Refresh URL it will download the report in JSON format after you enter the credentials Step 4 - Create SnapLogic Pipeline to access URL Download Get WD Report.slp included on this page Import pipeline into SnapLogic Modify REST - Get Snap Change Service URL to the URL from Step 2 Create New Account - Basic Auth Enter your Workday Username and Password Validate Pipeline You should see preview data Note you might need to change Mapper if you are using different fields The sample pipeline with basic structure Get WD Report.slp (5.6 KB)
State Department Per Diem Rates to Workday Import Expense Rate Table
Pipeline sample that grabs per diem rate data from State Department website and imports it into Workday Rate Tables. It gets a little complex as far as the data mapping and filters, but cuts down on tedious manual maintenance of these tables. We run this once a month. There is definitely room for improvement like adding some validation checks. One big issue is that the import is all or nothing; if a single record doesn’t match between the State Dept. spreadsheet and Workday, it fails. Also, the Workday call itself always returns as if it succeeded, so you have to do a search for ‘import expense rate table’ in Workday to see if and what any errors are. You will likely have to play around with the mapping and filters to get the Excel data to match the Spend_Data_ID fields for locations in Workday. And the State Dept adds a new location every couple months which will cause the integration to fail unless you enter the new location in Workday. So, not perfect, but certainly saves HR a few steps. Erik Pearson Senior Software Engineer Bowdoin College HR_PerDiemRates_HR_Import.zip (7.8 KB)
CSV to Workday Tenant
Submitted by @stodoroska from Interworks This pipeline reads a CSV file, parses the content, then the Workday Write Snap is used to call the web service operation Put_Applicant to write the data into a Workday tenant. Configuration If there is no lookup match in the SQL Server lookup table, we are using MKD as a default code for country code. Sources: CSV file on the File share system Targets: Workday tenant Snaps used: File Reader, CSV Parser, SQL Server - Lookup, Mapper, Union, Workday Write Downloads CSV2Workday.slp (17.3 KB)
Getting an error while using the snap "WorkDay Read". Appreciate your help
We are using the snap “Workday Read” to fetch data from the WorkDay. When we choose the “services” as “Integrations” and “Object” as “Get_Event_Details”, we receive the following message. Please assist us in resolving the issue. Error: Failure: Soap fault, Reason: Validation error occurred. Element Content ‘Request_References’ is required, on internal element ‘Get Event Details Request’, Resolution: Address SOAP fault message and retry
How to get JSON node which cause Workday webservice error under Workday Write response message?
Hi Everyone, In SOAP UI/ Workday Studio’s SOAP response, we usually get Web Service(WS) error xpath which tell us the node/XML xpath cause webservice error. This xpath allow developer to understand which section of WS request cause the error. Example of SOAP response having error: wd:Validation_Error wd:MessageInvalid ID value. ‘BUSINESS ASSE’ is not a valid ID value for type = ‘Location_Usage_ID’</wd:Message> wd:Detail_MessageInvalid ID value. ‘BUSINESS ASSE’ is not a valid ID value for type = ‘Location_Usage_ID’</wd:Detail_Message> wd:Xpath/wd:Put_Location_Request[1]/wd:Location_Data[1]/wd:Location_Usage_Reference[1]</wd:Xpath> </wd:Validation_Error> Similarly, I am looking for specific node which cause any webservice error when Snaplogic’s Workday Write snap execute. Unfortunately, current Workday write does not give such node details in SOAP request that causes WS error. Getting such JSON node or Xpath location will help my business scenarios which needs to identify specific address section that causes WS error for Put_Student_Application. Under this web service, Workday allows us to add different types addresses related to student including friend and family (like, mailing, permanent, parent address etc.). Below is error message of Workday Write: From above error message, we are able to get error description and suggested resolution but it does not give any information regarding which address section (either personal mailing, permanent, parent address etc) cause said WS error. Kindly advice if anybody came across such scenario and how we can handle such cases. Regards, Sandeep MeiteiWorkday call returns error "Problem writing SAAJ model to stream: Output operation aborted"
Hello Team, Recently we started getting an error when we are trying to post data to Workday using the “Workday write” snap. It was working fine earlier but now its failing intermittently with the error “Problem writing SAAJ model to stream: Output operation aborted”. It works as expected sometimes and sometimes its failing. I am attaching the entire error message for your reference. Can you please help finding out what might be causing the issue or help us out to get a fix. Thanks, Jiva
Validation ignores the field in JSON path if the field is null
Hello, We are using snaplogic to extract data from Workday student module to data warehouse, our pipeline is based out custom reports in Workday ( RAAS ) as REST Get. When snaplogic validates initially, it ignores fields if the field value is null, for example snaplogic validates first 50 records if a field in those 50 records is null, it’s not shown up in the JSON path. Since the field is not showing up, we are not able to map the field to target. When we execute the pipeline, the execution failing after processing few records indicating the field is not mapping ( field with null value during validation), say the field has null value for first 50 records, if there is value from 51th record or so, the pipeline beings the field into JSON path and failing. Is there way or settings in the pipeline to show all the fields from RAAS irrespective of the fields has value or not during validation.Workday to Oracle and BambooHR of Employee Information
Created by @asharifian This pattern provides an HRIS integration from Workday to Oracle and BambooHR. Oracle will store employee information in a database table for analytics purposes. BambooHR is an HRIS system that will store employee information for human resources and onboarding. The source is the Human_Resources service, Get_Workers object in Workday. Configuration You can get a free trial of BambooHR and test out their API’s. API is relatively easy to configure. Sources: Workday Get_Workers Targets: Database Table for Oracle, Employees for BambooHR Snaps used: Workday Read, Mapper, Copy, Oracle - Insert, JSON Splitter, REST Post Downloads Workday to Oracle-BambooHR.slp (13.2 KB)Employee Journey: Employee Data Management: Box Folder Management
This pattern is part of the Employee Data Management solution of the Employee Journey. Created by SnapLogic in conjunction with partner Eljun, LLC This pattern looks for active users within Workday that were updated within the last two hours and pulls employee files into their corresponding sub-folders, using the file structure created from the Box Folder Management pipeline. In this solution, the parent directory for employee files is divided into “Active” and “Terminated” folders. Under each of these subfolders is a series of sub-folders A-Z (representing the first letter of each employee last name). The actual Employee File Folder is then found within the appropriate alphabetical subfolder with a naming convention “EmployeeID_LastName_FirstName”. Additional sub folders are created within each employee folder, each representing a functional category of documents that the HR unit may want to capture such as performance, expenses, and training. Pipelines Get Employee Files With this pipeline, for active users updated in Workday within the last 2 hours, determine what information from the Workday Get_Workers object to include, then: kick off the Box_Folder_Management pipeline get the user’s active status, employee name, and ID from Workday get the user’s Jobvite candidate information get the user’s 7Geese information and write it to the user’s Performance sub folder. get the user’s Skilljar information and write it to the user’s Training sub folder. get the user’s Docusign information get the user’s Expensify information and write it to the user’s Expenses sub folder. Applications in use: Workday, Box, Jobvite, 7Geese, Skilljar, Docusign, Expensify Box_Folder_Management This pipeline creates a folder structure within Box to store relevant data for a new hire, moves it to a separate location when an employee leaves, or archives the termination folders if the employee is rehired. In the case where an employee leaves the company, their folders are moved to the Terminated folder. If a person is re-hired, their Terminated folders are archived. Applications in use: Box Snaps used: Mapper, Pipeline Execute, Router, Union, JSON Splitter, Box File Operations, Exit, Filter, Copy, Join, JSON Formatter, File Writer, Box Directory Browser, Tail Check_and_Create_Folder This pipeline checks to see if the requested folder already exists, and if not, creates it. Applications in use: Box Snaps used: Box Directory Browser, Group by N, Mapper, Join, Sequence, Router, Box Add Folder, Union Push_File_to_Box Use this pipeline to read a file from the SnapLogic Platform and write it to a users Box folder. Applications in use: Box Snaps used: Directory Browser, Filter, File Reader, Box Write Downloads Get Employee Files.slp (127.1 KB) Box_Folder_Management.slp (71.9 KB) Check_and_Create_Folder.slp (19.6 KB) Push_File_to_Box.slp (7.7 KB) See Also SnapLogic Human Resources Automate employee workflows from talent management to employee on and offboarding, all in one platform.
