Skip Navigation

CSV data adapter sample output XML

The CSV data adapter generates output similar to the following example. Each output node is described after the example.
The output is dependent on the configuration of the CSV data adapter. The following example output shows only the general structure.
<IntegrationData from="CsvDataAdapter"> <users> <user> <Username>jdoe</Username> <Firstname>John,Firstname</Firstname> <Lastname>Doe'Lastname</Lastname> <OrgH>/USA/</OrgH> <Date>01/11/2019</Date> <DateTime>01/11/2018 11:11:59</DateTime> <AllUsers>Yes</AllUsers> </user> <user> <Username>Janedoe</Username> <Firstname>Jane</Firstname> <Lastname>Doe</Lastname> <OrgH>/Germany/</OrgH> <Date>01/11/2019</Date> <DateTime>01/11/2018 11:11:59</DateTime> <AllUsers>Yes</AllUsers> </user> </users> </IntegrationData>
<IntegrationData>
: This is a root node in the output XML. It has following sub nodes:
  • <users>
    : This node represents all users that were read from .csv files. There is a separate <user> node in the <users> node for each user.
    • <user>
      : This node encloses other attributes for users. It can have one or many nodes as defined in the CSV data adapter configuration file. Each child node is one of the columns defined in the <csvColumns> node in the CSV data adapter configuration file.