Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

edited Feb 5, 2020 10:02PM in Integration 1 comment

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:

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!