**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

The package contains 3 custom activities for conversion of XML to other data formats:

1.     XML to DataTable

2.     XML to JSON

3.     XML to CSV

These activities can handle all types of complex and nested XML either in a text file (specified in the input property InputXmlFilePath) with valid XML in it or it accepts XML string directly (specified in the input property InputXmlString) and creates an output CSV file or JSON file, at user's designated path (specified in the input property OutputCSV/JSONFilepath) , or generates a DataTable from the input XML.

*   XML to CSV: To view the data in tabular format, output CSV file can be opened using Excel. The first row in Excel will be the headers, generated from all the tag names in XML file. In case of multi-level nested XML, it retains the complete path of each element, separated by slash '/'.
*   XML To JSON: This activity converts XML in Json format without any data loss. In case of Array, element tags are added for each array element and in case of non-array objects XML keys are converted to JSON tags and XML values are converted to JSON inner text. Output of this activity should be .json file.
*   XML To DataTable: It converts input XML to Datatable and provides the flexibility of directly applying all Data Table functions like filtering the XML Data. In case of Array, each Data row is converted to Excel Row Item and in case of non Array structure, all the tags generate headers and in case of multi-level nested XML, it retains the complete path of each element, separated by slash '/' so as to prevent any data loss.

Time taken for this conversion is proportional to the level of nested data structure of XML (between milliseconds to few seconds).

**Input Properties**

InputXmlFilepath - Takes path of text file which contains valid XML.

InputXmlString (Optional, if InputXmlFilepath is not passed) - Takes input as XML string. Use Read Text file &gt; Deserialize XML &gt; pass the generated XML with tag name.

OutputCSV/JSONLFilePath - Takes path of CSV or JSON file in which the output will be generated. The CSV/JSON file will be generated at this path even if it is not present.

**Output Properties**

Output DataTable – It generates a DataTable from input XML and provides an option of saving it in a DataTable type of variable.

**Note**:

*   Among InputXmlFilepath and InputXlString properties, only 1 input is allowed to be passed for all these activities and It is a mandatory input property.

·       Output XmlFilePath and Output DataTable are mandatory output fields

A package of 3 custom activities which accepts any complex XML as input and converts it into Data Table, JSON and CSV files.

XML Conversion Activities