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 XML data using Read File In Segments

Accepted answer
15
Views
8
Comments
edited Aug 23, 2021 10:33PM in Integration 8 comments

Content

We have a requirement where we need to read a BIP report which is a XML file. Each record in the XML file represents  a header and a line information. We need to construct a payload reading records with all the lines which has a matching header information and call an API passing this payload. Our BIP reports is a zipped xml file stored in UCM and the unzipped file can get quite large.

My questions are

1, Can Read File In Segment be used on a XML file

2. If so, how can I be sure that I have all the lines with the matching header information in 200 chunk that gets read. A line with a matching header can also be part of the next 200 chunk. In this case I cannot use Read File In Segment. Please correct me if I am wrong.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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