Connectors are integral part when creating logic apps. Using these connectors, you can really expand your on-premises and cloud applications to do different things with data that you create, and data you already have. The connectors are available in the following categories:
Standard connectors: Automatically available and included when you use logic apps. Some examples include Service Bus, DropBox, GoogleDrive, Power BI, Oracle Database, OneDrive, and many more.
Integration account connectors: These are available when you purchase an integration account. Using these connectors, you can transform and validate XML, process business-to-business messages with AS2 / X12 / EDIFACT, and encode and decode flat files. If you work with BizTalk Server, then these connectors are a good fit to expand your BizTalk workflows into Azure.
BizTalk Server also has a Logic Apps adapter that includes receiving from a logic app, and sending to a logic app.
Enterprise connectors: Includes MQ and SAP. These are also an additional cost.
There are thousands of applications and millions of executions that are successfully processing data and information using these connectors. The following table lists the most popular and some favorites with our users:
|If you want to automate any tasks with your storage account, then you should look at this connector. Supports CRUD (create, read, update, delete) operations.||
|Create functions that run custom snippets of C# or node.js, and then use these functions in your logic apps.|
|This is one of the most-asked for connectors. It has triggers and actions to help automate workflows with leads, and more.||
|Consume and publish events on an Event Hub. For example, you can get output from your logic app using Event Hubs, and then send to a real-time analytics provider.|
|If your FTP server is accessible from the internet, then you can automate workflows to work with files and folders.
SFTP is also available with the SFTP connector.
|Use logic apps to communicate with any endpoint over HTTP.|
|Lots of triggers, and a lot more actions to use Office 365 email and events within your workflows.
This connector includes an approval email action to approve vacation requests, expense reports, and so on.
Office 365 users are also available with the Office 365 Users connector.
Request / Response
|This connector provides an HTTPS URL. When the logic app receives a request to this URL, the logic app starts.|
|Easily sign in with your Salesforce account to get access to objects, such as Leads, and more.||
|The most popular connector within logic apps, it includes triggers and actions to do asynchronous messaging and publish/subscribe with queues, subscriptions, and topics.|
|If you do anything with SharePoint, and could benefit from automation, we recommend looking at this connector. Can be used with an on-premises SharePoint, and SharePoint Online.||
|One of the most used connectors, it can connect to an on-premises SQL Server, and an Azure SQL Database.|
|Sign in easily with a Twitter account, and then start a workflow when a new tweet is posted. Then, save these tweets to a SQL database or SharePoint list.|
Integration account connectors
The Enterprise Integration Pack (EIP) includes connectors that are well known to the BizTalk Server community. When you purchase an integration account, you also get the following connectors:
Connect to your enterprise applications within your logic apps.
|10to8 Appointment Scheduling
Azure Active Directory
Azure API Management
Azure App Services
Azure Blob Storage
Azure Data Lake
Azure Cosmos DB
Azure Logic Apps
Azure Resource Manager
Azure SQL Database
Cognitive Services Computer Vision API
Cognitive Services Face API
Cognitive Services LUIS
Cognitive Services Text Analytics
Common Data Service
Custom APIs / web apps
Dynamics 365 CRM Online
Dynamics 365 for Financials
Dynamics 365 for Operations
HTTP + Swagger
Office 365 Outlook
Office 365 Users
Office 365 Video
OneDrive for Business
Request / Response
SAP Application Server
SAP Message Server
Visual Studio Team Services
To get started with Azure Logic Apps before signing up for an Azure account, go to Try Logic Apps. You can immediately create a short-lived starter logic app. No credit cards required; no commitments.
Connectors as triggers and actions
A trigger starts or runs an instance your logic app. Some connectors provide triggers that notify your app when specific events happen. For example, the FTP connector has the
OnUpdatedFile trigger that starts your logic app when a file is updated.
Logic apps include the following types of triggers:
Poll triggers: These triggers poll your service at a specified frequency to check for new data.
When new data is available, a new instance of your logic app runs with the data as input.
Push triggers: These triggers listen for data on an endpoint, or for an event to happen, then triggers a new instance of your logic app.
Recurrence trigger: This trigger instantiates an instance of your logic app on a prescribed schedule.
Connectors also provide actions that you can use in your workflow. For example, your logic app can look up data, and then use this data later on in your logic app. More specifically, you can look up customer data from a SQL database, and then use this customer data to build your workflow.
Connectors overview provides more details on triggers and actions.
Message manipulation actions
Logic apps include built-in actions that can change or manipulate your payload data. The built-in Data Operations connector includes the following actions:
|Compose||Build or generate values or objects to use later, or as you build your workflow. For example, you can author a JSON object with values from multiple steps, or calculate a constant to reference later in a logic app run.|
|Create CSV table
Create HTML table
|Turn an array result-set into a CSV or HTML table. For example, add the CRM "List records" action, and add a filter for records added today. Then, send the results as an HTML table in an email.|
|Filter array (query)||Filter a result set to the entries that interest you. For example, search all tweets with
|Join||Join an array by some delimeter. For example, the Detect Key Phrases operation returns an array of key phrases. You could "join" them with a
|Parse JSON||Parse out and access values from a JSON object in the designer. For example, if your Azure Function returns a JSON payload, then you can parse it to access the JSON properties later in another step. The action also validates that the JSON matches the specified schema at runtime.|
|Select||Select certain properties of an array for further processing. If you "List records" from SQL, and it returns 15 columns, then select just a few of those columns for further processing (output is an array that only contains the properties you select).|
Custom connectors and Azure certification
To call into APIs that run custom code or aren't available as connectors, you can extend the Logic Apps platform by creating REST-based API Apps as custom connectors.
If you want to make your custom API Apps public and available to use in Azure, then submit your nominations to the Microsoft Azure Certified program.
To ask questions, answer questions, and see what other Azure Logic Apps users are doing, go to the Azure Logic Apps forum.
To help improve Azure Logic Apps and connectors, vote on or submit ideas at the Logic Apps user feedback site.