Retrieving all records from Workday (example: Get_Worker object (Human Resource)) using workday connector

Document created by aarthi_sridhar Employee on Aug 14, 2017
Version 1Show Document
  • View in full screen mode

Workday connector can be used to get references from objects. While configuring a workday connector you will have to add parameters, only then it retrieves records. This documentation provides tips on how to retrieve all records from an object without any parameters passed to workday connector in Boomi. You may be trying to use the Workday Connector to integrate to workday using Boomi . You may see the information you run through the Operation Import process, it connects and gives you the request and response profile back. This is one step to confirm that the connection details are working fine and the operation imports the object. However, when the process is run, there might be no data back.  You might end up getting error as com.boomi.webservices.WebServiceException: Failed creating request message Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Premature end of file; Failed processing input BD:2017.08.01_162115:0 

 


This error is caused probably for not adding parameters to Workday connector.  The object we were trying to fetch is Get_worker including the return all pages enabled. The description of Workday's Get_Workers operation says if the request does not specify a worker, the operation returns information for all workers. This will make you try not to set parameters in the connector and retrieve all records. If you do so, you may end up the above error. With the workday connector you need at least 1 parameter in the request in order to build the request body submitted to the workday API. You can retrieve one record by setting set @type to Employee_ID, and ID to some value of employee which you would like to retrieve. All records from Get_workers may not be retrieved without setting parameters to connector.  Be sure to also check the return all pages in the operation.

 

 

 

How to retrieve all records for an object: 

  • If you need data from single object in Workday without passing parameters in the workday connector, create a custom report in Workday and expose it as a RaaS service then schedule an Atomsphere process using the HTTP Client connector to periodically extract the data in a single call.
  • If you need a particular reference data from single object in Workday, pass parameters to the connector @type and value. The connector retrieves back data from workday.
  • If you need data from multiple objects in Workday, create a custom report in Workday and expose it as a RaaS service then schedule an Atomsphere process using the HTTP Client connector to periodically extract the data in a single call.

  •  Additional data can be retrieved in subsequent Workday SOAP API or RaaS calls if needed.

     

 
Workday is built more for smaller sets of data as opposed to a full set of data. It is also a little more difficult because multiple sets of data can come out for a specific piece of data. For instance, the data was providing country information, and under that tag, 4 different types might come out with different sets of data. You may try sending the data to a CSV, 1 record turned in to 8. It needs to do a lot more work to figure out what types should be returned specifically in workday's end. 

 It is much easier to use the RaaS option and HTTP Connector if the use-case requirement is to retrieve all records from a workday object (if the requirement is without any parameter to be used). 

 

 

Useful links:
Workday Integration Guide 
Workday connector 

Attachments

    Outcomes