Failure happened on 'Sink' side. ErrorCode=UserErrorKeyConflict,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Key Content-Type conflicts in AuthHeaders/AdditionalHeaders,Source=Microsoft.DataTransfer.ClientLibrary,'

Question

I am trying to post file using rest connector, but it is not allowing to add additional headers for Content-Type - as it is by default applying content-type as application/json, what if, i need to use different content-type. I believe it should be allowed to use custom Content-Type and not limited to application/json. This is a Gap. I know it can also be achieved using web activity and azure function but i want to use copy activity rest connector to post the data as it can handle more than 5 MB.

Answer 1

The error you are encountering indicates a conflict with the Content-Type header when using the REST connector in Azure Data Factory. The REST connector automatically sets the Content-Type header to application/json and ignores any Accept header specified in additionalHeaders. Unfortunately, this means that you cannot customize the Content-Type header for requests made through the REST connector.

If you need to use a different Content-Type, you might consider alternative methods such as using a web activity or an Azure function, as you mentioned. However, these alternatives may not support the same data size limitations as the copy activity.

---

References:

• Troubleshoot the REST connector in Azure Data Factory and Azure Synapse
• Copy and transform data from and to a REST endpoint by using Azure Data Factory