How can I load an XML file from an S3 folder using Hevo?

To load your XML files from your S3 folder, specify the path to the folder in the Path Prefix field and select XML in the File Format drop-down in the Configure your S3 Source page during Pipeline creation.

Once the Pipeline is created, all your XML files present in the folder get replicated into the Destination table. You can verify this in the Schema Mapper as shown in the following image:

NOTE: You can only load files of a single format in each Pipeline. To load files of different formats, you need to create separate Pipelines for each format. Read Creating a Pipeline.

Revision History