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 serviceContent
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:
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.
Tagged:
0