Both eXtensible Markup Language(XML) and Comma Separated Value(CSV) was designed to store and transport data. XML is a markup language that defines a set of rules for encoding documents in a format that is both human and machine readable. CSV file stores tabular data in plain text, each line of the file is a data record. Syncfusion Data Integration Platform has an efficient support to handle both CSV and XML files in terms of validating their schemas, parsing the CSV and XML file.
Set up connection
Create an CSVReader and CSVRecordSetWriter service globally or specific to a data flow to simplify configuring the schema and csv properties to access CSV files.
The connected workflow will execute automatically in the background using a scheduling strategy (timer driven, CRON driven, event driven, or run once), or on-demand via an API or the Start and Stop buttons in the Operate panel.