WebActivity failed in Azure Data Factory

Question

Hi,

I am new to Data factory and I am trying to do call a REST API in D365FO using Web activity.

Given below my pipeline design

First step copies the XML file to a BLOB . (This is successful)
Second step generates an authentication token (This is successful as well)
Third step calls the URL to post the data to D365FO

The URL is calling the enqueue to push data to D365FO
https://D365FO7751ff07f8aa9d4bdevaos.cloudax.dynamics.com/en/api/connector/enqueue/%7BD18ADD0A-BDDA-4B1A-9EAC-3F55F7B079FB%7D?entity=Customer%20Groups

Body contains the PayLoad Schema.
60937-requestbody.txt

Authentication is passed to the Import step ,but it failed with the below error

The input to this step is passed and the values are
60962-requestinput.txt

I am not getting a proper idea on the error message.

Any help would be appreciated.

Answer 1

Hi Sourabh,

I tried passing the data in Body in Json format and it imported successfully.

Now I am trying to read the file stored in BLOB to the web activity for importing in D365 FO.

Could you guide me on this ?

Is it possible to pass a file or set of records to web activity?

Answer 2

Thanks Sourabh. As you suggested, I read the contents to Json file Data flow and using look up sent the data to the REST API.