Create a custom connector in Power Platform from scratch

Transcript

1. Create a custom connector in Power Platform from scratch Pune Tech Community Tuesday, 22 Sept 2020
2. About Aroh Technical Consultant, Microsoft MVP, MCT & Nintex vTE Experience: Office 365, SharePoint Online, Data Platform Office 365 Consultant & Power Platform Trainer LinkedIn: https://www.linkedin.com/in/arohshukla/ Blog: aarohblah.blogspot.com @aaroh_bits Aroh Shukla
3. Connectors in Business Application Platform Connector architecture How to build a connector 2 Demos Agenda
4. Microsoft Power Platform Power BI Business analytics Power Apps Application development Power Automate Process automation Power Virtual Agents Intelligent virtual agents The low-code platform that spans Office 365, Azure, Dynamics 365, and standalone applications Innovation anywhere. Unlocks value everywhere. Common Data Service Data connectors AI Builder Portals
5. Power Apps: a low-code approach to building apps
6. What Can Power Automate Do? Automation at scale Seamless, secure integration Accelerated productivity Intelligent automation
7. Power Automate is Designed For Everyone Power Automate is the automation service for everyone in your organization. Experienced Developers Experienced Developers IT/Admins IT/Admins End Users End Users Experienced Developers IT/Admins End Users
8. (including on-prem applications) 275+ app connectors
9. A is a wrapper around an API that allows the underlying service to talk to and
10. Quickly generate and customize apps based on Excel files, SharePoint Online lists, Dynamics 365, Salesforce records and more. You can even connect custom APIs. Even connecting to data in your local systems through the common on premise data gateway. Your apps will be able to fully interact with underlying sources and will respect the permissions you’ve already established in them. Your product here! Connect to cloud AND on-premise data
11. Public connectors available to all users Custom connectors built for your organization
12. Why build a connector? Enterprise developers Looking for connectivity to a service we don’t currently support Need connectivity to a custom or internal service Partners and ISVs
13. Building a Custom Connector Build, secure and describe your API Import from existing artifacts (Open API, Postman) or build from scratch Validate your API calls Use in Power Automate and Power Apps for E2E testing Allow other users within your organization to use your connector
14. Building a Custom Connector Build, secure and describe your API Import from existing artifacts (Open API, Postman) or build from scratch Validate your API calls Use in Flow and PowerApps for E2E testing Allow other users within your organization to use your connector Share your connector with all users of Power Automate and PowerApps
15. Improving your custom connector - Add descriptions and friendly names - Help your users understand the operation - Define more operations - For every POST, there’s typically one or more GETs For Power Automate: - Use Dynamic Values (e.g. Dropdown for users) and Dynamic Schema - Provide a better experience for users in the designer - Add triggers through WebHooks (build a small web application that can accept the HTTP requests) - Using the webhook
18. Custom connector architecture Power Apps Power Automate
19. Using your own Web API Office 365 Power Apps Power Automate 1. Call a flow 2. Call QB Online API 3. Returns results as JSON 4. Returns results as string
20. Securing your Web API PowerApps Microsoft Flow
21. Demos Using Weather API (Power Automate) 1 Google Books API (Power Apps) 2
22. References • Define overview of Connectors: https://docs.microsoft.com/en-us/connectors/custom- connectors/ • Using Postman collection: https://docs.microsoft.com/en-us/connectors/custom- connectors/define-postman-collection • Custom Connectors in Power Platform: https://medium.com/capgemini-microsoft- team/custom-connectors-in-power-platform-9cc73c333799 • Exchange Rate API: https://alphabold.com/creating-a-custom-connector-for-power-apps/ • Weather API: https://weatherstack.com/documentation • Google Books API: https://developers.google.com/books/docs/v1/using • Google Books API video sample https://www.youtube.com/watch?v=cSzI093-xgk