Orchestration expression and using the xpath function

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Orchestration expression and using the xpath function › Orchestration expression and using the xpath function

December 15, 2005 at 7:53 PM #12539
community-content

    Greetings,

    Relatively new to Biztalk and trying to use the xpath function in an expression to extract a value from an XML document. I can validate an xpath query using XML Spy but can’t seem to get it to work in Biztalk. Here is the XML I am trying to query:

    -<ns0:ProductionPerformance xmlns:ns0=\”http://www.wbf.org/xml/b2mml-v02\”>[/code] <ns0:ID>WOSN9999</ns0:ID>
    <ns0:PublishedDate>2005-12-15T08:18:44</ns0:PublishedDate>
    – <ns0:ProductionResponse>
    <ns0:ProductionRequestID>WOSN9999</ns0:ProductionRequestID>
    – <ns0:SegmentResponse>
    <ns0:ID>WOSN9999_ZZZ_WorkCell99</ns0:ID>
    <ns0:ProcessSegmentID>WorkCell99</ns0:ProcessSegmentID>
    – <ns0:MaterialConsumedActual>
    <ns0:MaterialDefinitionID>MaterialConsummedPart9999</ns0:MaterialDefinitionID>
    <ns0:MaterialLotID>Serial999</ns0:MaterialLotID>
    <ns0:MaterialSubLotID />
    – <ns0:Location>
    <ns0:EquipmentID />
    <ns0:EquipmentElementLevel>Site</ns0:EquipmentElementLevel>
    </ns0:Location>
    – <ns0:Quantity>
    <ns0:QuantityString>1</ns0:QuantityString>
    <ns0:DataType>decimal</ns0:DataType>
    <ns0:UnitOfMeasure>EA</ns0:UnitOfMeasure>
    </ns0:Quantity>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>BatchFlag</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>N</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>Operation</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>10</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>InterfaceFlag</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>I</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>SerialNumber</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>Serial999</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>SAPInterface</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>IN0054A</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>SerializedFlag</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>N</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>BatchNumber</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>Batch999</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>EventDateTime</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>12/15/2005 8:18:39.013 AM</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>BackFlushIndicatorFlag</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>N</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    – <ns0:MaterialConsumedActualProperty>
    <ns0:ID>BulkIndicatorFlag</ns0:ID>
    – <ns0:Value>
    <ns0:ValueString>N</ns0:ValueString>
    <ns0:DataType>string</ns0:DataType>
    <ns0:UnitOfMeasure>unit</ns0:UnitOfMeasure>
    <ns0:Any />
    </ns0:Value>
    </ns0:MaterialConsumedActualProperty>
    </ns0:MaterialConsumedActual>
    </ns0:SegmentResponse>
    </ns0:ProductionResponse>
    </ns0:ProductionPerformance>

    Ultimately, I wish to return the value \”IN0054A\” which in under the \”SAP Interface\” node. Would someone please help me construct this xpath expressio 😕 n that works in BizTalk? My thanks in advance!