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