Share via

Azure Data Factory and CDATA type XML incompatibility

Shane Cossever 1 Reputation point
2020-08-25T16:56:53.52+00:00

I have created a Copy Data activity to use my HTTP XML sink and a JSON source. In mapping, all data objects and their content come across, except for any columns that contain CDATA type formatted text from my XML response.

How can I work around this? My external API source currently only supports returning data with CDATA formatting.

Thank you

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,920 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,842 questions
Azure Stack Hub
Azure Stack Hub
An extension of Azure for running apps in an on-premises environment and delivering Azure services in a datacenter.
182 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,286 Reputation points
    2020-09-01T16:32:49.45+00:00

    Hi @Shane Cossever ,

    You can try Azure Logic Apps. It supports XSLT transformations via Maps.
    And, most important, it supports XSLT 3.0 standard.
    Meaning CData sections, JSON, the whole nine yards.

    P.S. Please connect with me on LinkedIn.

  2. Nguyen, Radford 1 Reputation point
    2021-05-04T05:07:33.877+00:00

    I had the same problem: I was using a Copy Activity to merge XML files and found that all the CDATA content was thrown away.

    I got around this by using a Data Flow to union the different files. For whatever reason (maybe because it is Spark underneath), the CDATA were not ignored in the Data Flow.

    0 comments