Microsoft Fabric connection to REST API

[lewolze]

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!

[v-cboorla-msft · Accepted 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

[lewolze · Accepted solution]

Hi @v-cboorla-msft ,

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

[HimanshuS-msft]

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 

[lewolze]

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.

[v-cboorla-msft · Accepted 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

[lewolze · Accepted solution]

Hi @v-cboorla-msft ,

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

[v-cboorla-msft]

Hi @lewolze 

Glad that your query got resolved.

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

[NandanHegde]

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?

[lewolze · Accepted solution]

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!