WebActivity failed in Azure Data Factory

Anitha Eswaran 41 Reputation points MVP
2021-01-27T10:10:23.997+00:00

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

60951-df1.png

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

60779-df2.png

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

60961-df3.png

60858-df4.png

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.

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
    2021-02-01T08:53:51.453+00:00

    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
    2021-02-05T07:50:56.363+00:00

    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