Workday V2 Connector

Back Next

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 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:

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:

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.

Rename Saved Search

Table of Contents

Workday V2 Connector

Workday V2 Connector

Parameterizing input values in a request message

Parameterizing input values in a request message

Configuring In-Out Parameters in a Mapping