How to pass Body Parameters(format) when calling a POST request with Content-Type as form-data in Azure Data Factory

Question

I am trying to call API endpoint as a POST and Content-Type as from-data using azure data factory web activity. Tried different way of passing Body parameters but it failed. Here is the Postman Request. Here is the Azure Data Factory Web Activity configurations.(use the body as a json and tried different combinations but all didn't work)

And above is the error message.

Any help would be highly appreciated.

Answer 1

Since your request is seen successfully executing from postman, try copying the entire body from that and use in web activity.

The format for passing body for a POST request from a web activity is shown here.

Also make sure you have entered valid “url–Target endpoint and path”. This is usually seen as Activity requires Public end point but you may have used Private vnet where this is not allowed. Web Activity is supported for invoking URLs that are hosted in a private virtual network as well by leveraging self-hosted integration runtime. The integration runtime should have a line of sight to the URL endpoint.

Note: The activity will timeout at 1 minute with an error if it does not receive a response from the endpoint.

Further going through some similar scenarios it is learnt that;

1. Mostly the header is passed as string in WebActivity whereas Postman it is integer/long
2. In case your API tries redirecting, it seems that the web activity in Azure Data Factory does not currently support following redirects, meanwhile Postman and other tools and libraries usually follow redirects by default or include a option for handling them.

Checkout the supported authentication types in the web activity. If you are trying to authorize your from, try set the following.

URL: https://login.microsoftonline.com/<<tenantid>>/oauth2/token

Headers: Content-Type - "application/x-www-form-urlencoded"

Body: grant_type=client_credentials&client_id=<<clientid>>f&client_secret=<<secret>>&resource=https%3A%2F%2Fmicrosoft.onmicrosoft.com%2F<<resourceId>>

Error code: 2108:

Message: Error calling the endpoint '%url;'. Response status code: '%code;'

Cause: The request failed due to an underlying issue such as network connectivity, a DNS failure, a server certificate validation, or a timeout.

Workaround: Make the API call using Powershell, and call that Powershell script from within Data Factory.