Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Convert Function app to Data factory rest api connector?
![](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(179.20000000000002, 73%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Krishnamohan Nadimpalli
406
Reputation points
Hi All
I have a function app which pulls data from Rest API, but when I call this from ADF , it errors. So I decided to convert this function app API Pull to Data Factory API Pull.
Following is the code in Function App
The above function app code , I want to convert into Data Factory Rest API Connector. I have created a REST Linked service with above URL and test connection is success.
Following is the configuration I used in Copy Activity.
In above function app 4 parameters I used and in this also I am using 4 parameters. It gives error saying "Request URL: https://app.<????????>.com/api/v2/audits/posts. Response: {"error":"access_token is missing, start_date is missing, end_date is missing"},Source=Microsoft.DataTransfer.ClientLibrary,'"
Please let me know how to pass above function app parameters through data factory. And I haven't given anything in Dataset Relative URL
Azure Data Factory
{count} votes
-
Krishnamohan Nadimpalli 406 Reputation points
2023-01-25T07:06:47.9+00:00 Hi
Web activity is also failing with User configuration error and error shows as some HTML Page
Following is the error
**
Following is the configuration**
URL --> https://api.<XXXXXX>.com/api/v2/audits/posts/get?start_date='2023-01-24'&end_date='2022-01-24'&access_token='<XXXXXXXXX>'&market='United States of America'
-
![](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(54.400000000000006, 21%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Eugene Tretiak 0 Reputation points2023-02-21T22:26:04.98+00:00 I think that you need another activity to send request - Web. And after that you can process the response.
-
![](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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator2023-02-21T22:29:48.22+00:00 Hello @Krishnamohan Nadimpall,
As per the error message, API endpoint you are trying to access requires an access token and start and end dates to be passed in the request.
You can obtain an access token by following the steps in this document.
GET /api/v2/audits/posts?start_date=<start_date>&end_date=<end_date>You can replace
<start_date>and<end_date>with the desired dates in the format ofYYYY-MM-DD. -
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2023-02-24T19:32:19.05+00:00 Hello @Krishnamohan Nadimpall,
I am checking to see if you need any further assistance here.
Sign in to comment
Sign in to answer