Create a Target transformation in the Mapping Designer to write data to Concur. When you select a Concur V2 connection for a Target transformation in a mapping, you can select an operation based on the object configured in the connection. When you want to write data that is in relational format to Concur, the Secure Agent converts the relational data to a hierarchical format before writing to Concur.
When you configure a Concur V2 target, you can select Operations on the Target tab to display the list of valid operations. The Secure Agent creates target fields based on the request message structure of the operation you select on the Target tab.
When you write data to Concur, the Secure Agent includes all the incoming fields from the source, by default. You can exclude the incoming fields, if required. You can add multiple input sources to write data to Concur V2 target object and define the primary and foreign key relationships between the input sources before you run the mapping. Each input source appears as separate group in the Field Mapping tab in the target transformation. You can define key relationships in the Field Mapping tab.
File Preparation for Target Transformation
To write data to Concur, the source file must include the container with the processing options and the wrapper referential elements to perform the specified operation in Concur.
For information about the required business process parameters and the wrapper elements, see the request elements for the specified operation in the Concur web service directory. You need to prepare a file to include the wrapper elements along with the data that you want to update in Concur. You can add the processing options in an Expression transformation later when you write the data to Concur.
For example, if you have AttendeeType object data in two flat files, you need to create a single flat file before writing AttendeeType data in Concur.
The following image shows the mapping configured to create one target .csv file that includes all information for AttendeeType:
The following image shows the fields from the FF_Attendee_Type_GET flat file object:
The following image shows the fields from the FF_Duplicate_Search flat file object:
Use Joiner transformations to join the data from the files.
The following image shows a configured Join condition to join the FF_Attendee_Type_GET and FF_Duplicate_Search data:
The following image shows the fields from the two sources that the target includes:
When you run the mapping, the Secure Agent writes data to a configured target .csv file. Later, use this file as a source from which you write data to Concur.
Field Mapping in a Target Transformation
You can map fields that are in a relational structure to the hierarchical structure used by a Concur V2 target.
On the Field Mapping tab for the Target transformation, the fields in the Target Fields appear in hierarchical format. The target fields are determined by the request message structure of the operation you select for the Target transformation.
Each source object displays as a group in the Input Fields area. You can select fields in the Input Fields area to map the fields to the request. If the input fields include multiple input groups, map the groups to the corresponding nodes in the request. Be sure to map all of the fields that you require in the request.
The following image shows an example of mapped input fields from the source file with the Concur V2 target in an operation for updating the Attendee Types:
