You are here:
Convert XML
This data extract type converts XML files to delimited files so that you can import them into data extensions. Use this extract for simple XML files only. Files that have subnodes on attributes require a different process. Contact Salesforce Support for additional information.
The Convert XML data extract requires the information described in this table.
| Field | Description |
|---|---|
| Name | The name of the data extract. |
| External Key | A unique ID that identifies the extract in API requests. |
| Description | A description of the data extract. |
| File Naming Pattern | The name of the file created by the extract process. You can include these wildcards:
|
| CreateColumnHeaders checkbox | This checkbox indicates whether the XML file used in the conversion contains information used to create column headers. If the XML file does contain this information, you can map the resulting delimited file for import by column heading. If the XML file doesn’t contain header information, map the delimited file by ordinal when you import the data. |
| FileFormat | Indicates the file type for the exported file:
The default value is |
| InputFileName | The XML file for the activity to convert. This activity requires files on your FTP server. The activity creates the output file in the same location on the FTP server. |
| QuoteCharacter | The quote character to use to differentiate attributes in the XML file from the element names. |
The last field contains the name of the element for which the converting process creates a row.
Example This example XML file uses /subscribers/subscriber to indicate when a new record
starts:
<subscribers>
<subscriber>
<first_name>Lee</first_name>
<last_name>Billings</last_name>
<email>lbillings@example.com</email>
</subscriber>
<subscriber>
<first_name>Kris</first_name>
<last_name>Rogers</last_name>
<email>kris_rogers@example.com</email>
</subscriber>
</subscribers>Did this article solve your issue?
Let us know so we can improve!
