Configuring a Request that Contains Array Elements
You can construct a request for a REST V2 target and REST V2 midstream transformation that contains array elements using one of the following methods:
Creating a Request using Multiple Source Groups
If the request message contains an element, for example, phone number of type work of an employee, that occurs multiple times, the input fields for this element must come from different source groups.
To create a request for relational sources, link the source group in the input fields to its parent source group by using the foreign key.
To decide the parent source group for multioccurring elements, you must perform the following steps:
- •The parent group must be the immediate multioccurring parent element.
- •In the absence of a multi-occurring parent element, map the multi-occurring element to the source group that is mapped to the root element.
For example, the following image shows the mapping of the multioccuring element
work from the relational data source to the REST V2 target:
Creating a Request using a Single Source Group
To create a request using a denormalized source for a midstream transformation or REST V2 target, perform the following steps:
- 1. Include all the fields in a single source file. Ensure that the multioccuring elements are the last fields in the denormalized source file.
- 2. Click Configure > Runtime Environments and select an agent.
- 3. Add a new property under Custom Configuration Details.
- 4. Select Service as Data Integration Server and Type as Tomcat.
- 5. Specify the name of the property as ALLOW_DUPLICATE_VALUES.
- 6. Set the value to true.
- 7. Click Done to save the changes.
- 8. Map the corresponding source to target fields.
For example, the following image shows the mapping of the field work to an array element of REST V2 target:
