Showing results for 
Search instead for 
Did you mean: 
New Member

How do I connect to a generic WebAPI through the MSFT Data Gateway using Power Automate?

This might be a simple question, due to security requirements, I am designing a complex integration for D365 SAAS to an on premise WEB API endpoint (like an api store) and wanted to confirm I have the correct setup:


App >> Power Automate (get HTTP, do stuff with payload here)>> MS Data Gateway (cloud) >> Ms Data gateway (on-prem) >>  connector? >> WebAPI (returns json object)


Is a custom connector the only option for this pattern? Is there a generic connector that allows me to specify an address that will allow me to see the endpoint and return data when I build/execute the action in my flow?

Super User
Super User

Hi @devin130 


That's right. To connect API or HTTP endpoint which is On-premises, we need to create a custom connector. But if the data is in SQL then we don't need a custom connector, an SQL connector is capable to connect on-premises and can be used from PowerApps.


On-premises data gateway must be installed on the on-premises server and the account should have permission to connect both.


Stalin - Learn To Illuminate

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,849)