topic Re: Microsoft Fabric connection to REST API in Dataflow

Microsoft Fabric connection to REST API

lewolze — Thu, 04 Jan 2024 12:50:21 GMT

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!

Re: Microsoft Fabric connection to REST API

NandanHegde — Thu, 04 Jan 2024 13:28:07 GMT

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?

Re: Microsoft Fabric connection to REST API

HimanshuS-msft — Fri, 05 Jan 2024 19:09:01 GMT

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

Re: Microsoft Fabric connection to REST API

v-cboorla-msft — Mon, 08 Jan 2024 09:00:10 GMT

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

Re: Microsoft Fabric connection to REST API

lewolze — Mon, 08 Jan 2024 14:58:21 GMT

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.

Re: Microsoft Fabric connection to REST API

lewolze — Mon, 08 Jan 2024 15:01:00 GMT

Hi v-cboorla-msft ,

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

Re: Microsoft Fabric connection to REST API

lewolze — Mon, 08 Jan 2024 15:02:59 GMT

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!

Re: Microsoft Fabric connection to REST API

v-cboorla-msft — Mon, 08 Jan 2024 15:33:06 GMT

Hi lewolze

Glad that your query got resolved.

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