We want to copy xml data from a soap post to sql server via a self hosted integration runtime.
As an interim stage we are saving to Avro blob storage from a soap post (we chose avro since xml blob storage can't be used as a sink https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-blob-storage#copy-activity-properties) but the first part of the xml file has an encoding issue (url elements) which prevents this file from being used as an xml mapping source for a subsequent copy pipeline activity. If we manually remove the following problematic elements from the blob file the subsequent copy to sql works fine (mapping works).
How to fix this?
Thanks