Table of Contents

Search

  1. Preface
  2. Workday Connector
  3. Workday connections
  4. Workday operations
  5. Mappings and mapping tasks with Workday
  6. Appendix A: Workday data type reference
  7. Appendix B: General considerations when using Workday V2 Connector
  8. Appendix C: Workday target approaches

Workday V2 Connector

Workday V2 Connector

Field mapping in a Source transformation

Field mapping in a Source transformation

The response message format follows the service response definition in Workday. You can map response fields from a hierarchical to a relational structure of output groups and fields.
After you configure an operation for a source and specify the request message, create the relational format from the hierarchical data to include groups and fields that you want in the output.
To do this, select the elements in the response structure that you want to include as output fields. The Secure Agent converts the XML response in the hierarchical structure to relational groups at run time.
The output groups along with the primary and foreign keys are automatically generated. You can hover the mouse over an output field to view the XPath expression, which indicates which field the output field is mapped to in the response structure of the hierarchy tree.
The following image shows an example hierarchical response structure generated from the request XML for the Get_Workers operation in the Human Resources Workday module and the corresponding relational output fields for the response:
The Field Mapping tab shows the response structure on the left pane and the corresponding output fields and groups created in relational format on the right pane.
For example, in the Response Structure pane, you select First_Name and Last_Name, and then you select Email_Address, which is located under a different parent in the hierarchy. In the Output Fields area, the structure is relational with system-generated primary and foreign keys.
You can map fields from only one output group to a particular branch of the response structure hierarchy. For example, if Birth_Date is a sibling of nodes that are mapped to the Personal_Data group, you must map Birth_Date to the Personal_Data group.
You can edit the data type, precision, and scale for the groups and fields after mapping the fields.