WebActivity failed in Azure Data Factory

Anitha Eswaran 41 Reputation points MVP


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

Body contains the PayLoad Schema.

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

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

Any help would be appreciated.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,751 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Anitha Eswaran 41 Reputation points MVP

    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?

  2. Anitha Eswaran 41 Reputation points MVP

    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.

    0 comments No comments