Jitterbit · Transformations

Failed to convert XML file to JSON

Short answer

This Jitterbit transformation error means XML embedded in JSON contains a CDATA section, which is not supported. In a Jitterbit script, use Replace to swap the special characters inside the CDATA section, including the CDATA delimiters, for their escaped equivalents.

VerifiedLast verified

01Error text

Jitterbit error
Failed to convert XML file to JSON

02Likely causes

  • CDATA sections are not supported in XML embedded within JSON passed through a transformation.

03How to fix it

  1. In a Jitterbit script, use Replace to swap the special characters inside the CDATA section, including the CDATA delimiters, for their escaped equivalents.
  2. If targeting only the CDATA section is not feasible, replace the entire XML string that contains it.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.