Avatar

Level 1

Hi @Jyoti_Yadav ,

Thanks for your response.
I am not sure if suggested method will be feasible as the XML is really complex, sharing an example below:

<recipient>

<email>xyz@xyz.com</email>

<name>abc</name>

<location>

          <country> XYZ </country>

          <address>

          <county>abs</county>

          <city>

                    <cityName>xxx</cityName>

                    <postcode>567</postcode>

                    <addressLine1>abc</addressLine1>

                    <addressLine2>nm</addressLine2>

                    <addressLine3>nm</addressLine3>

           </city>
        </address>

 

</location>

</recipient>

 

Not the best example though.

Suppose we are recording address record from last 10 years.

Recipients.Location.country can have multiple records depending how many countries person has lived in.

Similarly sub nodes will vary,
Recipients.Location.address.county
Recipients.Location.address.city.postcode etc

Based on the data, I have to generate a table listing the country & other details associated.

 

City Name

Post Code

Address Line 1

Address Line 2

Address Line 3

Country 1

 

 

 

 

 

Country 2

 

 

 

 

 

Country 3

 

 

 

 

 

Country 4

 

 

 

 

 


PostCode is mandatory but all other columns can be empty/populated. In hypothetical situation a person can have lived in 10 different countries in 10 years or say 5 different countries , so row will vary from 1 to 10.

In original XML, I have 3 dynamic tables similar to above and all have different dynamic content. XML is received via an API call. As its dynamic not able to find best approach to save values in schema. So I have stored entire XML in a memo type variable and now trying to access its elements.

Thanks