How to call REST API to fetch data from extrnal server in PowerApps Portal

[Dhananjay_Patil]

Hello 

I am trying to call rest API using JQuery ajax funtion in PowerApps portal.

Is there any other way to call API in PowerApps Portal?

[OliverRodrigues · Accepted solution]

if your API is a data source you can also have it under the CDS level via virtual entities: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/virtual-entities/get-starte...

if you don't need it in CDS or even your API is not a data source, you should be fine with jQuery/Ajax calls

[Dhananjay_Patil]

Than you for reply

Can I skip using CDS and connect with SQL server hosted on Azure cloud to get data and send data using jQuery/Ajax calls?

[OliverRodrigues · Accepted solution]

yes there is no problem on doing that

you can add your code in the JavaScript section of your web page 

[summitb]

You can use custom connector follow the following video.
https://youtu.be/7J0Ep3FPmJ4