XML Universal Connector

XML, or Extensible Markup Language, is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. It is commonly used for structuring and storing data, including text and metadata, and for exchanging information between different systems, making it a versatile format for data representation and exchange.

How to Create an XML Data Source

Fill in Basic File Information

1. On the Sources page, click on the Create Source button and select the connector from the list.
2. Select the HTTP method to define a set of request methods.
3. Insert the URL of your file. Here, you can also specify a date range.
4. If authorization is needed, select your account.
5. Select your snapshot keeping policy.

Specify Your HTTP Request

1. In the Transformation Pipeline window, define a short script to process the data from these APIs. You can also click on the Get transformation button. In most cases, it will auto-generate a transformation script for you.
   
2. Define your HTTP headers, name-value pairs that will be included in the request and response messages of the HTTP protocol. In most cases, you will need to set this parameter for authorization or setting the content type.
3. [Optional] On the HTTP Body tab, you can see the data transmitted in an HTTP transaction message.
4. On the Schedule tab, choose your sync frequency or the exact synchronization time.

Preview Data and Save Your Data Source

1. Make sure your transformation script has array symbols (square brackets [ ] ).
2. Click on the Get Data button to test your transformation and see a preview of the table.
3. Click on Save Source and congratulations, your new data source is ready!