After you configure an operation for a source and specify the request message, create the relational format from the hierarchical data to include groups and fields that you want in the output.

To do this, select the elements in the response structure that you want to include as output fields. The Secure Agent converts the XML response in the hierarchical structure to relational groups at run time.

The output groups along with the primary and foreign keys are automatically generated. You can hover the mouse over an output field to view the XPath expression, which indicates which field the output field is mapped to in the response structure of the hierarchy tree.

The following image shows an example hierarchical response structure generated from the request XML for the Get_Workers operation in the Human Resources Workday module and the corresponding relational output fields for the response:

For example, in the Response Structure pane, you select First_Name and Last_Name, and then you select Email_Address, which is located under a different parent in the hierarchy. In the Output Fields area, the structure is relational with system-generated primary and foreign keys.

You can map fields from only one output group to a particular branch of the response structure hierarchy. For example, if Birth_Date is a sibling of nodes that are mapped to the Personal_Data group, you must map Birth_Date to the Personal_Data group.

You can edit the data type, precision, and scale for the groups and fields after mapping the fields.