XML Target Table Logic

Explanation: XML with one contact.

Thumb Rule: The Complex or Simplex type must be repeated to be treated as a candidate for table.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<OrganisationName>ACXIOM</OrganisationName>

<CustomerAbbreviatedName>ACXIOM</CustomerAbbreviatedName>

<AccountType>External</AccountType>

<CustomerCategory>Insight</CustomerCategory>

<CustomerClass>INSIGHT</CustomerClass>

<CustomerUrl>http://www.acxiom.co.uk/about_us/Pages/AboutAcxiom</CustomerUr>

<CustomerProspectCode>CUSTOMER</CustomerProspectCode>

</CustomerInformation>

<ContactId>SF-0032000000gmMcIAAU</ContactId>

<FirstName>Gerry</FirstName>

<LastName>Groome</LastName>

<JobTitle>Marketing Co-ordinator</JobTitle>

<Email>gerry.groome@acxiom.com</Email>

</Contact>

</Customer>

</CustomerData>

•When you parse the XML, the “CustomerData” table populates in the target table.
•The “CustomerData” table consist simplex type field of customer and contact merged together.
•After the “Contact” merges with “CustomerData”, the XML Target Connector cannot merge the “Contact” in other synchronization task.
•If you want the contact as a table then you need to paste the contact section in the XML file before saving.

Explanation: XML with two contacts.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<OrganisationName>ACXIOM</OrganisationName>

<CustomerAbbreviatedName>ACXIOM</CustomerAbbreviatedName>

<AccountType>External</AccountType>

<CustomerCategory>Insight</CustomerCategory>

<CustomerClass>INSIGHT</CustomerClass>

<CustomerUrl>http://www.acxiom.co.uk/about_us/Pages/AboutAcxiom</CustomerUr>

<CustomerProspectCode>CUSTOMER</CustomerProspectCode>

</CustomerInformation>

<ContactId>SF-0032000000gmMcIAAU</ContactId>

<FirstName>Gerry</FirstName>

<LastName>Groome</LastName>

<JobTitle>Marketing Co-ordinator</JobTitle>

<Email>gerry.groome@acxiom.com</Email>

</Contact>

<ContactId>SF-0032000000gmMcIAAU</ContactId>

<FirstName>Gerry</FirstName>

<LastName>Groome</LastName>

<JobTitle>Marketing Co-ordinator</JobTitle>

<Email>gerry.groome@acxiom.com</Email>

</Contact>

</Customer>

</CustomerData>

•In this XML file, the Contact is repeated twice.
•When you try to parse the XML using the XML Target Connector, the target table populates with CustomerData and Contact. You can merge contact with CustomerData.