Read XML FIle and write some data in variables

[cristiano.breveglieri]

Hi to All, I have a XML file that you can see an example there below, the need it to put in some variables the data read in the file.
I can put some of this in the variable correctly, but i can read all the other i need.

I can read and put correctly in a variables this data :
proposalNumber.value
partnerName.value
endUserName.value

I can put also the productName.value (under SKUitem) in a variable, but i cant read the second line of SKUItems and put the same data productName.value for the next node SKUItem in other variable.
I can read only the firt node data
Can you halp me to show hot need to be the For Each cycle ?

Many thanks

XML Example:

-<proposal>
<proposalNumber>Maria-03231687-01</proposalNumber>
<dealregnumber/>
<promotionalCodes/>
<quoteValidUntil>2022-06-10 00:00:00</quoteValidUntil>
<sophosContactFirstName>Maria</sophosContactFirstName>
<sophosContactLastName>Carelli</sophosContactLastName>
<contactPhone/>
<contactCell/>
<contactEmail>maria.carelli@sophos.it</contactEmail>
-<distributor>
<distributorName>INGRAM MICRO SRL</distributorName>
<addressline1>Viale delle Industrie, 14/B</addressline1>
<addressline2/>
<addresslineCity>Settala</addresslineCity>
<addresslineState>Milano</addresslineState>
<addresslinezipCode>20090</addresslinezipCode>
</distributor>
-<partner>
<partnerName>NPO SISTEMI SRL</partnerName>
<addressline1>Viale Sabotino n. 19/2</addressline1>
<addressline2/>
<addresslineCity>Milano</addresslineCity>
<addresslineState>MI</addresslineState>
<addresslinezipCode>20135</addresslinezipCode>
<partnerLevel>Platinum</partnerLevel>
<partnerAccountNumber>00344188</partnerAccountNumber>
<partnerContactFirstName>Marylise</partnerContactFirstName>
<partnerContactLastName>Cannavò</partnerContactLastName>
<partnerContactPhone>+393482243098</partnerContactPhone>
<partnerContactEmail>marylise.cannavo@nposistemi.it</partnerContactEmail>
</partner>
-<endUser>
<endUserName>C.A.S.P.I.E.</endUserName>
<addressline1>Via Ostiense 131 L</addressline1>
<addressline2/>
<addresslineCity>Roma</addresslineCity>
<addresslineState>RM</addresslineState>
<addresslinezipCode>00154</addresslinezipCode>
<endUserContacFirstName>Luca</endUserContacFirstName>
<endUserContacLastName>Lombardi</endUserContacLastName>
<endUserContactPhone/>
<endUserContactEmail>llombardi@caspie.eu</endUserContactEmail>
</endUser>
-<quoteLineItems>
-<quoteLineItem>
<productName>FG330</productName>
<description>SG 330 FullGuard</description>
<startDate>2022-06-18 00:00:00</startDate>
<endDate>2023-06-17 00:00:00</endDate>
<existingLicenseSummary/>
<sku>FG330</sku>
<utmLicenseId>1476436</utmLicenseId>
<term>12</term>
<quantity>1</quantity>
<unitMSRP>3.965,50</unitMSRP>
<MSRP>3.965,50</MSRP>
<additionalDiscountPercent>0,00</additionalDiscountPercent>
<specialTotal>3.965,50</specialTotal>
<intermediateTierMargin>10,00</intermediateTierMargin>
<intermediateTierUnit>3.568,95</intermediateTierUnit>
<intermediateTierTotal>3.568,95</intermediateTierTotal>
<margin>5,00</margin>
<unit>3.390,50</unit>
<total>3.390,50</total>
<currencyCode>EUR</currencyCode>
-<SKUItems>
-<SKUItem>
<productName>FG331CTAA</productName>
<description>SG 330 FullGuard - 12 MOS - RENEWAL</description>
<utmLicenseId>1476436</utmLicenseId>
<term>12</term>
<quantity>1</quantity>
<netChargeableQuantity>1</netChargeableQuantity>
<unitMSRP>3.965,50</unitMSRP>
<MSRP>3.965,50</MSRP>
<additionalDiscountPercent>0,00</additionalDiscountPercent>
<specialTotal>3.965,50</specialTotal>
<intermediateTierMargin>10.00</intermediateTierMargin>
<intermediateTierUnit>3.568,95</intermediateTierUnit>
<intermediateTierTotal>3.568,95</intermediateTierTotal>
<margin>5.00</margin>
<unit>3.390,50</unit>
<total>3.390,50</total>
<currencyCode>EUR</currencyCode>
</SKUItem>
</SKUItems>
</quoteLineItem>
-<quoteLineItem>
<productName>UPREM330</productName>
<description>SG 330 Premium Support</description>
<startDate>2022-06-18 00:00:00</startDate>
<endDate>2023-06-17 00:00:00</endDate>
<existingLicenseSummary/>
<sku>UPREM330</sku>
<utmLicenseId>1476436</utmLicenseId>
<term>12</term>
<quantity>1</quantity>
<unitMSRP>1.014,20</unitMSRP>
<MSRP>1.014,20</MSRP>
<additionalDiscountPercent>0,00</additionalDiscountPercent>
<specialTotal>1.014,20</specialTotal>
<intermediateTierMargin>10,00</intermediateTierMargin>
<intermediateTierUnit>912,78</intermediateTierUnit>
<intermediateTierTotal>912,78</intermediateTierTotal>
<margin>5,00</margin>
<unit>867,14</unit>
<total>867,14</total>
<currencyCode>EUR</currencyCode>
-<SKUItems>
-<SKUItem>
<productName>PR331CFAA</productName>
<description>SG 330 Premium Support - 12 MOS - RENEWAL</description>
<utmLicenseId>1476436</utmLicenseId>
<term>12</term>
<quantity>1</quantity>
<netChargeableQuantity>1</netChargeableQuantity>
<unitMSRP>1.014,20</unitMSRP>
<MSRP>1.014,20</MSRP>
<additionalDiscountPercent>0,00</additionalDiscountPercent>
<specialTotal>1.014,20</specialTotal>
<intermediateTierMargin>10.00</intermediateTierMargin>
<intermediateTierUnit>912,78</intermediateTierUnit>
<intermediateTierTotal>912,78</intermediateTierTotal>
<margin>5.00</margin>
<unit>867,14</unit>
<total>867,14</total>
<currencyCode>EUR</currencyCode>
</SKUItem>
</SKUItems>
</quoteLineItem>
</quoteLineItems>
-<totals>
<msrpTotal>4.979,70</msrpTotal>
<specialTotal>4.979,70</specialTotal>
<intermediateTierTotal>4.481,73</intermediateTierTotal>
<total>4.257,64</total>
<currencyCode>EUR</currencyCode>
</totals>
</proposal>

Many thanks
Cristiano Breveglieri

[ppr (Peter Preuss)]

@cristiano.breveglieri
Welcome to the forum

May we ask you to share the XML file as text file
But give a try on looping over all SKUItems by

For each activity |
item in Values: YourXDocVarFromDesereializeXML.Root.Descendants("SKUItem ")
Type Argument: xElement

[Yoichi]

Hi,

From structure of the XML, it might be better to get quoteLineItem first, then get SKUItem, as the following.

Sample20220523-2a.zip (3.8 KB)

Regards,

[cristiano.breveglieri]

Sorry i can’t upload the file Yet !
But Many Thanks

[cristiano.breveglieri]

Many thanks for your fast replay i solved My problem with this Sample !!

Many Many thanks