ADF - Copy Activity - Request Body in Source table is not considering during output

Question

ADF - Copy Activity - Request Body in Source table is not considering during output

Sam Sam 1

Hi Team, Need your help here
I am using a REST API Connection in Copy Activity and I have a specified some body in Request body parameter and When I see the output, I Observed that it is not considering the Request body
Note : I am aware that this Request Body is working fine in Web Activity and I am looking for a solution to get it worked in Copy Activity.

Thanks in advance.

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-09-10T07:40:45.013+00:00

Hello @Sam Sam

Welcome to the Microsoft Q&A platform.

I see that you are passing the request body for the 'GET' Request. I had been researching and when I checked internally, I was informed that ADF can't take requestBody for GET request at this point of time.

Alternatively, wanted to check with you if pass the same information in the Query Parameters - will you be getting in the desired results or possibility of handling Parameters at the server end (Rest API end) ?
svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-09-20T07:59:32.57+00:00

Hello @Sam Sam ,

Just checking to see whether the above information helped. Also, Please let me know if you have any questions.
svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-09-29T16:18:57.32+00:00

Hello @Sam Sam ,
Following up to see if your issue was resolved. And, if you have any further query do let us know.

1 answer

Your answer

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-09-10T07:40:45.013+00:00

Hello @Sam Sam

Welcome to the Microsoft Q&A platform.

I see that you are passing the request body for the 'GET' Request. I had been researching and when I checked internally, I was informed that ADF can't take requestBody for GET request at this point of time.

Alternatively, wanted to check with you if pass the same information in the Query Parameters - will you be getting in the desired results or possibility of handling Parameters at the server end (Rest API end) ?
svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-09-20T07:59:32.57+00:00

Hello @Sam Sam ,

Just checking to see whether the above information helped. Also, Please let me know if you have any questions.
svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-09-29T16:18:57.32+00:00

Hello @Sam Sam ,
Following up to see if your issue was resolved. And, if you have any further query do let us know.

Answer 1

Sam Sam 1

Yes - Its working from Rest API end.
However, my problem is resolved, I used PUT instead of GET.
But there might be some APIs which needs GET along with request body. So my recommendation to add request body in ADF when GET is used., Thank you

svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator

2021-11-16T05:07:02.437+00:00

,Thank you for the suggestion. We appreciate it. I would suggest you provide feedback on the same in the Feedback Portal - Azure Data factory

All the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Hope this will help. Please let us know if you have any further queries.

Share via

ADF - Copy Activity - Request Body in Source table is not considering during output

1 answer

Your answer