Hi Team,
Is it possible to use a Custom Connector in Power Pages to connect with an external data source (REST API) ?
I found this question in the forum related to Power Apps Portals. I want to know whether this is now possible with Power Pages.
I walked through the Power Pages docs and found this documentation, It seems now Power Pages support using Tables from
Dataverse, But I couldn’t find documentation for using Connectors.
Regards
~Kasun
You can use the Web API to perform create, read, update, and delete operations across all Microsoft Dataverse tables from your webpages [...]
The portals Web API is built for creating a rich user experience inside portal pages. It isn't optimized for third-party services or application integration. Using the portals Web API to integrate with other Power Pages sites is also not supported.
Overview of the Power Pages portals Web API | Microsoft Learn
Hi @Anonymous, @PowerPuffKK, @ragavanrajan,
Can you update your findings using external Web APIs in Power Pages?
Thank you.
No problem at all @Anonymous. Let us know how you get on 😊
Hi @ragavanrajan , @PowerPuffKK
Thank you very much for your suggestions, I will try both methods
and update you with the results.
Regards
@Anonymous
Hi @Anonymous
Power Apps Portals was using dataverse for a long time. Dataverse is a common database which connects multiple products including power pages/portals. Please follow the instructions from @PowerPuffKK - useful information plus the virtual table was a cool feature where it allows you to connect your external databases like MySQL, SQL Server from Cloud.
In addition, instead of custom connectors you can use portal web API to retrieve the data. Adding official docs below.
https://docs.microsoft.com/en-us/power-apps/maker/portals/web-api-overview
The above still works for pages too.
You can also utilise power automate CDS connector with an HTTP trigger. Of course, Dataflows mentioned by Kristine are also the best way.
Have fun.
Cheers
Hope it helps.
------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
Hi @Anonymous ,
Unfortunately, Custom Connectors are only supported in Canvas Apps and are not available for Power Pages.
In order to render data from a REST API to Power Pages, you will need to use Dataverse Dataflows (please see below) which allows you to connect to an API. That data will then need to either be replicated to Dataverse, or presented as a Virtual Table.
I hope this answers your question - if it does, please mark it as a solution to help future forum visitors.
Kristine 😊
Share
Report
All responses (
Answers (
10
