Workday V2 Connector

Back Next

Creating packed fields in a field mapping

You can reduce the number of output groups for a complex request message by marking fields that you want to pack when you configure the field mapping.

You can pack multiple instances of a single element or a hierarchy of elements into one field. A packed icon displays next to elements marked to be packed, indicating that you can pack the entire element into one output field when you check that element.

Fields can come from the source that are already marked for packing. You can unpack fields by clicking the pack icon. You cannot select fields that are descendants of packed fields.

The following image shows the packed Phone_Data element:

When you select the Phone_Data element on the left pane, the right pane shows that element and its descendants packed together.

When you run the mapping, the agent packs the element and its descendants into a single XML string.

The following sample table shows the Worker output in the target file after you run the task:

PK_Worker	Phone_Data	First_Name	Last_Name
1	<infa_packed><wd:Phone_Data wd:Formatted_Phone="+1 (650) 882-6532"> <wd:Country_ISO_Code>USA</wd:Country_ISO_Code> <wd:International_Phone_Code>1</wd:International_Phone_Code> <wd:Area_Code>650</wd:Area_Code> <wd:Phone_Number>882-6532</wd:Phone_Number> <wd:Phone_Device_Type_Reference wd:Descriptor="Mobile"> <wd:ID wd:type="WID">d691375437c848aea9d5b0874353bfd7</wd:ID> <wd:ID wd:type="Phone_Device_Type_ID">1063.1</wd:ID> </wd:Phone_Device_Type_Reference> <wd:Usage_Data wd:Public="0"> <wd:Type_Data wd:Primary="1"> <wd:Type_Reference wd:Descriptor="Home"> <wd:ID wd:type="WID">836cf00ef5974ac08b786079866c946f</wd:ID> <wd:ID wd:type="Communication_Usage_Type_ID">HOME</wd:ID> </wd:Type_Reference> </wd:Type_Data> </wd:Usage_Data> </wd:Phone_Data> </infa_packed>	Ernest	Egg

PK_Worker

Phone_Data

First_Name

Last_Name

<infa_packed><wd:Phone_Data wd:Formatted_Phone="+1 (650) 882-6532">
<wd:Country_ISO_Code>USA</wd:Country_ISO_Code>
<wd:International_Phone_Code>1</wd:International_Phone_Code> 
<wd:Area_Code>650</wd:Area_Code>
<wd:Phone_Number>882-6532</wd:Phone_Number> 
<wd:Phone_Device_Type_Reference wd:Descriptor="Mobile"> 
<wd:ID wd:type="WID">d691375437c848aea9d5b0874353bfd7</wd:ID>
<wd:ID wd:type="Phone_Device_Type_ID">1063.1</wd:ID> 
</wd:Phone_Device_Type_Reference>
 <wd:Usage_Data wd:Public="0"> 
<wd:Type_Data wd:Primary="1">
 <wd:Type_Reference wd:Descriptor="Home"> 
<wd:ID wd:type="WID">836cf00ef5974ac08b786079866c946f</wd:ID> 
<wd:ID wd:type="Communication_Usage_Type_ID">HOME</wd:ID>
 </wd:Type_Reference> 
</wd:Type_Data> 
</wd:Usage_Data>
 </wd:Phone_Data> 
</infa_packed>

Ernest

Egg

You can view the packed Phone_Data in the target file.

Workday source operations

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal