Connectors for Azure Logic Apps

Connectors provide quick access from Azure Logic Apps to events, data, and actions across other apps, services, systems, protocols, and platforms. By using connectors in your logic apps, you expand the capabilities for your cloud and on-premises apps to perform tasks with the data that you create and already have.

While Logic Apps offers hundreds of connectors, this article describes popular and more commonly used connectors that are successfully used by thousands of apps and millions of executions for processing data and information. To find the full list of connectors and each connector's reference information, such as triggers, actions, and limits, review the connector reference pages under Connectors overview. Also, learn more about triggers and actions, Logic Apps pricing model, and Logic Apps pricing details.

Note

To integrate with a service or API that doesn't have connector, you can either directly call the service over a protocol such as HTTP or create a custom connector.

Connectors are available either as built-in triggers and actions or as managed connectors:

  • Built-ins: These built-in triggers and actions are "native" to Azure Logic Apps and help you create logic apps that run on custom schedules, communicate with other endpoints, receive and respond to requests, and call Azure functions, Azure API Apps (Web Apps), your own APIs managed and published with Azure API Management, and nested logic apps that can receive requests. You can also use built-in actions that help you organize and control your logic app's workflow, and also work with data.

    Note

    Logic apps within an integration service environment (ISE) can directly access resources in an Azure virtual network. When you use an ISE, built-in triggers and actions that display the Core label run in the same ISE as your logic apps. Logic apps, built-in triggers, and built-in actions that run in your ISE use a pricing plan different from the consumption-based pricing plan.

    For more information about creating ISEs, see Connect to Azure virtual networks from Azure Logic Apps. For more information about pricing, see Logic Apps pricing model.

  • Managed connectors: Deployed and managed by Microsoft, these connectors provide triggers and actions for accessing cloud services, on-premises systems, or both, including Office 365, Azure Blob Storage, SQL Server, Dynamics, Salesforce, SharePoint, and more. Some connectors specifically support business-to-business (B2B) communication scenarios and require an integration account that's linked to your logic app. Before using certain connectors, you might have to first create connections, which are managed by Azure Logic Apps.

    For example, if you're using Microsoft BizTalk Server, your logic apps can connect to and communicate with your BizTalk Server by using the BizTalk Server on-premises connector. You can then extend or perform BizTalk-like operations in your logic apps by using the integration account connectors.

    Connectors are classified as either Standard or Enterprise. Enterprise connectors provide access to enterprise systems such as SAP, IBM MQ, and IBM 3270 for an additional cost. To determine whether a connector is Standard or Enterprise, see the technical details in each connector's reference page under Connectors overview.

    You can also identify connectors by using these categories, although some connectors can cross multiple categories. For example, SAP is an Enterprise connector and an on-premises connector:

    Managed API connectors Create logic apps that use services such as Azure Blob Storage, Office 365, Dynamics, Power BI, OneDrive, Salesforce, SharePoint Online, and many more.
    On-premises connectors After you install and set up the on-premises data gateway, these connectors help your logic apps access on-premises systems such as SQL Server, SharePoint Server, Oracle DB, file shares, and others.
    Integration account connectors Available when you create and pay for an integration account, these connectors transform and validate XML, encode and decode flat files, and process business-to-business (B2B) messages with AS2, EDIFACT, and X12 protocols.

    Note

    Logic apps within an integration service environment (ISE) can directly access resources in an Azure virtual network. When you use an ISE, Standard and Enterprise connectors that display the ISE label run in the same ISE as your logic apps. Connectors that don't display the ISE label run in the global Logic Apps service.

    For on-premises systems that are connected to an Azure virtual network, inject your ISE into that network so your logic apps can directly access those systems by using either a connector that has an ISE label, an HTTP action, or a custom connector. Logic apps and connectors that run in your ISE use a pricing plan different from the consumption-based pricing plan.

    For more information about creating ISEs, see Connect to Azure virtual networks from Azure Logic Apps. For more information about pricing, see Logic Apps pricing model.

    For the full list of connectors and each connector's reference information, such as actions and any triggers, which are defined by an OpenAPI (formerly Swagger) description, plus any limits, you can find the full list under the Connectors overview. For pricing information, see Logic Apps pricing model, and Logic Apps pricing details.

Built-ins

Logic Apps provides built-in triggers and actions so you can create schedule-based workflows, help your logic apps communicate with other apps and services, control the workflow through your logic apps, and manage or manipulate data.

API icon
Schedule
- Run your logic app on a specified schedule, ranging from basic to complex recurrences, with the Recurrence trigger.

- Pause your logic app for a specified duration with the Delay action.

- Pause your logic app until the specified date and time with the Delay until action.

API icon
HTTP
Communicate with any endpoint over HTTP with both triggers and actions for HTTP, HTTP + Swagger, and HTTP + Webhook.
API icon
Request
- Make your logic app callable from other apps or services, trigger on Event Grid resource events, or trigger on responses to Azure Security Center alerts with the Request trigger.

- Send responses to an app or service with the Response action.

API icon
Batch
- Process messages in batches with the Batch messages trigger.

- Call logic apps that have existing batch triggers with the Send messages to batch action.

API icon
Azure Functions
Call Azure functions that run custom code snippets (C# or Node.js) from your logic apps. API icon
Azure API Management
Call triggers and actions defined by your own APIs that you manage and publish with Azure API Management.
API icon
Azure App Services
Call Azure API Apps, or Web Apps, hosted on Azure App Service. The triggers and actions defined by these apps appear like any other first-class triggers and actions when Swagger is included. API icon
Azure
Logic Apps
Call other logic apps that start with a Request trigger.

Control workflow

Logic Apps provides built-in actions for structuring and controlling the actions in your logic app's workflow:

Built-in Icon
Condition
Evaluate a condition and run different actions based on whether the condition is true or false. Built-in Icon
For each
Perform the same actions on every item in an array.
Built-in Icon
Scope
Group actions into scopes, which get their own status after the actions in the scope finish running. Built-in Icon
Switch
Group actions into cases, which are assigned unique values except for the default case. Run only that case whose assigned value matches the result from an expression, object, or token. If no matches exist, run the default case.
Built-in Icon
Terminate
Stop an actively running logic app workflow. Built-in Icon
Until
Repeat actions until the specified condition is true or some state has changed.

Manage or manipulate data

Logic Apps provides built-in actions for working with data outputs and their formats:

Built-in Icon
Data Operations
Perform operations with data:

- Compose: Create a single output from multiple inputs with various types.
- Create CSV table: Create a comma-separated-value (CSV) table from an array with JSON objects.
- Create HTML table: Create an HTML table from an array with JSON objects.
- Filter array: Create an array from items in another array that meet your criteria.
- Join: Create a string from all items in an array and separate those items with the specified delimiter.
- Parse JSON: Create user-friendly tokens from properties and their values in JSON content so you can use those properties in your workflow.
- Select: Create an array with JSON objects by transforming items or values in another array and mapping those items to specified properties.

Built-in Icon
Date Time
Perform operations with timestamps:

- Add to time: Add the specified number of units to a timestamp.
- Convert time zone: Convert a timestamp from the source time zone to the target time zone.
- Current time: Return the current timestamp as a string.
- Get future time: Return the current timestamp plus the specified time units.
- Get past time: Return the current timestamp minus the specified time units.
- Subtract from time: Subtract a number of time units from a timestamp.

Built-in Icon
Variables
Perform operations with variables:

- Append to array variable: Insert a value as the last item in an array stored by a variable.
- Append to string variable: Insert a value as the last character in a string stored by a variable.
- Decrement variable: Decrease a variable by a constant value.
- Increment variable: Increase a variable by a constant value.
- Initialize variable: Create a variable and declare its data type and initial value.
- Set variable: Assign a different value to an existing variable.

Managed API connectors

Logic Apps provides these popular Standard connectors for automating tasks, processes, and workflows with these services or systems.

API icon
Azure Service Bus
Manage asynchronous messages, sessions, and topic subscriptions with the most commonly used connector in Logic Apps. API icon
SQL Server
Connect to your SQL Server on premises or an Azure SQL Database in the cloud so you can manage records, run stored procedures, or perform queries.
API icon
Office 365
Outlook
Connect to your Office 365 email account so you can create and manage emails, tasks, calendar events and meetings, contacts, requests, and more. API icon
Azure Blob
Storage
Connect to your storage account so you can create and manage blob content.
API icon
SFTP
Connect to SFTP servers you can access from the internet so you can work with your files and folders. API icon
SharePoint
Online
Connect to SharePoint Online so you can manage files, attachments, folders, and more.
API icon
Dynamics 365
CRM Online
Connect to your Dynamics 365 account so you can create and manage records, items, and more. API icon
FTP
Connect to FTP servers you can access from the internet so you can work with your files and folders.
API icon
Salesforce
Connect to your Salesforce account so you can create and manage items such as records, jobs, objects, and more. API icon
Twitter
Connect to your Twitter account so you can manage tweets, followers, your timeline, and more. Save your tweets to SQL, Excel, or SharePoint.
API icon
Azure Event Hubs
Consume and publish events through an Event Hub. For example, get output from your logic app with Event Hubs, and then send that output to a real-time analytics provider. API icon
Azure Event
Grid
Monitor events published by an Event Grid, for example, when Azure resources or third-party resources change.

On-premises connectors

Here are some commonly used Standard connectors that Logic Apps provides for accessing data and resources in on-premises systems. Before you can create a connection to an on-premises system, you must first download, install, and set up an on-premises data gateway. This gateway provides a secure communication channel without having to set up the necessary network infrastructure.

API icon
BizTalk
Server
API icon
File
System
API icon
IBM DB2
API icon
IBM
Informix
API icon
MySQL
API icon
Oracle DB
API icon
PostgreSQL
API icon
SharePoint
Server
API icon
SQL
Server
API icon
Teradata

Integration account connectors

Logic Apps provides Standard connectors for building business-to-business (B2B) solutions with your logic apps when you create and pay for an integration account, which is available through the Enterprise Integration Pack (EIP) in Azure. With this account, you can create and store B2B artifacts such as trading partners, agreements, maps, schemas, certificates, and so on. To use these artifacts, associate your logic apps with your integration account. If you currently use BizTalk Server, these connectors might seem familiar already.

API icon
AS2
decoding
API icon
AS2
encoding
API icon
EDIFACT
decoding
API icon
EDIFACT
encoding
API icon
Flat file
decoding
API icon
Flat file
encoding
API icon
Integration
account
API icon
Liquid
transforms
API icon
X12
decoding
API icon
X12
encoding
API icon
XML
transforms
API icon
XML
validation

Enterprise connectors

Logic Apps provides these Enterprise connectors for accessing enterprise systems, such as SAP and IBM MQ:

API icon
IBM 3270
API icon
IBM MQ
API icon
SAP

Triggers and actions - more info

Connectors can provide triggers, actions, or both. A trigger is the first step in any logic app, usually specifying the event that fires the trigger and starts running your logic app. For example, the FTP connector has a trigger that starts your logic app "when a file is added or modified". Some triggers regularly check for the specified event or data and then fire when they detect the specified event or data. Other triggers wait but fire instantly when a specific event happens or when new data is available. Triggers also pass along any required data to your logic app. Your logic app can read and use that data throughout the workflow. For example, the Twitter connector has a trigger, "When a new tweet is posted", that passes the tweet's content into your logic app's workflow.

After a trigger fires, Azure Logic Apps creates an instance of your logic app and starts running the actions in your logic app's workflow. Actions are the steps that follow the trigger and perform tasks in your logic app's workflow. For example, you can create a logic app that gets customer data from a SQL database and process that data in later actions.

Here are the general kinds of triggers that Azure Logic Apps provides:

  • Recurrence trigger: This trigger runs on a specified schedule and isn't tightly associated with a particular service or system.

  • Polling trigger: This trigger regularly polls a specific service or system based on the specified schedule, checking for new data or whether a specific event happened. If new data is available or the specific event happened, the trigger creates and runs a new instance of your logic app, which can now use the data that's passed as input.

  • Push trigger: This trigger waits and listens for new data or for an event to happen. When new data is available or when the event happens, the trigger creates and runs new instance of your logic app, which can now use the data that's passed as input.

Connector configuration

Each connector's triggers and actions provide their own properties for you to configure. Many connectors also require that you first create a connection to the target service or system and provide authentication credentials or other configuration details before you can use a trigger or action in your logic app. For example, you must authorize a connection to a Twitter account for accessing data or to post on your behalf.

For connectors that use OAuth, creating a connection means signing into the service, such as Office 365, Salesforce, or GitHub, where your access token is encrypted and securely stored in an Azure secret store. Other connectors, such as FTP and SQL, require a connection that has configuration details, such as the server address, username, and password. These connection configuration details are also encrypted and securely stored.

Connections can access the target service or system for as long as that service or system allows. For services that use Azure Active Directory (AD) OAuth connections, such as Office 365 and Dynamics, Azure Logic Apps refreshes access tokens indefinitely. Other services might have limits on how long Azure Logic Apps can use a token without refreshing. Generally, some actions invalidate all access tokens, such as changing your password.

Custom APIs and connectors

To call APIs that run custom code or aren't available as connectors, you can extend the Logic Apps platform by creating custom API Apps. You can also create custom connectors for any REST or SOAP-based APIs, which make those APIs available to any logic app in your Azure subscription. To make custom API Apps or connectors public for anyone to use in Azure, you can submit connectors for Microsoft certification.

Note

Logic apps within an integration service environment (ISE) can directly access resources in an Azure virtual network. If you have custom connectors that require the on-premises data gateway, and you created those connectors outside an ISE, logic apps in an ISE can also use those connectors.

Custom connectors created within an ISE don't work with the on-premises data gateway. However, these connectors can directly access on-premises data sources that are connected to an Azure virtual network hosting the ISE. So, logic apps in an ISE most likely don't need the data gateway when communicating with those resources.

For more information about creating ISEs, see Connect to Azure virtual networks from Azure Logic Apps.

Next steps