Data Factory - Rest API Sink issues in Copy Activity

Question

Hello, I need help in ADF-Rest API connectivity. My task is 'to pass data from sql table to rest API using post method'.
I'm getting the error(attached below)'Rest call was not successful'. In the linked service, I tried basic and anonymous authentication,getting same error for both.

But I can call the same API using Web task and it works fine. Don't know why the behavior is different in Web activity vs copy activity for Rest Sink.
Can anyone help me in fixing this?

Answer 1

Hello @Edwin ,
Thanks for the ask and using the Microsoft Q&A platform .

In your case if the web activity is working fine that means that linked service is setup correctly . You should try to have the same setup for copy activity also .

One more thing since you are using POST , I am confident that the you are passing the payload as JSON .In case of the copy activity are you converting the data as JSON ? if not you can use the JSON AUTO option in the select clause and make it happen .
If you are still facing issues please share the pipeline snapshots , that will help us a lot.

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members