0

I have receive port and simple XML:

<root id = “1” name = “name” >
<childs>
<chilId id = “2” />
</childs>
</root>

BAM Activity:

 id – BD Integer
 name – BD Text
 childId – BD Integer

Then bind using TPE message fields to activity fields.

 id = root -> id
 name = root -> name
 childId = root.childs.child -> id

But in DB I get empty field [childId]. XSD:

<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns="http://BizTalk_Test.InMsg" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http://BizTalk_Test.InMsg" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="root">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="childs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="child">
                <xs:complexType>
                  <xs:attribute name="id" type="xs:int" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
      <xs:attribute name="id" type="xs:integer" />
      <xs:attribute name="name" type="xs:string" />
    </xs:complexType>
  </xs:element>
</xs:schema>

Simple message:

<root xmlns="http://BizTalk_Test.InMsg" id = "1" name = "Test 1" >
<childs>
<child id = "1" />
</childs>
</root>

Result in DB:

id  Name    childId
1   Test 1  NULL
Dijkgraaf
  • 11,049
  • 17
  • 42
  • 54

0 Answers0