Contents PowerApps Connectors Reference Draft 2017-04-25 1 | P age Contents Contents Contents ....................................................................................................................................... 2 PowerApps Service Functions Connectors ................................................................................... 6 10to8 Appointment Scheduling.................................................................................................... 7 Act! ............................................................................................................................................. 21 appFigures .................................................................................................................................. 29 Approvals .................................................................................................................................... 40 Asana .......................................................................................................................................... 44 Azure Automation ...................................................................................................................... 77 Azure Data Lake ........................................................................................................................ 102 Azure DocumentDB .................................................................................................................. 115 Azure Queues ........................................................................................................................... 157 Azure Resource Manager ......................................................................................................... 167 Basecamp 2 ............................................................................................................................... 270 Basecamp 3 ............................................................................................................................... 292 Bitbucket ................................................................................................................................... 338 Bitly ........................................................................................................................................... 378 Blogger ...................................................................................................................................... 382 bttn ........................................................................................................................................... 399 Buffer ........................................................................................................................................ 410 Campfire ................................................................................................................................... 426 Capsule CRM ............................................................................................................................. 440 Chatter ...................................................................................................................................... 508 Computer Vision API ................................................................................................................. 534 Disqus ....................................................................................................................................... 563 DocuSign ................................................................................................................................... 583 Easy Redmine............................................................................................................................ 614 Eventbrite ................................................................................................................................. 648 Face API .................................................................................................................................... 681 Facebook ................................................................................................................................... 728 Flic ............................................................................................................................................. 772 FreshBooks ............................................................................................................................... 780 2 | P age Contents Freshdesk .................................................................................................................................. 811 GitHub ....................................................................................................................................... 833 Gmail ......................................................................................................................................... 838 Google Calendar ....................................................................................................................... 852 Google Contacts ....................................................................................................................... 870 Google Tasks ............................................................................................................................. 885 GoToMeeting ............................................................................................................................ 898 GoToTraining ............................................................................................................................ 912 GoToWebinar ........................................................................................................................... 924 Harvest ...................................................................................................................................... 939 HelloSign ................................................................................................................................... 975 HipChat ..................................................................................................................................... 987 Infusionsoft ............................................................................................................................. 1000 Inoreader ................................................................................................................................ 1012 Insightly .................................................................................................................................. 1031 Instagram ................................................................................................................................ 1083 Instapaper ............................................................................................................................... 1132 Intercom ................................................................................................................................. 1161 JIRA ......................................................................................................................................... 1187 LeanKit .................................................................................................................................... 1224 LiveChat .................................................................................................................................. 1249 Logic flows .............................................................................................................................. 1275 LUIS ......................................................................................................................................... 1305 MailChimp .............................................................................................................................. 1319 Mandrill .................................................................................................................................. 1381 Medium .................................................................................................................................. 1408 Microsoft Translator ............................................................................................................... 1419 MSN Weather ......................................................................................................................... 1425 Muhimbi PDF .......................................................................................................................... 1444 Nexmo..................................................................................................................................... 1504 Notifications ........................................................................................................................... 1526 Office 365 Outlook ................................................................................................................. 1531 Office 365 Users ..................................................................................................................... 1638 3 | P age Contents Office 365 Video ..................................................................................................................... 1644 OneNote (Business) ................................................................................................................ 1653 Outlook Customer Manager ................................................................................................... 1671 Outlook Tasks ......................................................................................................................... 1688 Outlook.com ........................................................................................................................... 1711 PagerDuty ............................................................................................................................... 1818 Pinterest ................................................................................................................................. 1867 Pipedrive ................................................................................................................................. 1884 Pivotal Tracker ........................................................................................................................ 1912 Power BI .................................................................................................................................. 1925 PowerApps Notification .......................................................................................................... 1938 Powerflows ............................................................................................................................. 1941 Project Online ......................................................................................................................... 1971 Redmine .................................................................................................................................. 2002 RSS .......................................................................................................................................... 2037 SendGrid ................................................................................................................................. 2042 Service Bus .............................................................................................................................. 2058 Slack ........................................................................................................................................ 2100 Smartsheet ............................................................................................................................. 2106 SMTP ....................................................................................................................................... 2150 SparkPost ................................................................................................................................ 2157 Stripe....................................................................................................................................... 2179 SurveyMonkey ........................................................................................................................ 2204 Text Analytics .......................................................................................................................... 2225 Todoist .................................................................................................................................... 2235 Toodledo ................................................................................................................................. 2265 Trello ....................................................................................................................................... 2274 Twilio ...................................................................................................................................... 2351 Twitter .................................................................................................................................... 2379 Typeform ................................................................................................................................ 2400 Vimeo ...................................................................................................................................... 2406 Visual Studio Team Services ................................................................................................... 2415 WebMerge .............................................................................................................................. 2479 4 | P age Contents WordPress .............................................................................................................................. 2494 Wunderlist .............................................................................................................................. 2520 Yammer .................................................................................................................................. 2564 YouTube .................................................................................................................................. 2588 PowerApps Tabular Data Source Connectors ........................................................................ 2597 Common Data Service ............................................................................................................ 2598 DB2 ......................................................................................................................................... 2599 Dynamics 365 ......................................................................................................................... 2600 Dynamics 365 for Financials ................................................................................................... 2601 Dynamics 365 for Operations ................................................................................................. 2602 Dynamics NAV ........................................................................................................................ 2603 Excel ........................................................................................................................................ 2604 Google Sheets ......................................................................................................................... 2605 Informix .................................................................................................................................. 2606 Oracle Database ..................................................................................................................... 2607 Salesforce ............................................................................................................................... 2608 SharePoint .............................................................................................................................. 2609 SQL Server ............................................................................................................................... 2610 UserVoice ................................................................................................................................ 2611 Zendesk ................................................................................................................................... 2612 PowerApps Blob Connectors .................................................................................................. 2613 Azure Blob Storage ................................................................................................................. 2614 Box .......................................................................................................................................... 2615 Dropbox .................................................................................................................................. 2616 File System .............................................................................................................................. 2617 FTP .......................................................................................................................................... 2618 Google Drive ........................................................................................................................... 2619 OneDrive ................................................................................................................................. 2620 OneDrive for Business ............................................................................................................ 2621 SFTP ........................................................................................................................................ 2622 5 | P age PowerApps Service Functions Connectors PowerApps Service Functions Connectors These connectors provide a set of functions that can be used in PowerApps in the same way that you use any of the built-in formulas included in PowerApps and extend the capabilities of your applications. 6 | P age 10to8 Appointment Scheduling 10to8 Appointment Scheduling 10to8 is a powerful appointment management, communications & online booking system. Status: Preview Tier: Standard Version: 1.0.0 Actions: Name Summary GetOrganisations () Get organisations BookAppointment (string Book new appointment organisation-id, BookAppointmentParameterBody body) Triggers: Name Summary GetAppointments (string organisation-id) When a booking is made GetCustomers (string organisation-id) When a new customer is added GetInboxIncomingMessagesAppeared (string When an incoming message organisation-id) appears in your inbox GetInboxIncomingMessagesDisappeared (string When an incoming message organisation-id) disappears from your inbox GetInboxBookingRequestAppeared (string When a booking request organisation-id) appears in your inbox GetInboxBookingRequestDisappeared (string When a booking request organisation-id) disappears from your inbox GetInboxChangeCancellationRequestAppeared When a change or cancellation (string organisation-id) request appears in your inbox 7 | P age 10to8 Appointment Scheduling GetInboxChangeCancellationRequestDisappeared When a change or cancellation (string organisation-id) request disappears from your inbox Objects: Name Summary BookAppointmentParameterBody EventProposal GetAppointmentsResponseItem GetCustomersResponseItem GetOrganisationsResponseItem IncomingMessage Actions: GetOrganisations Summary: Get organisations Description: Returns a list of all organisations for the authorized account. Syntax: 10to8AppointmentScheduling.GetOrganisations () Returns: Type:array of (GetOrganisationsResponseItem) BookAppointment Summary: Book new appointment Description: Book a new appointment in 10to8. 8 | P age 10to8 Appointment Scheduling Syntax: 10to8AppointmentScheduling.BookAppointment (string organisation- id, BookAppointmentParameterBody body) Parameters: Name Type Summary Require Related Action d organisatio string Pick your True GetOrganisatio n-id (Organisation Id) organisatio ns n. body BookAppointmentParameter Details for True Body a new appointme nt Returns: Type:string Triggers: Trigger GetAppointments Summary: When a booking is made Description: Triggers when a new booking is made in 10to8. Syntax: 10to8AppointmentScheduling.GetAppointments (string organisation- id) Parameters: Name Type Summary Required Related Action 9 | P age 10to8 Appointment Scheduling organisation-id string Pick your True GetOrganisations (Organisation organisation. Id) Returns: Type:array of (GetAppointmentsResponseItem) Trigger GetCustomers Summary: When a new customer is added Description: Triggers when a new customer is added in 10to8. Syntax: 10to8AppointmentScheduling.GetCustomers (string organisation-id) Parameters: Name Type Summary Required Related Action organisation-id string Pick your True GetOrganisations (Organisation organisation. Id) Returns: Type:array of (GetCustomersResponseItem) Trigger GetInboxIncomingMessagesAppeared Summary: When an incoming message appears in your inbox Description: Triggers when an incoming message appears in your inbox. Syntax: 10 | P age
Description: