xpath in orchestration – Problem

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › xpath in orchestration – Problem

Viewing 1 reply thread
  • Author
    Posts
    • September 11, 2006 at 3:17 AM #15641
      community-content

        Hi Pros, (Hi Stephe)

        I have an Xpath problem! My orchestration receives the response of a procedure call (throught the sql adapter, sql port)

        The dumped output doc <the output is spOut.parameters> looks like

        <spResponse>

           <dbo.Person att1="val" att2="val" ……. />

        </spResponse>

        When I execute

        personCount = xpath(xmlDom,"count(./spResponse/dbo.Person)"); // xmlDom holds the output doc,

        personCount yields 0 which is really weird! any tips available?

        Thanks,

         

      • September 11, 2006 at 11:22 AM #15652
        community-content

          is spResponse the root node?

          Have you tried personCount = xpath(xmlDom,"count(/spResponse/dbo.Person)");

          • September 11, 2006 at 11:53 PM #15658
            community-content

              I've tried every possible XPath xpression

              count(/spResponse/dbo.Person)

              count(//spResponse/dbo.Person)

              count(spResponse/dbo.Person)

              count(//dbo.Person)

              All of these expressions yield 0 !!! the <dbo.Person> node is there !! how come ?!

              Help! Por favor !

              • September 12, 2006 at 7:30 AM #15661
                community-content

                  Have you tried writing a simple.net app to try to xpath out the data?  If your expression is wrong, that can usually help catch it (using SelectSingleNode).

                   

                  Might want to open the schema up inside BizTalk and view the node’s xpath expression in the editor.  That might point out an error as well.

                   

                  Also, double check namespaces since they play a key role in xpath inside BizTalk.

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.