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

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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