Prerequisites

In order to export XML data, you must first find the XSD file which provided the data shape for your export. The XSD describes the expected elements and data types within the XML, and is required for the mapping tool to correctly identify and format the fields. 

Data Export Definitions general configuration 

In the Data Export Definitions application, create a new record then:

  • Enter the name of the table that holds your data. This could be a regular platform table, or an integration table.  
  • In the Export Format field, select XML. 
  • Open Attachments from the form action menu and upload the XSD file which holds the shape of your data. 

Mapping Configuration

On the Mappings page, map your internal data into the XML file shape. The column generated on the left of the Viewer panel holds your internal table fields. The column on the right holds your XSD data shape which you must map into. Mapping considerations include: 

  • You can expand composite objects to see their attributes. For example, if you expand an Amount field, you will see attributes for currency code, decimals, and display precision. You can also choose to map an entire composite object, such as an entire address, to the XML side. 
  • If your source field has a null value, you do not map a value to an element, or the element does not have any nested attributes, the No Data Mode field in the Properties panel controls what is shown. 
    • Attributes have a default No Data Mode provided by the XSD file, but can be changed during configuration. For example, if an XSD defines that an element has minOccurs = 0, the element is omitted by default. Or, if an element is marked as nillable, the No Data Mode is Nill by default. If there is nothing defined for the No Data Mode, objects an attributes are defaulted with an empty value. 
    • The Omit from XML option in the No Data Mode field is useful for removing unnecessary content from your file.
    • You can optionally map values through a logic block transform. This involves configuring a logic block of type Data Mappings, then using the Logic Block option from the Element Palette panel. This allows you to input a value, transform it with the logic block, then output the value to the output file. 
  • On the Output File Details page, specify the file location type and name your file.  
  • Select the Run Export form action. 
  • Once you receive a notification that the export has succeeded, go to the Data Export Runs page and select the Attachment row action on the record of your export. 

There is a maximum output file size of 200MB.