title | description | services | ms.suite | ms.reviewer | ms.topic | ms.date | ms.custom |
---|---|---|---|---|---|---|---|
Run code snippets in workflows |
Run code snippets in workflows using Inline Code operations in Azure Logic Apps. |
logic-apps |
integration |
deli, estfan, azla |
how-to |
05/24/2022 |
devx-track-js |
To create and run a code snippet in your logic app workflow without much setup, you can use the Inline Code built-in connector. This connector has an action that returns the result from the code snippet so that you can use that output in your workflow's subsequent actions.
Currently, the connector only has a single action, which works best for a code snippet with the following attributes, but more actions are in development. The Inline Code connector also has different limits, based on whether your logic app workflow is Consumption or Standard.
Action | Language | Language version | Run duration | Data size | Other notes |
---|---|---|---|---|---|
Execute JavaScript Code | JavaScript | Standard: Node.js 12.x.x or 14.x.x Consumption: Node.js 8.11.1 For more information, review Standard built-in objects. |
Finishes in 5 seconds or fewer. | Handles data up to 50 MB. | - Doesn't require working with the Variables actions, which are unsupported by the action. - Doesn't support the require() function for running JavaScript. |
To run code that doesn't fit these attributes, you can create and call a function through Azure Functions instead.
This article shows how the action works in an example workflow that starts with an Office 365 Outlook trigger. The workflow runs when a new email arrives in the associated Outlook email account. The sample code snippet extracts any email addresses that exist the email body and returns those addresses as output that you can use in a subsequent action.
The following diagram shows the highlights from example workflow:
-
An Azure account and subscription. If you don't have a subscription, sign up for a free Azure account.
-
The logic app workflow where you want to add your code snippet. The workflow must already start with a trigger.
This article's example uses the Office 365 Outlook trigger that's named When a new email arrives.
If you don't have a workflow, review the following documentation:
-
Consumption: Quickstart: Create your first logic app
-
-
Based on whether your logic app is Consumption or Standard, review the following requirements:
-
Consumption: Requires Node.js version 8.11.10 and a link to an integration account, empty or otherwise, from your logic app resource.
[!IMPORTANT]
Make sure that you use an integration account that's appropriate for your use case or scenario.
For example, Free-tier integration accounts are meant only for exploratory scenarios and workloads, not production scenarios, are limited in usage and throughput, and aren't supported by a service-level agreement (SLA).
Other integration account tiers incur costs, but include SLA support, offer more throughput, and have higher limits. Learn more about integration account tiers, limits, and pricing.
-
Standard: Requires Node.js versions 12.x.x or 14.x.x, but no integration account.
-
-
In the Azure portal, open your logic app workflow in the designer.
-
On the designer, add the Inline Code action to your workflow. You can add an action either as a new step at the end of your workflow or between steps. This example adds the action under the Office 365 Outlook trigger.
-
To add the action at the end of your workflow, select New step.
-
To add the action between steps, move your mouse pointer over the arrow that connects those steps. Select the plus sign (+) that appears, and select Add an action.
-
-
In the Choose an operation search box, enter inline code. From the actions list, select the action named Execute JavaScript Code.
The action appears in the designer and by default, contains some sample code, including a
return
statement. -
In the Code box, delete the sample code, and enter your code. Write the code that you'd put inside a method, but without the method signature.
[!TIP]
When your cursor is in the Code box, the dynamic content list appears. Although you'll use this list later, you can ignore and leave the list open for now. Don't select Hide.
If you start typing a recognized keyword, the autocomplete list appears so that you can select from available keywords, for example:
The following example code snippet first creates a variable named myResult that stores a regular expression, which specifies a pattern to match in input text. The code then creates a variable named email that stores the email message's body content from the trigger outputs.
-
With your cursor still in the Code box, from the open dynamic content list, find the When a new email arrives section, and select the Body property, which references the email message's body.
The dynamic content list shows the outputs from the trigger and any preceding actions when those outputs match the input format for the edit box that's currently in focus. This list makes these outputs easier to use and reference from your workflow. For this example, the list shows the outputs from the Outlook trigger, including the email message's Body property.
After you select the Body property, the Inline Code action resolves the token to a read-only
workflowContext
JSON object, which your snippet can use as input. TheworkflowContext
object includes properties that give your code access to the outputs from the trigger and preceding actions in your workflow, such as the trigger'sbody
property, which differs from the email message's Body property. For more information about theworkflowContext
object, see Reference trigger and action outputs using the workflowContext object later in this article.[!IMPORTANT]
If your code snippet references action names that include the dot (.) operator, those references have to enclose these action names with square brackets ([]) and quotation marks (""), for example:
// Correct
workflowContext.actions["my.action.name"].body
// Incorrect
workflowContext.actions.my.action.name.body
Also, in the Inline Code action, you have to add the Actions parameter and then add these action names to that parameter. For more information, see Add dependencies as parameters to an Inline Code action later in this article.
-
To differentiate the email message's Body property that you selected from the trigger's
body
property, rename the secondbody
property toBody
instead. Add the closing semicolon (;) at the end to finish the code statement.The Inline Code action doesn't syntactically require a
return
statement. However, by including thereturn
statement, you can more easily reference the action results later in your workflow by using the Result token in later actions.In this example, the code snippet returns the result by calling the
match()
function, which finds any matches in the email message body to the specified regular expression. The Create HTML table action then uses the Result token to reference the results from the Inline Code action and creates a single result. -
When you're done, save your workflow.
-
In the Azure portal, open your logic app workflow in the designer.
-
On the designer, add the Inline Code action to your workflow. You can add an action either as a new step at the end of your workflow or between steps. This example adds the action under the Office 365 Outlook trigger.
-
To add the action at the end of your workflow, select the plus sign (+), and then select Add an action.
-
To add the action between steps, move your mouse pointer over the arrow that connects those steps. Select the plus sign (+) that appears, and select Add an action.
-
-
In the Choose an operation search box, enter inline code. From the actions list, select the action named Execute JavaScript Code.
-
In the code box, enter your code. Write the code that you'd put inside a method, but without the method signature.
[!TIP]
When your cursor is in the code box, the dynamic content list appears. Although you'll use this list later, you can ignore and leave the list open for now. Don't select Hide.
If you start typing a recognized keyword, the autocomplete list appears so that you can select from available keywords, for example:
The following example code snippet first creates a variable named myResult that stores a regular expression, which specifies a pattern to match in input text. The code then creates a variable named email that stores the email message's body content from the trigger outputs.
-
With your cursor still in the code box, from the open dynamic content list, find the When a new email arrives section, and select the Body token, which references the email's message body.
The dynamic content list shows the outputs from the trigger and any preceding actions where those outputs match the input format for the edit box that's currently in focus. This list makes these outputs easier to use and reference from your workflow. For this example, the list shows the outputs from the Outlook trigger, including the email message's Body property.
After you select the Body property, the Inline Code action resolves the token to a read-only
workflowContext
JSON object, which your snippet can use as input. TheworkflowContext
object includes properties that give your code access to the outputs from the trigger and preceding actions in your workflow, such as the trigger'sbody
property, which differs from the email message's Body property. For more information about theworkflowContext
object, see Reference trigger and action outputs using the workflowContext object later in this article.[!IMPORTANT]
If your code snippet references action names that include the dot (.) operator, those references have to enclose these action names with square brackets ([]) and quotation marks (""), for example:
// Correct
workflowContext.actions["my.action.name"].body
// Incorrect
workflowContext.actions.my.action.name.body
Also, in the Inline Code action, you have to add the Actions parameter and then add these action names to that parameter. For more information, see Add dependencies as parameters to an Inline Code action later in this article.
-
To differentiate the email message's Body property that you selected from the trigger's
body
property, rename the secondbody
property toBody
instead. Add the closing semicolon (;) at the end to finish the code statement.The Inline Code action doesn't syntactically require a
return
statement. However, by including thereturn
statement, you can reference the action results later in your workflow by using the Outputs token in later actions.In this example, the code snippet returns the result by calling the
match()
function, which finds any matches in the email message body to the specified regular expression.The Create HTML table action then uses the Outputs token to reference the results from the Inline Code action and creates a single result.
-
When you're done, save your workflow.
From inside your code snippet on the designer, you can use the dynamic content list to select a token that references the output from the trigger or any preceding action. When you select the token, the Inline Code action resolves that token to a read-only workflowContext
JSON object. This object gives your code access to the outputs from the trigger, any preceding actions, and the workflow. The object uses the following structure and includes the actions
, trigger
, and workflow
properties, which are also objects:
{
"workflowContext": {
"actions": {
"<action-name-1>": @actions('<action-name-1>'),
"<action-name-2>": @actions('<action-name-2>')
},
"trigger": {
@trigger()
},
"workflow": {
@workflow()
}
}
}
The following table has more information about these properties:
Property | Type | Description |
---|---|---|
actions |
Object collection | The result objects from any preceding actions that run before your code snippet runs. Each object has a key-value pair where the key is the action name, and the value is equivalent to the result from calling the actions() function with the @actions('<action-name>') expression. The action's name uses the same action name that appears in the underlying workflow definition, which replaces spaces (" ") in the action name with underscores (_). This object collection provides access to the action's property values from the current workflow instance run. |
trigger |
Object | The result object from the trigger where the result is the equivalent to calling the trigger() function. This object provides access to trigger's property values from the current workflow instance run. |
workflow |
Object | The workflow object that is the equivalent to calling the workflow() function. This object provides access to the property values, such as the workflow name, run ID, and so on, from the current workflow instance run. |
In this article's example, the workflowContext
JSON object might have the following sample properties and values from the Outlook trigger:
{
"workflowContext": {
"trigger": {
"name": "When_a_new_email_arrives",
"inputs": {
"host": {
"connection": {
"name": "/subscriptions/<Azure-subscription-ID>/resourceGroups/<Azure-resource-group-name>/providers/Microsoft.Web/connections/office365"
}
},
"method": "get",
"path": "/Mail/OnNewEmail",
"queries": {
"includeAttachments": "False"
}
},
"outputs": {
"headers": {
"Pragma": "no-cache",
"Content-Type": "application/json; charset=utf-8",
"Expires": "-1",
"Content-Length": "962095"
},
"body": {
"Id": "AAMkADY0NGZhNjdhLTRmZTQtNGFhOC1iYjFlLTk0MjZlZjczMWRhNgBGAAAAAABmZwxUQtCGTqSPpjjMQeD",
"DateTimeReceived": "2019-03-28T19:42:16+00:00",
"HasAttachment": false,
"Subject": "Hello World",
"BodyPreview": "Hello World",
"Importance": 1,
"ConversationId": "AAQkADY0NGZhNjdhLTRmZTQtNGFhOC1iYjFlLTk0MjZlZjczMWRhNgAQ",
"IsRead": false,
"IsHtml": true,
"Body": "Hello World",
"From": "<sender>@<domain>.com",
"To": "<recipient-2>@<domain>.com;<recipient-2>@<domain>.com",
"Cc": null,
"Bcc": null,
"Attachments": []
}
},
"startTime": "2019-05-03T14:30:45.971564Z",
"endTime": "2019-05-03T14:30:50.1746874Z",
"scheduledTime": "2019-05-03T14:30:45.8778117Z",
"trackingId": "1cd5ffbd-f989-4df5-a96a-6e9ce31d03c5",
"clientTrackingId": "08586447130394969981639729333CU06",
"originHistoryName": "08586447130394969981639729333CU06",
"code": "OK",
"status": "Succeeded"
},
"workflow": {
"id": "/subscriptions/<Azure-subscription-ID>/resourceGroups/<Azure-resource-group-name>/providers/Microsoft.Logic/workflows/<logic-app-workflow-name>",
"name": "<logic-app-workflow-name>",
"type": "Microsoft.Logic/workflows",
"location": "<Azure-region>",
"run": {
"id": "/subscriptions/<Azure-subscription-ID>/resourceGroups/<Azure-resource-group-name>/providers/Microsoft.Logic/workflows/<logic-app-workflow-name>/runs/08586453954668694173655267965CU00",
"name": "08586453954668694173655267965CU00",
"type": "Microsoft.Logic/workflows/runs"
}
}
}
}
In some scenarios, you might have to explicitly require that the Inline Code action includes outputs from the trigger or actions that your code references as dependencies. For example, you have to take this extra step when your code references outputs that aren't available at workflow run time. During workflow creation time, the Azure Logic Apps engine analyzes the code snippet to determine whether the code references any trigger or action outputs. If those references exist, the engine includes those outputs automatically. At workflow run time, if the referenced trigger or action output isn't found in the workflowContext
object, the engine generates an error. To resolve this error, you have to add that trigger or action as an explicit dependency for the Inline Code action. Another scenario that requires you to take this step is when the workflowContext
object references a trigger or action name that uses the dot operator (.).
To add a trigger or action as a dependency, you add the Trigger or Actions parameters as applicable to the Inline Code action. You then add the trigger or action names as they appear in your workflow's underlying JSON definition.
Note
You can't add Variables operations, loops such as For each or Until, and iteration indexes as explicit dependencies.
If you plan to reuse your code, make sure to always use the code snippet edit box to reference trigger and action outputs. That way, your code includes the resolved token references, rather than just add the trigger or action outputs as explicit dependencies.
For example, suppose the Office 365 Outlook connector's Send approval email action precedes the code snippet in the sample workflow. The following example code snippet includes a reference to the SelectedOption output from this action.
For this example, you have to add only the Actions parameter, and then add the action's JSON name, Send_approval_email
, to the parameter. That way, you specify that the Inline Code action explicitly includes the output from the Send approval email action.
Before you start, you need the JSON name for the trigger or action in the underlying workflow definition.
-
Names in your workflow definition use an underscore (_), not a space.
-
If an action name uses the dot operator (.), include that operator, for example:
My.Action.Name
-
On the workflow designer toolbar, select Code view. In the
actions
object, find the action's name.For example,
Send_approval_email
is the JSON name for the Send approval email action. -
To return to designer view, on the code view toolbar, select Designer.
-
Now add the JSON name to the Inline Code action.
-
On the workflow menu, select Code. In the
actions
object, find the action's name.For example,
Send_approval_email
is the JSON name for the Send approval email action. -
To return to designer view, on the workflow menu, select Designer.
-
Now add the JSON name to the Inline Code action.
-
In the Inline Code action, open the Add new parameter list.
-
From the parameters list, select the following parameters as your scenario requires.
Parameter Description Actions Include outputs from preceding actions as dependencies. When you select this parameter, you're prompted for the actions that you want to add. Trigger Include outputs from the trigger as dependencies. When you select this parameter, you're prompted whether to include trigger results. So, from the Trigger list, select Yes. -
For this example, select the Actions parameter.
-
In the Actions Item - 1 box, enter the action's JSON name.
-
To add another action name, select Add new item.
-
When you're done, save your workflow.
For more information about the Execute JavaScript Code action's structure and syntax in your underlying workflow definition using the Workflow Definition Language, see this action's reference section.
Learn more about Connectors for Azure Logic Apps