Overview
Handling XML responses in eZintegrations enables organizations to process data from legacy systems, SOAP APIs, and older business tools. XML remains widely used in enterprise environments, and effective XML handling ensures uninterrupted data exchange and automation continuity.
eZintegrations provides built-in and AI-powered operations to convert, extract, clean, and transform XML data into structured formats such as JSON. This makes XML-based integrations easier to manage and more compatible with modern analytics, reporting, and storage systems.
When to Use
Use XML handling features in eZintegrations when working with systems that generate or consume XML-based data.
- Integrating with SOAP-based APIs
- Connecting to legacy enterprise systems
- Processing XML-based reports
- Handling base64-encoded files within XML
- Converting XML data for analytics and dashboards
How It Works
eZintegrations processes XML data through a sequence of transformation operations. Each operation performs a specific task, enabling structured and reliable data conversion.
XML to JSON
This operation converts XML text into a structured JSON object. It extracts values from defined keys and simplifies complex XML hierarchies into readable formats.
Data Extractor
Data Extractor navigates through JSON objects to retrieve specific keys and values. It removes unnecessary elements and isolates relevant data.
Substitute
Substitute replaces unwanted characters, patterns, or strings in the extracted data. It is commonly used to clean formatting artifacts from XML outputs.
Base64 Decoding
Base64 Decoding converts encoded strings embedded in XML back into their original formats, such as text files, reports, or documents.
Delimiter to JSON
Delimiter to JSON transforms comma-separated or delimited text into structured JSON arrays or objects, making data searchable and reusable.
How to Configure / How to Use
Follow these steps to process XML responses in eZintegrations.
- Configure the source system to provide XML responses.
- Add an XML to JSON operation to convert incoming data.
- Apply Data Extractor to select required fields.
- Use Substitute to clean unwanted patterns.
- Apply Base64 Decoding when encoded content is present.
- Convert delimited output using Delimiter to JSON.
- Map final JSON output to the destination system.
Alternatively, users can use AI operations to perform all transformations in a single step using natural language instructions.
Using AI-Based XML Transformation
AI operations allow users to define XML processing logic using plain English. The system automatically chains required transformations and produces structured output.
Convert the incoming {%bizdata_dataset_response%} to JSON, extract the base64-encoded
string from the 'ReportBytes' key in the nested structure, decode the base64 content,
replace any '77u/' padding with nothing, and if the decoded data is comma-delimited,
convert it into a JSON array of records under the key 'salesData'.
This approach reduces manual configuration and simplifies complex XML transformation pipelines.
Sample XML Response
The following example illustrates a typical SOAP-based XML response containing base64-encoded data.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<runReportResponse>
<ReportBytes>77u/Base64EncodedDataHere</ReportBytes>
</runReportResponse>
</soapenv:Body>
</soapenv:Envelope>
This XML contains a base64-encoded report embedded within the ReportBytes element.
Example Workflow: Oracle SOAP Report Processing
A typical use case involves connecting to an Oracle reporting system that delivers SOAP XML responses with encoded reports.
Using eZintegrations, the workflow follows these steps:
- Convert XML response to JSON.
- Extract the ReportBytes field.
- Remove unwanted “77u/” patterns.
- Decode base64 content.
- Transform comma-separated data into JSON records.
The resulting structured JSON output can be sent directly to CRM systems, dashboards, or analytics platforms.
Troubleshooting
Use the following guidelines to resolve common XML processing issues.
- Invalid XML Parsing: Verify namespace declarations and tag structure.
- Missing Data Fields: Confirm correct key paths in Data Extractor.
- Base64 Decode Errors: Ensure encoded strings are complete and properly cleaned.
- Unexpected Output Format: Review delimiter and mapping configurations.
- Pipeline Failures: Check execution logs and step dependencies.
Frequently Asked Questions
What is XML handling in eZintegrations?
XML handling refers to the process of converting, extracting, cleaning, and transforming XML data into structured formats such as JSON for downstream systems.
Can eZintegrations process SOAP responses?
Yes. eZintegrations can process SOAP-based XML responses by converting them into JSON and applying extraction and transformation operations.
Is manual scripting required?
No. Users can configure visual pipelines or use AI-based instructions without writing custom scripts.
How are base64 files handled?
Base64-encoded content is decoded using the Base64 Decoding operation and converted into its original format.
Can delimited reports be converted to JSON?
Yes. The Delimiter to JSON operation converts comma-separated or delimited text into structured JSON records.
Notes
- Use clear key paths when extracting nested XML values.
- Validate decoded content before sending to downstream systems.
- Regularly monitor execution logs for transformation errors.
- Prefer AI operations for complex multi-step conversions.
Conclusion
eZintegrations simplifies XML response handling by combining structured operations and AI-driven automation. Organizations can reliably transform legacy XML data into modern formats, reduce manual processing, and maintain efficient integration workflows.
By enabling seamless XML-to-JSON transformation and intelligent data cleaning, the platform supports scalable and maintainable enterprise automation.
