This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
I got a clue that Dataset is missing the file which I copied to the Blob.
Any idea how do I pass the file in the parameters?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
@Anonymous Thanks for using Microsoft Q&A !!
Can you please explain how this XML file is being used in the REST Call ? By looking at the REST API documentation it looks you need to pass BODY to this API call. Do you want to use the xml stored on blob storage to be passed as BODY to this REST Call as I see you are already passing some json to this REST API body ?
You can also send an email to azcommunity[at]microsoft[dot]com with pipeline files by using "Download Support Files" from your ADF (See screenshot below) with this Q&A thread link and subject as "Attn: Saurabh' so that I can further look into your pipeline.
@Anonymous I have not heard from you. Please let me know if you need help on this.
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?
@Anonymous No, you cannot directly pass the blob file to web activity (D365FO). You can try reading the file contents first and then you can pass the content to your REST API. You can try reading the blob using the blob REST api listed over here -
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.