Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
lewolze
New Member

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!

 

3 ACCEPTED SOLUTIONS

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.

 

vcboorlamsft_0-1704703406197.gif

I hope this information helps. Please do let us know in case if you have any further questions.

 

Thanks

View solution in original post

Hi @v-cboorla-msft ,

Thank you a lot for the guide! It worked out!

View solution in original post

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!

View solution in original post

7 REPLIES 7
HimanshuS-msft
Community Support
Community Support

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 

 

 

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.

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.

 

vcboorlamsft_0-1704703406197.gif

I hope this information helps. Please do let us know in case if you have any further questions.

 

Thanks

Hi @v-cboorla-msft ,

Thank you a lot for the guide! It worked out!

Hi @lewolze 

 

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

NandanHegde
Super User
Super User

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?

 

 

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

Announcements
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.