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)
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.Sample for Mapper and Workday Writes that include multi instance fields and nodes
Does anyone have any samples or tips for mappers and using the Workday Write snap for Multi instance fields? In XSLT, we use apply-templates to copy this…but would like to see how this is done within SNAP. Thanks in advance JeromySoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request
I am attempting to get a web service response from workday, but hitting an error which does not make sense to me error: Course_Section_Reference’ is required, on internal element 'Course Section Request References There is no ‘Course Section Request References’ section, only a ‘Request References’ section which I do have populated: My pipeline snaps… The wsdl: https://wd5-impl-services1.workday.com/ccx/service/*mytenant*/Student_Records/v35.0?wsdl The operation: {urn:com.workday/bsvc/Student_Records}Get_Course_Sections The custom envelope: <SOAP-ENV:Envelope xmlns:SOAP-ENV=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:ns0=“urn:com.workday/bsvc”> SOAP-ENV:Header ns0:Workday_Common_Header ns0:Include_Reference_Descriptors_In_Response$Include_Reference_Descriptors_In_Response</ns0:Include_Reference_Descriptors_In_Response> </ns0:Workday_Common_Header> </SOAP-ENV:Header> SOAP-ENV:Body <ns0:Get_Course_Sections_Request ns0:version=“$version”> ns0:Request_References#foreach($Course_Section_Reference in $Request_References.Course_Section_Reference) <ns0:Course_Section_Reference ns0:Descriptor=“$Course_Section_Reference.Descriptor”>#foreach($ID in $Course_Section_Reference.ID) <ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end </ns0:Course_Section_Reference>#end </ns0:Request_References> ns0:Request_Criteria <ns0:Course_Reference ns0:Descriptor=“$Request_Criteria.Course_Reference.Descriptor”>#foreach($ID in $Request_Criteria.Course_Reference.ID) <ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end </ns0:Course_Reference> <ns0:Section_Listing_Reference ns0:Descriptor=“$Request_Criteria.Section_Listing_Reference.Descriptor”>#foreach($ID in $Request_Criteria.Section_Listing_Reference.ID) <ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end </ns0:Section_Listing_Reference>#foreach($Section_Status_Reference in $Request_Criteria.Section_Status_Reference) <ns0:Section_Status_Reference ns0:Descriptor=“$Section_Status_Reference.Descriptor”>#foreach($ID in $Section_Status_Reference.ID) <ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end </ns0:Section_Status_Reference>#end#foreach($Academic_Period_Reference in $Request_Criteria.Academic_Period_Reference) <ns0:Academic_Period_Reference ns0:Descriptor=“$Academic_Period_Reference.Descriptor”>#foreach($ID in $Academic_Period_Reference.ID) <ns0:ID ns0:type=“$ID.type”>$ID.value</ns0:ID>#end </ns0:Academic_Period_Reference>#end ns0:Start_Date$Request_Criteria.Start_Date</ns0:Start_Date> ns0:End_Date$Request_Criteria.End_Date</ns0:End_Date> </ns0:Request_Criteria> ns0:Response_Filter ns0:As_Of_Effective_Date$Response_Filter.As_Of_Effective_Date</ns0:As_Of_Effective_Date> ns0:As_Of_Entry_DateTime$Response_Filter.As_Of_Entry_DateTime</ns0:As_Of_Entry_DateTime> ns0:Page$Response_Filter.Page</ns0:Page> ns0:Count$Response_Filter.Count</ns0:Count> </ns0:Response_Filter> </ns0:Get_Course_Sections_Request> </SOAP-ENV:Body> </SOAP-ENV:Envelope> My mapper:
