[Improvement]: Handle intersecting and differencing fields of the XML nodes with same name

[AzeemMuzammil]

Description

When there are two XML nodes with the same name present, those two nodes should be converted into one Ballerina record, and the intersecting and differencing fields in those nodes should also be handled as below,

<catalog>
    <book id="bk102">
        <author>Gambardella, Matthew</author>
        <title>XML Developer's Guide</title>
        <price>44.95</price>
        <description>Really good book for developers</description>
    </book>
    <book id="bk102">
        <author>Ralls, Kim</author>
        <title>Midnight Rain</title>
        <price>5.95</price>
    </book>
</catalog>

For this XML, Ballerina Record should look like,

type Book record {
    string author;
    string title;
    decimal price;
    string description?;
    @xmldata:Attribute
    string id;
};

@xmldata:Name {
    value: "catalog"
}
type Catalog record {
    Book[] book;
};

Describe your problem(s)

No response

Describe your solution(s)

No response

Related area

-> Other Area

Related issue(s) (optional)

#41180

Suggested label(s) (optional)

No response

Suggested assignee(s) (optional)

No response

[KavinduZoysa]

             <ZASN_SDTX SEGMENT="1">
                <TDID>ZCA8</TDID>
                <TDSPRAS>E</TDSPRAS>
                <ZASN_SDTXP SEGMENT="1">
                   <TDLINE>GS~012430880~925159POHC</TDLINE>
                </ZASN_SDTXP>
             </ZASN_SDTX>
             <ZASN_SDTX SEGMENT="1">
                <TDID>ZEDH</TDID>
                <TDSPRAS>E</TDSPRAS>
                <ZASN_SDTXP SEGMENT="1">
                   <TDFORMAT>/</TDFORMAT>
                   <TDLINE>X12-LIFNR-WE=ST~9~0124308800009</TDLINE>
                </ZASN_SDTXP>
                <ZASN_SDTXP SEGMENT="1">
                   <TDFORMAT>/</TDFORMAT>
                   <TDLINE>X12-LIFNR-ST=ST~9~0124308800009~8691 JESSIE B SMITH</TDLINE>
                </ZASN_SDTXP>
             </ZASN_SDTX>

Please check the above xml. Created record containing a field for ZASN_SDTXP but should be an array of ZASN_SDTXP.

[KavinduZoysa]

Please consider following case.

<Rec2>
    <Rec1>
        <i>144</i>
        <s>s1</s>
        <!-- <Rec1>
            <i>144</i>
            <s>s1</s>
        </Rec1>     -->
        <Rec1>
            <i>144</i>
            <s>s1</s>
            <Rec1>
                <i>144</i>
                <s>s1</s>
                <Rec1>
                    <i>144</i>
                    <s>s1</s>
                </Rec1>    
                <Rec1>
                    <i>144</i>
                    <s>s1</s>
                </Rec1>
            </Rec1>        
        </Rec1>
    </Rec1>
</Rec2>

This xml generates the records as follows.

type Rec1 record {
    int i;
    string s;
    Rec1 Rec1;
};

type Rec2 record {
    Rec1 Rec1;
};

IMO there are two issues here.

1. Rec1 should be an array.
2. Rec1 should be an optional field.

If you uncomment the commented lines, the array will be generated.