xpath of a field (loop)

Question

Hi I have the following xml, I want to loop through each of the item record and get the value of Description from it.

intCount = intMakeCnt + 1;

strXPath = System.String.Format("string(//*[local-name()='item'][{0}]/*[local-name()='Description']/text())", intCount );

But it is giving strXPath as empty . Please advice

<root type="object">
	<ValuationProvider type="string">Geico</ValuationProvider>
	<Data type="array">
		<item type="object">
			<Id type="string">Acura</Id>
			<Description type="string">Acura</Description>
			<AdditionalId type="string"/>
		</item>
		<item type="object">
			<Id type="string">Audi</Id>
			<Description type="string">Audi</Description>
			<AdditionalId type="string"/>
		</item>
		<item type="object">
			<Id type="string">BMW</Id>
			<Description type="string">BMW</Description>
			<AdditionalId type="string"/>
		</item>
		
	</Data>
	<ContinueActionAfterException type="boolean">false</ContinueActionAfterException>
	
</root>

---

RH

Answer 1

Where are you actually executing the XPath, as all you look to be doing there is creating a string containing a XPath expression.  Are you saying that the string you are creating is empty?

Answer 2

Duplicate. Refer to https://social.msdn.microsoft.com/Forums/biztalk/en-US/bfc51093-72e4-469e-94d8-4deb925c639b/issue-with-xpath-expression-when-doing-looping?forum=biztalkr2adapters

---

Rachit Sikroria (Microsoft Azure MVP)