{"id":153,"date":"2017-10-26T06:19:49","date_gmt":"2017-10-26T13:19:49","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/"},"modified":"2017-10-26T06:19:49","modified_gmt":"2017-10-26T13:19:49","slug":"on-premise-apis","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/","title":{"rendered":"Connect to custom on-premises APIs using data gateway"},"content":{"rendered":"<p>At Ignite 2017, we announced the ability for Flow and PowerApps users to be able to use the on-premises data gateway to connect to APIs hosted within your internal network. This is a very exciting feature as it will allow you to extend the capabilities of the Flow and PowerApps to suit your very specific needs. In this blog post, I will show you how you can create a simple ASP.NET based REST API, host it on your local machine and connect to it via Flow and PowerApps.<\/p>\n<h2>\n<strong>Part 1. Create your Visual Studio Project and Web API<\/strong><\/h2>\n<ul>\n<li>Start off by create a ASP.NET Web Application, by navigating to <strong>File <\/strong>&gt; <strong>New Project <\/strong>&gt; <strong>Web <\/strong>&gt;<strong> ASP.NET Web Application<\/strong><\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.png\"\/><\/p>\n<ul>\n<li>On the next screen, select Web API and <u><strong>uncheck <\/strong><\/u>the \u201cHost in the cloud\u201d check box.<\/li>\n<li>To keep things simple, click on \u201c<strong>Change Authentication<\/strong>\u201d and select \u201c<strong>No authentication<\/strong>\u201d. You can choose to protect your API \u2013 using Basic or Windows authentication, if you so desire.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_2.png\" style=\"width: 787px; height: 614px;\"\/><\/p>\n<ul>\n<li>After, clicking \u201cOK\u201d, Visual Studio will take a few moments to create your boiler plate Web API and you should see the following screen on successful creation of the application.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_3.png\"\/><\/p>\n<ul>\n<li>Navigate to the Controllers Folder in the Solution Explorer and ensure that you have the values controller to exercise through a web request tool like Fiddler or Postman.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_4.png\"\/><\/p>\n<ul>\n<li>Deploy your solution by clicking on the Play button in the toolbar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_5.png\"\/><\/p>\n<ul>\n<li>The home page of your web API should open in a browser. The web API should now be running locally on IIS, make a note of the URL and Port that points to your web API<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_6.png\"\/><\/p>\n<ul>\n<li>Using the Composer functionality in Fiddler, we can now exercise our API by making a GET call to <a href=\"http:\/\/localhost:1876\/api\/values\/\">http:\/\/localhost:1876\/api\/values\/<\/a>. If the request returns with a 200 OK response, you have successfully created and hosted a RESTful web API on your local machine.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_7.png\"\/><\/p>\n<ul>\n<li>Next, we need to make sure that we can access the Web API using the local machine\u2019s IP address, which means that making a GET call to <a href=\"http:\/\/{YOUR_IP_ADDRESS}:{YOUR_PORT_NUmber}\/api\/values\/\">http:\/\/{YOUR_IP_ADDRESS}:{YOUR_PORT_NUmber}\/api\/values\/<\/a> should return the same results. If you can\u2019t get this to work, make sure IIS is configured correctly to allow calling your API using your machines IP address. <a href=\"http:\/\/johan.driessen.se\/posts\/Accessing-an-IIS-Express-site-from-a-remote-computer\">This blog post<\/a> goes in detail on how you can do just that, in case you are using IIS Express to host your API.<\/li>\n<\/ul>\n<h2><strong>Part 2. Registering your on-premises Web API as a custom connector in Microsoft Flow or PowerApps<\/strong><\/h2>\n<p>\nIf you aren\u2019t familiar with custom connector and required concepts, I highly <a href=\"https:\/\/us.tip1.flow.microsoft.com\/en-us\/documentation\/register-custom-api\/\">recommend reading up<\/a> on it before proceeding further. The section assumes that you\u2019re familiar with custom connector concepts.<\/p>\n<ul>\n<li>Start by navigating to the Microsoft Flow or the PowerApps web portal and click on the Gear menu &gt; Custom Connector. Click + New Custom Connector and select from Create from blank. Next, give a name to your connector.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_8.png\"\/><\/p>\n<ul>\n<li>Fill out the general section, of the custom connector. The most important piece here are the base URL and the host. Make sure you set it up to use your IP and Port. Ensure that you also select the correct scheme, for this instance we should be using HTTP, as we haven&#8217;t configured our API to use HTTPS.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_9.png\"\/><\/p>\n<ul>\n<li>As our API uses no authentication, we don\u2019t need to change anything on the Security Tab.<\/li>\n<li>Under the definition tab, we will go ahead and define the Get Values operation by importing a sample request and response.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_10.png\"\/><\/p>\n<ul>\n<li>Once everything is imported and validated, go ahead and create the connector. The connector will take a few minutes to be operational.<\/li>\n<\/ul>\n<h2><strong>Part 3. Testing the Custom Connector via on-premises data gateway<\/strong><\/h2>\n<p>\u00a0<\/p>\n<ul>\n<li>You will need to install an on-premises data gateway on a machine inside your network. You can download the latest version of the <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=820931&amp;clcid=0x409\">on-premises data gateway from here<\/a>. Once setup correctly, you should see a successful status on your local installation of the gateway.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_11.png\"\/><\/p>\n<ul>\n<li>After installing the gateway, create a connection for testing the connector. Make sure you choose the gateway we just installed to connect through to our on-premises web API.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_12.png\"\/><\/p>\n<ul>\n<li>Finally, test the custom connector by actually making a request though the test custom connector UI. If you see a 200 OK response come back, you have successfully managed to accomplish exactly what we had initially set out do.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_13.png\"\/><\/p>\n<p>If you have any questions, suggestions or feedback about the on-premise custom connector capability, please feel free to post below in the comments, in our <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Community\/ct-p\/PowerApps1\">community<\/a>, or reach out on Twitter.<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to extend workflows and business apps, by connecting to your on-premises RESTful APIs using the custom connector platform and on-premises data gateway.<\/p>\n","protected":false},"author":131,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-apps-category":[1656],"power-apps-tag":[],"coauthors":[2134],"class_list":["post-153","power-apps","type-power-apps","status-publish","hentry","power-apps-category-new-features"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connect to custom on-premises APIs using data gateway - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect to custom on-premises APIs using data gateway - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Learn how to extend workflows and business apps, by connecting to your on-premises RESTful APIs using the custom connector platform and on-premises data gateway.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Sunay Vaishnav\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/\",\"name\":\"Connect to custom on-premises APIs using data gateway - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.png\",\"datePublished\":\"2017-10-26T13:19:49+00:00\",\"dateModified\":\"2017-10-26T13:19:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.webp\",\"width\":949,\"height\":659},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Connect to custom on-premises APIs using data gateway\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect to custom on-premises APIs using data gateway - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/","og_locale":"en_US","og_type":"article","og_title":"Connect to custom on-premises APIs using data gateway - Microsoft Power Platform Blog","og_description":"Learn how to extend workflows and business apps, by connecting to your on-premises RESTful APIs using the custom connector platform and on-premises data gateway.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 min read","Written by":"Sunay Vaishnav"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/","name":"Connect to custom on-premises APIs using data gateway - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.png","datePublished":"2017-10-26T13:19:49+00:00","dateModified":"2017-10-26T13:19:49+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/On-PremCC_1.webp","width":949,"height":659},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/on-premise-apis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"Connect to custom on-premises APIs using data gateway"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/153"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/131"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=153"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/153\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=153"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=153"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=153"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}