Handling XML

XML (eXtensible Markup Language) is a syntax for storing and transferring data. It is a common data format for APIs. XML data is stored in a systematic hierarchy of tags.

XML data is mostly hidden from regular Workato users because we expose data as input fields and output datapills in the recipe. However, you may occasionally require raw XML data for your use case.

Example: Nested data in XML format

We will be using this sample request body formatted in XML:

<Contact>
  <Name type="C">
    <First>Sally</First>
    <Last>Jones</Last>
  </Name>
  <Address>
    <Street verified="">215 Castro Street, Suite 300</Street>
    <City verified="">Mountain View</City>
    <ST verified="">CA</ST>
    <Postal verified="">95041</Postal>
  </Address>
  <Phone validation="1" mobile="">8444696752</Phone>
</Contact>

The XML data is stored in a top level tag <Contact>, which has nested tags <Name>, <Address>, and <Phone>. These tags further contain nested tags. This feature allows XML to create, store and transport deeply nested data.

XML parser by Workato

The easiest way to convert raw XML data into usable datapills is to parse it with the built-in XML parser. XML Parser by Workato is a native application that does not require any connection setup.

Select App > XML parser by Workato to get started.

XML parser by Workato input fields

Parse at different levels of detail

Workato automatically understands the basic XML syntax and displays datapills in the corresponding datatypes (e.g. string, integer). Configure the XML type to retrieve the desired level of detail. You can choose to configure it to simple XML without attributes or to full XML with attributes.

Simple XML without attributes

This configuration reads the default XML syntax and the type attribute. Besides the type attribute, no other attributes will be processed.

This will generate a simplified datatree and will be sufficient for most use-cases.

Datatree output for simple XML without attributes

Full XML with attributes

For certain use-cases, you would have need attribute values for validation or for syncing between systems. Choose full XML with attributes to generate a detailed datatree.

Datatree output for full XML with attributes

All attributes are now included in the output datatree. Additionally, the structure of the output is slightly different. Each XML tag is now presented as an [array] datapill with the value of the tag presented in the [Content] datapill.

Integrating XML into your workflow

Besides handling XML data within your recipe actions, working with raw XML content involves configuring your Workato recipes to receive such data. Integrate XML content into your workflow by configuring a REST endpoint that accepts raw content or by developing a custom connector.

• Rest endpoint with raw content support

Setup a callable recipe that accepts Raw body content and expose it as a REST endpoint. Now, API calls can deliver XML payload directly to the callable recipe. Find out more about setting up REST endpoints to handle XML data here.

• Developing custom connectors

Custom connectors allow you to customize the way you receive and interact with your cloud applications through API calls.

Refer to our documentation on the HTTP vs SDK for a detailed comparison.