I have a small(?) issue. With the test data I've used to develop the orchestration my xml didn't have a namespace, but the real, live data has. This has resulted in that all my xpath queries are broken
This is a sample xml:
<MY_HEADER xmlns="http://tempuri.org/MyRequest.xsd">
<SOEK Navn="Something">
<OPERATOR>
<PARAMETER>SSN</PARAMETER>
<VERDI>23456778</VERDI>
</OPERATOR>
<OPERATOR>
<PARAMETER>Date</PARAMETER>
<VERDI>1900-01-01T00:00</VERDI>
</OPERATOR>
</SOEK>
</MY_HEADER>
Without the namespace, to get the value (verdi) of the SSN operator all I had to do was:
Variable_SocialSecurityNumber = xpath(Message_MyRequest, "/MY_HEADER/SOEK/OPERATOR[PARAMETER='SSN']/VERDI");
I've seen how biztalk generates xpath for promoting items that works for this xml, but I'm unsure how to do the [PARAMETER='SSN'] bit with that. And the code biztalk uses isn't very readable (for me anyway)
Any ideas?