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
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.
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
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!
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.
I hope this information helps. Please do let us know in case if you have any further questions.
Thanks
Hi @lewolze
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.
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!
Check out the October 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
4 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
6 | |
5 | |
4 | |
3 | |
2 |