Parameter passing differences between Web activity and Copy activity with REST dataset. Web activity success but Copy Activity error 401

Gauchet van Antwerpen 0 Reputation points
2024-10-12T08:51:52.1033333+00:00

I have a project that requires data to be imported into Azure SQL DB using Azure Data Factory from Sage 300 REST API. The REST API requires a Cookie as part of the Header of the POST method.

Data is successfully returned from SAGE using the Web activity. Below is the example of the code.Screenshot 2024-10-12 104028

Below is an example of the Copy activity used

Screenshot 2024-10-12 104244

and below is the example of the ERROR received back:

Screenshot 2024-10-12 104506

Can you please help identify how to send the Header information through so that I do not get Authorisation issues?

Kind Regards

Gauchet

Azure API Management
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
2,130 questions
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,708 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.