Grouping Repeating Child Records in a file then call a soap service for each group

Summary

What is the best way to find repeating child records, group them, and call a web service

Content

Hi All,

Here is the problem I am tackling:

I have below records in a csv file:

Document Num	Line Num	Header Action	Line Action	Org
11111-A	1		CANCEL	CN
11111-A	2		CANCEL	CN
11111-A	3		CANCEL	US
22222-B	7		UPDATE	US
22222-B	2		UPDATE	US
33333-C	9		UPDATE	US
33333-C	10		UPDATE	US
44444-D		CANCEL		US
55555-E	1		UPDATE	US

And I am using 2 soap service connections calling Oracle ERP SaaS:

• changePurchaseOrder
• cancelPurchaseOrder

Each call can take in repeating Line Num. For instance instead of calling 11111-A 3 times per line I can instead call 1 time for 3 lines. Or in an extreme case, 1000 lines combined in 1 call vs 1000 calls.