title | description | services | ms.suite | ms.reviewer | ms.topic | ms.custom | ms.date |
---|---|---|---|---|---|---|---|
Built-in connector overview |
Learn about connectors that run natively with the runtime in Azure Logic Apps. |
logic-apps |
integration |
estfan, azla |
conceptual |
engagement-fy23 |
04/15/2024 |
Built-in connectors provide ways for you to control your workflow's schedule and structure, run your own code, manage or manipulate data, and complete other tasks in your workflows. Different from managed connectors, some built-in connectors aren't tied to a specific service, system, or protocol. For example, you can start almost any workflow on a schedule by using the Recurrence trigger. Or, you can have your workflow wait until called by using the Request trigger. All built-in connectors run natively on the Azure Logic Apps runtime. Some don't require that you create a connection before you use them.
For a smaller number of services, systems, and protocols, Azure Logic Apps provides a built-in version alongside the managed version. The number and range of built-in connectors vary based on whether you create a Consumption logic app workflow that runs in multitenant Azure Logic Apps or a Standard logic app workflow that runs in single-tenant Azure Logic Apps. In most cases, the built-in version provides better performance, capabilities, pricing, and so on. In a few cases, some built-in connectors are available only in one logic app workflow type and not the other.
For example, a Standard workflow can use both managed connectors and built-in connectors for Azure Blob Storage, Azure Cosmos DB, Azure Event Hubs, Azure Service Bus, FTP, IBM DB2, IBM MQ, SFTP, and SQL Server. A Consumption workflow doesn't have the built-in versions. A Consumption workflow can use built-in connectors for Azure API Management, and Azure App Service, while a Standard workflow doesn't have these built-in connectors.
Also, in Standard workflows, some built-in connectors with specific attributes are informally known as service providers. Some built-in connectors support only a single way to authenticate a connection to the underlying service. Other built-in connectors can offer a choice, such as using a connection string, Microsoft Entra ID, or a managed identity. All built-in connectors run in the same process as the Azure Logic Apps runtime. For more information, review Single-tenant versus multitenant in Azure Logic Apps.
This article provides a general overview about built-in connectors in Consumption workflows versus Standard workflows.
The following table lists the current and expanding galleries of built-in connectors available for Consumption versus Standard workflows. For Standard workflows, an asterisk (*) marks built-in connectors based on the service provider model, which is described in more detail later.
Consumption | Standard |
---|---|
Azure API Management Azure App Service Azure Functions Azure Logic Apps Batch Control Data Operations Date Time Flat File HTTP Inline Code Integration Account Liquid Request Schedule Variables XML |
AS2 (v2) Azure AI Search* Azure Automation* Azure Blob Storage* Azure Cosmos DB* Azure Event Grid Publisher* Azure Event Hubs* Azure File Storage* Azure Functions Azure Key Vault* Azure OpenAI* Azure Queue Storage* Azure Service Bus* Azure Table Storage* Batch Operations Control Data Mapper Operations Data Operations Date Time EDIFACT File System* Flat File FTP* HTTP IBM 3270* IBM CICS* IBM DB2* IBM Host File* IBM IMS* IBM MQ* Inline Code Integration Account JDBC* Liquid Operations Request RosettaNet SAP* Schedule SFTP* SMTP* SQL Server* SWIFT Variables Workflow Operations X12 XML Operations |
In Standard workflows, a built-in connector that has the following attributes is informally known as a service provider:
-
Is based on the Azure Functions extensibility model.
-
Provides access from a Standard workflow to a service, such as Azure Blob Storage, Azure Service Bus, Azure Event Hubs, SFTP, and SQL Server.
Some built-in connectors support only a single way to authenticate a connection to the underlying service. Other built-in connectors can offer a choice, such as using a connection string, Microsoft Entra ID, or a managed identity.
-
Runs in the same process as the redesigned Azure Logic Apps runtime.
Service provider-based built-in connectors are available alongside their managed connector versions.
In contrast, a built-in connector that's not a service provider has the following attributes:
-
Isn't based on the Azure Functions extensibility model.
-
Is directly implemented as a job within the Azure Logic Apps runtime, such as Schedule, HTTP, Request, and XML operations.
For Standard workflows, you can create your own built-in connector with the same built-in connector extensibility model that's used by service provider-based built-in connectors, such as Azure Blob Storage, Azure Event Hubs, Azure Service Bus, SQL Server, and more. This interface implementation is based on the Azure Functions extensibility model and provides the capability for you to create custom built-in connectors that anyone can use in Standard workflows.
For Consumption workflows, you can't create your own built-in connectors, but you create your own managed connectors.
For more information, review the following documentation:
You can use the following built-in connectors to perform general tasks, for example:
-
Run workflows using custom and advanced schedules. For more information about scheduling, review the Recurrence behavior for connectors in Azure Logic Apps.
-
Organize and control your workflow's structure, for example, using loops and conditions.
-
Work with variables, dates, data operations, content transformations, and batch operations.
-
Communicate with other endpoints using HTTP triggers and actions.
-
Receive and respond to requests.
-
Call your own functions (Azure Functions) or other Azure Logic Apps workflows that can receive requests, and so on.
:::row:::
:::column:::
Schedule
Recurrence: Trigger a workflow based on the specified recurrence.
Sliding Window
(Consumption workflow only)
Trigger a workflow that needs to handle data in continuous chunks.
Delay: Pause your workflow for the specified duration.
Delay until: Pause your workflow until the specified date and time.
:::column-end:::
:::column:::
HTTP
Call an HTTP or HTTPS endpoint by using either the HTTP trigger or action.
You can also use these other built-in HTTP triggers and actions:
- HTTP + Swagger
- HTTP + Webhook
:::column-end:::
:::column:::
Request
When a HTTP request is received: Wait for a request from another workflow, app, or service. This trigger makes your workflow callable without having to be checked or polled on a schedule.
Response: Respond to a request received by the When a HTTP request is received trigger in the same workflow.
:::column-end:::
:::column:::
Batch
Batch messages: Trigger a workflow that processes messages in batches.
Send messages to batch: Call an existing workflow that currently starts with a Batch messages trigger.
:::column-end:::
:::row-end:::
:::row:::
:::column:::
File System
(Standard workflow only)
Connect to a file system on your network machine to create and manage files.
:::column-end:::
:::column:::
FTP
(Standard workflow only)
Connect to an FTP or FTPS server in your Azure virtual network so that you can work with your files and folders.
:::column-end:::
:::column:::
SFTP
(Standard workflow only)
Connect to an SFTP server in your Azure virtual network so that you can work with your files and folders.
:::column-end:::
:::column:::
SMTP
(Standard workflow only)
Connect to an SMTP server so that you can send email.
:::column-end:::
:::row-end:::
You can use the following built-in connectors to access specific services and systems. In Standard workflows, some of these built-in connectors are also informally known as service providers, which can differ from their managed connector counterparts in some ways.
:::row:::
:::column:::
Azure AI Search
(Standard workflow only)
Connect to AI Search so that you can perform document indexing and search operations in your workflow.
:::column-end:::
:::column:::
Azure API Management
(Consumption workflow only)
Call your own triggers and actions in APIs that you define, manage, and publish using Azure API Management.
Note: Not supported when using Consumption tier for API Management.
:::column-end:::
:::column:::
Azure App Service
(Consumption workflow only)
Call apps that you create and host on Azure App Service, for example, API Apps and Web Apps.
When Swagger is included, the triggers and actions defined by these apps appear like any other first-class triggers and actions in Azure Logic Apps.
:::column-end:::
:::column:::
Azure Automation
(Standard workflow only)
Connect to your Azure Automation accounts so you can create and manage Azure Automation jobs.
:::column-end:::
:::column:::
Azure Blob Storage
(Standard workflow only)
Connect to your Azure Blob Storage account so you can create and manage blob content.
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Azure Cosmos DB
(Standard workflow only)
Connect to Azure Cosmos DB so that you can access and manage Azure Cosmos DB documents.
:::column-end:::
:::column:::
Azure Event Grid Publisher
(Standard workflow only)
Connect to Azure Event Grid for event-based programming using pub-sub semantics.
:::column-end:::
:::column:::
Azure Event Hubs
(Standard workflow only)
Consume and publish events through an event hub. For example, get output from your workflow with Event Hubs, and then send that output to a real-time analytics provider.
:::column-end:::
:::column:::
Azure File Storage
(Standard workflow only)
Connect to your Azure Storage account so that you can create, update, and manage files.
:::column-end:::
:::column:::
Azure Functions
Call Azure-hosted functions to run your own code snippets (C# or Node.js) within your workflow.
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Azure Key Vault
(Standard workflow only)
Connect to Azure Key Vault to store, access, and manage secrets.
:::column-end:::
:::column:::
Azure Logic Apps
(Consumption workflow)
-or-
Workflow Operations
(Standard workflow)
Call other workflows that start with the Request trigger named When a HTTP request is received.
:::column-end:::
:::column:::
Azure OpenAI
(Standard workflow only)
Connect to Azure OpenAI to perform operations on large language models.
:::column-end:::
:::column:::
Azure Service Bus
(Standard workflow only)
Manage asynchronous messages, queues, sessions, topics, and topic subscriptions.
:::column-end:::
:::column:::
Azure Table Storage
(Standard workflow only)
Connect to your Azure Storage account so that you can create, update, query, and manage tables.
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Azure Queue Storage
(Standard workflow only)
Connect to your Azure Storage account so that you can create, update, and manage queues.
:::column-end:::
:::column:::
IBM 3270
(Standard workflow only)
Call 3270 screen-driven apps on IBM mainframes from your workflow.
:::column-end:::
:::column:::
IBM CICS
(Standard workflow only)
Call CICS programs on IBM mainframes from your workflow.
:::column-end:::
:::column:::
IBM DB2
(Standard workflow only)
Connect to IBM DB2 in the cloud or on-premises. Update a row, get a table, and more.
:::column-end:::
:::column:::
IBM Host File
(Standard workflow only)
Connect to IBM Host File and generate or parse contents.
:::column-end:::
:::row-end:::
:::row:::
:::column:::
IBM IMS
(Standard workflow only)
Call IMS programs on IBM mainframes from your workflow.
:::column-end:::
:::column:::
IBM MQ
(Standard workflow only)
Connect to IBM MQ on-premises or in Azure to send and receive messages.
:::column-end:::
:::column:::
JDBC
(Standard workflow only)
Connect to a relational database using JDBC drivers.
:::column-end:::
:::column:::
SAP
(Standard workflow only)
Connect to SAP so you can send or receive messages and invoke actions.
:::column-end:::
:::column:::
SQL Server
(Standard workflow only)
Connect to your SQL Server on premises or an Azure SQL Database in the cloud so that you can manage records, run stored procedures, or perform queries.
:::column-end:::
:::row-end:::
Azure Logic Apps provides the following built-in actions for running your own code in your workflow:
:::row:::
:::column:::
Azure Functions
Call Azure-hosted functions to run your own code snippets (C# or Node.js) within your workflow.
:::column-end:::
:::column:::
Inline Code
Add and run inline JavaScript code snippets from your workflow.
:::column-end:::
:::column:::
Local Function Operations
(Standard workflow only)
Create and run .NET Framework code from your workflow.
:::column-end:::
:::column:::
:::column-end:::
:::row-end:::
Azure Logic Apps provides the following built-in actions for structuring and controlling the actions in your workflow:
:::row:::
:::column:::
Condition
Evaluate a condition and run different actions based on whether the condition is true or false.
:::column-end:::
:::column:::
For Each
Perform the same actions on every item in an array.
:::column-end:::
:::column:::
Scope
Group actions into scopes, which get their own status after the actions in the scope finish running.
:::column-end:::
:::column:::
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.
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Terminate
Stop an actively running workflow.
:::column-end:::
:::column:::
Until
Repeat actions until the specified condition is true or some state has changed.
:::column-end:::
:::column:::
:::column-end:::
:::column:::
:::column-end:::
:::row-end:::
Azure Logic Apps provides the following built-in actions for working with data outputs and their formats:
:::row:::
:::column:::
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 that 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.
:::column-end:::
:::column:::
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.
:::column-end:::
:::column:::
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.
:::column-end:::
:::column:::
:::column-end:::
:::row-end:::
Azure Logic Apps supports business-to-business (B2B) communication scenarios through various B2B built-in operations. Based on whether you have a Consumption or Standard workflow and the B2B operations that you want to use, you might have to create and link an integration account to your logic app resource. You then use this integration account to define your B2B artifacts, such as trading partners, agreements, maps, schemas, certificates, and so on.
-
Consumption workflows
Before you can use any B2B operations in a workflow, you must create and link an integration account to your logic app resource. After you create your integration account, you must then define your B2B artifacts, such as trading partners, agreements, maps, schemas, certificates, and so on. You can then use the B2B operations to encode and decode messages, transform content, and more.
-
Standard workflows
Some B2B operations require that you create and link an integration account to your logic app resource. Linking lets you share artifacts across multiple Standard workflows and their child workflows. Based on the B2B operation that you want to use, complete one of the following steps before you use the operation:
-
For operations that require maps or schemas, you can either:
-
Upload these artifacts to your logic app resource using the Azure portal or Visual Studio Code. You can then use these artifacts across all child workflows in the same logic app resource. For more information, review Add maps to use with workflows in Azure Logic Apps and Add schemas to use with workflows in Azure Logic Apps.
-
-
For operations that require a connection to your integration account, create the connection when you add the operation to your workflow.
-
For more information, review the following documentation:
- Business-to-business (B2B) enterprise integration workflows
- Create and manage integration accounts for B2B workflows
:::row:::
:::column:::
AS2 (v2)
(Standard workflow only)
Encode and decode messages that use the AS2 protocol.
:::column-end:::
:::column:::
EDIFACT
Encode and decode messages that use the EDIFACT protocol.
:::column-end:::
:::column:::
Flat File
Encode and decode XML messages between trading partners.
:::column-end:::
:::column:::
Integration Account Artifact Lookup
Get custom metadata for artifacts, such as trading partners, agreements, schemas, and so on, in your integration account.
:::column-end:::
:::column:::
Liquid Operations
Convert the following formats by using Liquid templates:
- JSON to JSON
- JSON to TEXT
- XML to JSON
- XML to TEXT
:::column-end:::
:::row-end:::
:::row:::
:::column:::
RosettaNet
Encode and decode messages that use the RosettaNet protocol.
:::column-end:::
:::column:::
SWIFT
(Standard workflow only)
Encode and decode Society for Worldwide Interbank Financial Telecommuncation (SIWFT) transactions in flat-file XML message format.
:::column-end:::
:::column:::
Transform XML
Convert the source XML format to another XML format.
:::column-end:::
:::column:::
X12
Encode and decode messages that use the X12 protocol.
:::column-end:::
:::column:::
XML Validation
Validate XML documents against the specified schema.
:::column-end:::
:::row-end:::
[!div class="nextstepaction"] Create custom APIs that you can call from Azure Logic Apps