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)Employee Journey: Insert new employee into Workday
Created by @rdill This pipeline pattern allows users to respond to a REST Post event triggered by a third party HR solution (e.g. Jobvite, Glassdoor, LinkedIn, etc.) and insert new employee(s) data into Workday. Configuration This pipeline requires the proper structure to insert a new employee in Workday. There are two kinds of data needed to create a new employee, “static” data, such as country reference, organization reference, etc. The second is the dynamic data, user name, hire date, etc. The pipeline is configured to provide the static data and all the user needs to do is provide the dynamic data. Sources: Any application that can invoke a REST Post to create an employee in Workday and contains the necessary attributes to create a new employee in Workday. (In this case, a JSON document is used.) Targets: Workday: Service, Staffing, Object, Hire Employee Snaps used: File Reader, JSON Parser, Mapper, Workday Write Downloads POST Hire Employee.slp (9.4 KB)
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.
Read data from a file in SnapLogic Database, transform the data in Workday and load data into SQL Server
Created by @sreddi This pipeline pattern extracts data from the SnapLogic Database file, transforms the data in Workday and loads the data into a target, such as a SQL Server. Configuration File Reader Snap Filter Snap Mapper Snap SQL Bulk Load Snap Sources: JSON file in the SnapLogic Database Targets: Workday Read to Staffing, SQL Server Bulk Load to Create New Table Snaps used: File Reader, JSON Parser, Filter, Mapper, Workday Read, SQL Server Bulk Load Downloads Workday_PM.slp (13.0 KB)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 Meitei
