Intermediate
Handling Bulk Messages
2019-12-17
10 min.
Learn how to handle messages individually, when receiving multiple messages as a part of one big message.
You will learn
- How to split a message containing multiple messages into individual messages
- How mapping works with bulk messages
Assume that a customer orders multiple items. The input XML will then contain all the item information. In this exercise, we shall separate the items and process them individually.
Step 1: Process a bulk message
-
Let us change our input message and add 2 more items to it.
-
Add the following text to your input message:
<item> <ProductID>RPD4044544</ProductID> <ProductDescription>Keyboard</ProductDescription> <Quantity>1</Quantity> <ItemValue>1057</ItemValue> </item> <item> <ProductID>RPD4044545</ProductID> <ProductDescription>Webcam</ProductDescription> <Quantity>1</Quantity> <ItemValue>1057</ItemValue> </item>Once done, your message should look like:
-
-
Execute your flow with the new message. You will see that the output mail only contains 1 item information:
-
This is because the cardinality of the Item field is set to 1..1.
-
Edit the XSD.
-
Go to the Item field and add
minOccurs="1" maxOccurs="unbounded"to it as attributes as follows:
- Go to the integration flow’s Resources View and delete both Order.xsd and WarehouseOrder.xsd.
- Go to the Message Mapping and reimport the edited XSD.
In spite of having deleted the XSD, SAP Cloud Platform Integration preserves the maps.
-
Check if all the maps are configured.
-
Save, deploy and execute your flow. You should get one composite mail containing all product information:
-
Step 2: Split message
- Add a Splitter step to the integration flow:
- Click on the design Palette.
- Choose Message Routing.
- Go to Splitter.
- Choose General Splitter.
- Drag it on to the execution pipeline between the Router and XML to JSON Converter step on the branch for KWA2MNWC2U.
Name it Split Orders.
- Configure the General Splitter as follows:
Field Value Expression Type XPATH XPathExpression/orders/order/items/item Grouping 1 Streaming Checked Parallel Processing Unchecked Stop on Exception Checked - Save, deploy and execute your flow. You should get one 3 individual mails containing individual product information:
Play around with the different types of splitters and different configuration, to understand how the results differ.