- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Microsoft Fabric connection to REST API
Hello,
I am trying to connect to REST API.
https://developer.veevavault.com/api/23.3/#retrieve-common-document-fields
And it seems I lost the track where I should start. I am new in that.
Should I make Dataflow or Pipeline? It seems both option can be implemented:
https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-pipeline-dataflow-spark
1. Dataflow: I tried to use WEB API connector, but it is always failed. I used User/Password authentification.
2. Pipline: I tried WEB and WEB V2 connection for Copy Activity with different type of authentification but I failed again.
Can you please help me with a brief guide? It seems I do something wrong just at the begining.
Thank you!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @lewolze
Thanks for using Microsoft Fabric Community.
As I understand that you are trying to connect to REST API in Fabric.
Could you please follow the below steps for connecting REST API in Fabric using Pipeline.
I hope this information helps. Please do let us know in case if you have any further questions.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @NandanHegde,
Thank you for the article.
I usually check with Windows PowerShell. All good.
I did the pipleline and it wokred out! Thanks a lot!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @lewolze ,
I have not used this particular API in the past and I do not have a first hand experience on the same . But I have always used the postman to testing the payload and if that works I tried to implement the same in dataflow/pipeline .
Did you tried the postman option and did it worked ? I will start with postman first before doing anything at all .
Thanks
Himanshu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Himanshu,
Thank you for the reply. Yes, I usually check with Windows PowerShell.
I managed to call 'SP Metadata' (I found this link in SAML Single Sign-on Configuration). At least, authentification worked out and I got the response from API. I'll try to call some data/documents soon.
I'll keet you updated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @lewolze
Thanks for using Microsoft Fabric Community.
As I understand that you are trying to connect to REST API in Fabric.
Could you please follow the below steps for connecting REST API in Fabric using Pipeline.
I hope this information helps. Please do let us know in case if you have any further questions.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @lewolze
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For connecting a REST API, web activity within the pipeline is sufficient.
Below is a sample blog to access an Azure REST API leveraging web activity:
https://www.c-sharpcorner.com/article/invoke-azure-data-factory-pipeline-via-msft-fabric/
Can you please share the web activity settings/config and what error you are getting?
And were you able to test the same config of accessing the REST API via postman or some extranl way?
----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @NandanHegde,
Thank you for the article.
I usually check with Windows PowerShell. All good.
I did the pipleline and it wokred out! Thanks a lot!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-27-2024 11:15 PM | |||
Tuesday | |||
10-25-2024 08:47 AM | |||
12-13-2024 07:51 AM | |||
Anonymous
| 03-17-2024 11:20 PM |
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |