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

Parameterizing input values in a request message

Parameterizing input values in a request message

You can use in-out parameters to represent input values in a request XML.
Configure the in-out parameters in the Mapping Designer. From the Mapping Design page, you open the parameters panel and configure an in-out parameter.
The following image shows a configured Updated_From in-out parameter value:
You can view the Updated_From default value of 2016-05-11.
After you configure a parameter, use the parameter name in the following format, $$Name, in a request message. The XML uses the fields from the parameterized object.
For example, you want to use parameterized Updated_From and Updated_To values in an XML request for a Get_Operation.
The following sample request shows the parameterized values that you can specify in an XML request:
<bsvc:Get_Workers_Request xmlns:bsvc="urn:com.workday/bsvc" bsvc:version="v25.0"> <bsvc:Request_Criteria> <bsvc:Transaction_Log_Criteria_Data> <bsvc:Transaction_Date_Range_Data> <bsvc:Updated_From>$$Updated_From</bsvc:Updated_From> <bsvc:Updated_Through>$$Updated_Through</bsvc:Updated_Through> </bsvc:Transaction_Date_Range_Data> </bsvc:Transaction_Log_Criteria_Data> </bsvc:Request_Criteria> <bsvc:Response_Filter> <bsvc:Count>1</bsvc:Count> </bsvc:Response_Filter> <bsvc:Response_Group> <bsvc:Include_Personal_Information>1</bsvc:Include_Personal_Information> <bsvc:Include_Transaction_Log_Data>1</bsvc:Include_Transaction_Log_Data> </bsvc:Response_Group> </bsvc:Get_Workers_Request>

Configuring In-Out Parameters in a Mapping

You can use an in-out parameter that holds a variable value that can change each time a task runs to manage incremental data loading.
Add the in-out parameterized values in complex expressions in a mapping when you want to update the parameters when each task runs. The in-out parameter acts like a placeholder for a value that stores a task stage.
Data Integration
evaluates the parameter at run time based on the specified configuration.
For example, you can use the following parameterized values in an Expression transformation:
SetVariable($$Updated_From, TO_CHAR(ADD_TO_DATE(TO_DATE($$Updated_From,'YYYY-MM-DD'),'DD',1),'YYYY-MM-DD'))
In the example, SetVariable function sets the parameter value each time the session runs. The default value set for the $$Updated_From parameter is 2016-05-11. You want to update the value by one every time the task runs.
The following image shows the parameterized values used in an Expression transformation in the Mapping Designer:
 You can view a sample Expression transformation in a mapping which shows the parameterized values for $$Updated_through and Updated_From.
When you deploy the mapping in a
mapping
task, you can configure the mapping to run according to a schedule. When the task runs, the Secure Agent updates the in-out parameters based on the specified parameters in the expression.
The following image shows a configured parameter used in a
mapping
task:
 You can view a sample Expression transformation in a mapping which shows the parameterized values for $$Updated_through and Updated_From
In the example, the task reads rows dated through the default value 2016-05-11 the first time it runs. The task sets $$Updated_From to 2016-05-12 when the session is complete. The next time the session runs, the task considers the updated value and reads rows with the date 2016-04-12.