Re: Evaluating on the amount of items returned in a message

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Evaluating on the amount of items returned in a message › Re: Evaluating on the amount of items returned in a message

October 6, 2009 at 12:37 PM #23410
community-content

    Hi Daniel,

                      Can I just give you a summary of where I am so not to waste too much of your time before I deploy and test?

     

    Shape

     Expression

    nLoopCount =1;

    nMessageCount = 1;

    Loop start

    nLoopCount <= nRecordCount

    Decide Shape

    nLoopCount <= 30 & nMessageCount == 30

    Atomic Scope

    vXmlNodeList = xpath(BACSRemittanceMsg, “System.Convert.ToString(//*[local-name()=’BACSRemittance_DATA’ and namespace-uri()=’http://P5.BizTalk.Schemas.PP_SAPToBottomlineBACSRemittance_App_FF’%5D/*%5Blocal-name()=’BACSBody&#8217; and namespace-uri()=”]/*[local-name()=’BACSRemittance’ and namespace-uri()=”]/*[local-name()=’Remittance’ and namespace-uri()=”]/*[local-name()=’RemittanceDetail’ and namespace-uri()=”]/*[local-name()=’BACSRemittance_DATA’ and namespace-uri()=’http://P5.BizTalk.Schemas.PP_SAPToBottomlineBACSRemittance_App_FF’%5D/*%5Blocal-name()=’BACSBody&#8217; and namespace-uri()=”]/*[local-name()=’BACSRemittance’ and namespace-uri()=”]/*[local-name()=’Remittance’ and namespace-uri()=”]/*[local-name()=’RemittanceDetail’ and namespace-uri()=”][” + nLoopCount + “]”));

     

    vXmlNode = vXmlNodeList.Item(0);

    MyVar = MyVar + vXmlNode.InnerText;

     

    Expression Add count

    nLoopCount = nLoopCount + 1;

    nMessageCount = nMessageCount + 1;

    Any mistakes ?

    Grant