calling a url endpoint with post

Question

calling a url endpoint with post

arkiboys 9,706

hello,

I use the copy activity to call rest API and GET json data.

The copy activity uses a rest dataset to connect to the source

Now I would like to be able to call an endpoint to do a post so that some api code is executed and Nothing needs to be returned...

do I use web or copy activity?

thanks

Accepted answer

0 additional answers

Your answer

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

@arkiboys Thanks for using Microsoft Q&A forum and posting your query.

As per my understanding your requirement is to call an API endpoint using POST method, but no return response is expected. Please correct me if I'm wrong here.

If that is the case, then you can just use Web activity with POST method.

In case if you would like to capture the API response and move that data to some other sink, then using Copy activity make sense.
Hope this information helps. Let us know if you have further questions.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

arkiboys 9,706 Reputation points

2023-07-07T05:33:17.5966667+00:00

I see. I am now trying to get the web activity to work...

In the URL, I place the URL as http://xyz...

Method as POST

Authentication is the one I have issues with

As a test, I created a REST linked service successfully with parameters such as baseurl, token endpoint, clientid, client secret, scope

1-

as a test, in the web activity, I used the Basic Authentication from the drop down list. Then I entered the client id (Which I used as a test in linked service explained above). Then used the password (The secret as I did in the linked service explained above).
The error of the web activity is:

"Invoking Web Activity failed with HttpStatusCode - '401 : Unauthorized', message - 'Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url).'
"

2-

as another test, in the web activity I set the Authentication to service principal
added the Tenant and service principal ID
service credential principal type --> service principal key
service principal key --> as same as the keyvault secret in the linkedservice mentioned above.
Resource --> https://vault.azure.net

The error of the web activity is:
Invoking Web Activity failed with HttpStatusCode - '401 : Unauthorized', message - 'Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url).'

should I be using any other Authentication to get this to work?

any suggestions

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-07-10T15:18:08.8166667+00:00

@arkiboys As per the error message it seems like the authentication details are invalid. Have you tried testing it in POSTMAN first to ensure you are using the correct details. If not, I would recommend testing the API connection from POSTMAN first and once successful use the same details to configure ADF web activity and let us know how it goes.

If you still notice the issue, I would request you to please share a screenshot of the web activity configuration by masking sensitive information.

Thank you

Share via

calling a url endpoint with post

0 additional answers

Your answer