Create a Target transformation in the Mapping Task wizard to write data to Zuora. When you select a Zuora REST V2 connection for a Target transformation in a mapping, you can select an operation from the list of operations. When you want to write data that is in relational format to Zuora, the Secure Agent converts the relational data to a hierarchical format before writing to Zuora.
When you configure a Zuora target, you can select Operations on the Target tab to display the list of 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 Zuora, 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 Zuora 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 on the Field Mapping tab.
File Preparation for Target Transformation
To write data to Zuora, the source file must include the container with the processing options and the wrapper referential elements to perform the specified operation in Zuora.
For information about the required business process parameters and the wrapper elements, see the request elements for the specified operation in the Zuora web service directory. You need to prepare a file to include the wrapper elements along with the data that you want to write to Zuora. You can add the processing options in an Expression transformation later when you write the data to Zuora.
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 Zuora.
Field Mapping in a Target Transformation
You can map fields that are in a relational structure to the hierarchical structure used by a Zuora 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 Zuora target in an operation to insert data into Accounting Code Types object: