# XML tools By Workato - Handling and Parsing XML
XML tools by Workato is the new and improved XML parser by Workato with enhanced feature set.
XML (eXtensible Markup Language) is a syntax for storing and transferring data, commonly used in APIs. XML data is stored in a systematic hierarchy of tags.
Because data is exposed as input fields and datapills in recipes, XML data is mostly hidden in Workato. However, if your workflow requires processing raw XML data, you can use the XML tools by Workato connector's Parse XML action. This is the easiest way to convert raw XML data into usable datapills.
No connection configuration is required for this connector.
When setting up this connector, you'll need to configure the following input fields:
|XML type||The level of detail to parse the XML. Datapills will be typed using the data type from the XML - for example, |
Select one of the following options:
|Sample document||A sample XML document that has the same format as the XML data to be parsed.|
|Document||The input XML data to be parsed.|
The output will be the parsed XML data. The structure of the output datatree is dependent on the XML type you select.
Let's say we need to parse the following XML:
<list> <Contact> <Name type="C"> <First>Donna</First> <Last>Noble</Last> </Name> </Contact> <Contact> <Name type="C"> <First>Rose</First> <Last>Tyler</Last> </Name> </Contact> </list>
Click below to see what the datatree would look like for each of the XML type options:
SIMPLE XML WITH NO ATTRIBUTES
. List └── Contact ├── Name | ├── Type (C) | ├── First (Rose) | └── Last (Tyler) ├── List size └── List index
FULL XML WITH ATTRIBUTES
. List ├── Contact | ├── Name | | ├── Type (C) | | ├── First | | | ├── Content (Rose) | | | ├── List size | | | └── List index | | ├── Last | | | ├── Content (Tyler) | | | ├── List size | | | └── List index | | ├── List size | | └── List index | ├── List size | └── List index ├── List size └── List index
# Integrating XML Into Your Workflow
Working with raw XML data in recipes is a two step process: Handling the data in recipe actions and configuring your recipes to receive XML data.
Workato provides a few ways to accomplish the latter:
Develop a custom connector. Custom connectors allow you to customize how you receive and interact with your cloud applications through API calls. Use the following options to DIY a connector:
HTTP connector - This connector provides a convenient way to handle raw data from APIs. Check out the HTTP connector course (opens new window) for more info.
Connector SDK - An extension of the Workato framework, the Connector SDK provides everything developers need to build, maintain, and distribute connectors. Check out the Workato SDK documentation for more info.
Not sure which option is right for you? Check out the HTTP vs. SDK guide for a detailed comparison.
Last updated: 7/6/2023, 3:41:20 AM