question

SumanMukherjee-3113 avatar image
0 Votes"
SumanMukherjee-3113 asked HimanshuSinha-MSFT commented

How to submit "form-data" in ADF "Web" activity POST call

I am trying to move data from a RESTFul API running on my on-prem application to ADB with ADF. I have installed self-paced IR in my private network to run the activity/pipeline. Now in one of my API requires form-data to submit in POST call. Equivalent Postman looks like below


202826-p1.png

Can you please suggest how to perform the same in ADF(As I will be running in self-paced IR dataflow is not applicable). I am trying with "Web" Activity but dont know how to pass form data in it. please help.




azure-data-factory
p1.png (46.0 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The curl command is as below

curl --location --request POST 'http://xxxxxx:8080/security/token' \
--header 'Connection: keep-alive' \
--header 'Accept: application/json' \
--header 'Origin: http://xxxxxxx:8080' \
--form 'grant_type="password"' \
--form 'client_id="xxweb"' \
--form 'client_secret="xxweb"' \
--form 'username="xxx_admin"' \
--form 'password="xxxxxxx"

0 Votes 0 ·

Hello @SumanMukherjee-3113,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is to know how to pass the form data content type in Web activity , please do let us know if its not accurate
I do not have an API to test that , but I think you will have update the header to use "multipart/form-data" and also have pass the data in a very specfic format . Please do read the below blog as I think it should help .
https://www.outsystems.com/blog/posts/consuming-multipart-form-data-rest-method/ .
Also what is the response type of the API is question , is it JSON . Just to let you know that ADF web activitry at this time only accepts JSON in response .
https://docs.microsoft.com/en-us/azure/data-factory/control-flow-web-activity#type-properties
Please do let me if you have any queries.
Thanks
Himanshu

0 Votes 0 ·

Hello @SumanMukherjee-3113,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

0 Answers