XML tools by Workato ​

XML tools by Workato provides actions to extract values, transform XML structures, and process attributes, enabling seamless recipe integration.

XML (eXtensible Markup Language) is a widely used format for storing and exchanging data, especially in APIs. Workato recipes typically expose XML data as input fields and datapills, but some workflows require direct interaction with XML content.

How XML tools by Workato works ​

XML tools by Workato provides the following actions to process XML data:

• The Parse XML document action extracts values from XML and converts them into datapills for use in recipes.

• The Parse XML document (Deprecated) action is deprecated. Use the Parse XML document action instead.

• The Generate XML document from XSD action generates an XML document that follows the structure and data types defined in an XML Schema Definition (XSD) file.

• The Generate XML document from a sample XML action generates an XML document based on the structure inferred from a sample XML payload. Use this action when an XSD isn't available, or when your XSD contains anyType or wildcard elements that can't be mapped directly.

• The Transform XML using XSLT action applies an XSLT script to transform XML into another XML structure, JSON, HTML, plain text, or other formats for compatibility with external systems. You can provide the XSLT inline or select a resource as the stylesheet.

• The Transform XML using XSLT (Deprecated) action is deprecated, doesn't support resources, and requires you to define the XSLT script inline. Use the Transform XML using XSLT action instead.

• The Validate XML document with XSD action checks an XML payload against an XSD to confirm it meets the expected structure, content, and data types.

Setup ​

This connector doesn't require authentication or a connection setup.

Handle large XML documents ​

XML tools by Workato actions support XML payloads up to 10 MB at runtime by default. This applies to actions that process XML documents, such as parsing, generating, transforming, and validating XML.

The Parse XML document action supports payloads up to 200 MB when you set Enable streaming? to Yes.

Enable streaming ​

The Enable streaming? field controls how the Parse XML document action handles XML payloads at runtime.

• No (default)

• The action supports XML payloads up to 10 MB and returns the parsed output as datapills. Results return faster, which makes this the right choice for smaller payloads.

• Yes

• The action supports XML payloads up to 200 MB. Workato writes the parsed JSON to file storage and returns it as a reference. Streamed processing is optimized for throughput.

Set Enable streaming? to Yes when you anticipate large XML payloads.