January 30, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 30, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

by | Jan 29, 2023 | BizTalk Community Blogs via Syndication

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“f3080”:{“name”:”Main Accent”,”parent”:-1},”f2bba”:{“name”:”Main Light 10″,”parent”:”f3080″},”trewq”:{“name”:”Main Light 30″,”parent”:”f3080″},”poiuy”:{“name”:”Main Light 80″,”parent”:”f3080″},”f83d7″:{“name”:”Main Light 80″,”parent”:”f3080″},”frty6″:{“name”:”Main Light 45″,”parent”:”f3080″},”flktr”:{“name”:”Main Light 80″,”parent”:”f3080″}},”gradients”:[]},”palettes”:[{“name”:”Default”,”value”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]},”original”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]}}]}__CONFIG_colors_palette__

BizTalk Server Migration to Azure Integration Services Architecture Guidance

BizTalk Server Migration to Azure Integration Services Architecture Guidance

by | Jan 26, 2023 | BizTalk Community Blogs via Syndication

I was honored to be invited by the Microsoft Logic App product group to contribute to the BizTalk Server Migration to Azure Integration Services Architecture Guidance documentation alongside my fellow MVPs: Michael Stephenson and Stephen W Thomas. 

This guideline is focused on clients considering or having already decided to move their entire BizTalk Server on-premises integration solution to Azure or parts of the solution into Azure, therefore, making some hybrid solutions. Of course, in this process, many questions about best practices to use, what services to use, and others will be raised.

This guide provides an overview of the reasons and benefits, product comparisons, capabilities, and other information to help you start migrating from on-premises BizTalk Server solutions to cloud-based Azure Integration Services. Following this guide, you’ll find more guides that cover how to choose the services that best fit your scenario, along with migration strategies, planning considerations, and best practices to help you deliver successful results:

This is a simple feature matchup diagram that you will find in the guide:

If you want to know more about it, the architecture guide is available here: BizTalk Server Migration to Azure Integration Services Architecture Guidance.

See the original Microsoft announcement here: Announcement: BizTalk Server Migration to Azure Integration Services Architecture Guidance.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira

Azure Logic App issues: The template language expression ‘triggerBody()?[‘…’]’ cannot be evaluated.

Azure Logic App issues: The template language expression ‘triggerBody()?[‘…’]’ cannot be evaluated.

by | Jan 24, 2023 | BizTalk Community Blogs via Syndication

Today while my team and I were trying to do a small Logic App proof-of-concept using a Request – When a HTTP request is received trigger – something quite simple and basic – with a simple JSON payload like:

{
	"Data":[
		{
			"LogicAppName":"",
			"ResourceGroupName":"",
			"SubscriptionID":""
		}
	]
}

We were always getting the following error when we were trying to trigger the Logic App using Postman:

InvalidTemplate. Unable to process template language expressions for action ‘For_each’ at line ‘0’ and column ‘0’: ‘The template language expression ‘triggerBody()?[‘Data’]’ cannot be evaluated because property ‘Data’ cannot be selected. Property selection is not supported on values of type ‘String’. Please see https://aka.ms/logicexpressions for usage details.’.

To be honest, I was getting annoyed because this a simple stuff that I have done thousands of times!

Cause

Unfortunately, I cannot use the common excuse: “sorry, it is Friday!” because today is Tuesday :). But I can always say that most of the time the error resides between the chair and the keyboard! ?

You may pay more attention to the Logic App designer when you define a JSON Schema in your When a HTTP request is received trigger. It will warn you not to forget to include a Content-Type header set to application/json in your request!

If you do not provide the Content-Type header, it will assume that is plain text, and it will not parse the JSON and render all the properties, so it will not going to be tokenized, and there you will get this or similar errors.

Solution

The solution is quite simple, on the Postman request add a Content-Type header and set it to application/json.

If you try again… problem is solved!

Hope you find this useful!

My youngest son (almost 5 years old) is a big Star Wars fan, and when I’m trying to write something, and he arrives home and want to play with me, I always say to him: Let the father finish work to earn some money so we can buy more toys… now I promise him that all contributions from my blog are going to be used for buying Star Wars Legos!

So, if you liked the content or found it useful and want to help me write more content, you can buy (or help buy) my son a Star Wars Lego! ?

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira

January 23, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 23, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

by | Jan 22, 2023 | BizTalk Community Blogs via Syndication

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“f3080”:{“name”:”Main Accent”,”parent”:-1},”f2bba”:{“name”:”Main Light 10″,”parent”:”f3080″},”trewq”:{“name”:”Main Light 30″,”parent”:”f3080″},”poiuy”:{“name”:”Main Light 80″,”parent”:”f3080″},”f83d7″:{“name”:”Main Light 80″,”parent”:”f3080″},”frty6″:{“name”:”Main Light 45″,”parent”:”f3080″},”flktr”:{“name”:”Main Light 80″,”parent”:”f3080″}},”gradients”:[]},”palettes”:[{“name”:”Default”,”value”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]},”original”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]}}]}__CONFIG_colors_palette__

CSV Structure Validation Pipeline Component

CSV Structure Validation Pipeline Component

by | Jan 22, 2023 | BizTalk Community Blogs via Syndication

I’m back to another blog post about BizTalk Server! I know that my latest post has been about Azure Logic Apps, and you may count on seeing many more in the future. And the reason is that I work both on-premise with BizTalk Server and in the cloud with Azure Integration Services… but relax, I will continue to post many things about BizTalk Server. BizTalk Server is not dead. It is well alive, contrary to what many think!

Today I’m returning to one of my pet projects: the BizTalk Pipeline Components Extensions Utility Pack project that is available on GitHub!

For those who aren’t familiar with it, the BizTalk Pipeline Components Extensions Utility Pack project is a set of custom pipeline components (libraries) with several custom pipeline components that can be used in receive and sent pipelines. Those pipeline components provide extensions of BizTalk’s out-of-the-box pipeline capabilities.

CSV Structure Validation Pipeline Component

The CSV Structure Validation Pipeline Component is a pipeline component that can be used to validate the structure of a basic CSV or flat file component before being converted to an XML message. Of course, this same strategy can be used in more complex scenarios.

This is the list of properties that you can set up on the CSV Structure Validation pipeline component:

Property Name Description Sample Values
DelimiterChar Define what is the delimiter char inside a line. ;
NumberFieldsPerLine Number of fields expected per line 3

Note that this component takes as granted that the line delimiter is the CRLF (Carriage ReturnLine Feed).

If we take this example:

one;two;t
1;2;2

Then we need to configure the port in the following way:

If we receive an invalid file, then the component will raise an error suspending the message in the BizTalk Server Administration Console. For example, with the following error message:

  • Invalid format data in the document. Line number 3 has 2 fields, and it should be expected 3 fields

If you are wondering why create a Pipeline component to validate the structure of the CSV or flat-file document? Can we use instead the Flat-File Schema to do this structure validation?

And the answer is Yes and No! In many cases and with many requirements, we don’t need to create a custom pipeline component. Using a Flat-File schema can be used to address the goals but in other scenarios doing a CSV Validation with the Flat-File schema is not enough. However, I will leave that “discussion” to my next BizTalk Server Best practices, tips and tricks.

How to install it

As always, you just need to add these DLLs on the Pipeline Components folder that in BizTalk Server 2020 is by default:

  • C:Program Files (x86)Microsoft BizTalk ServerPipeline Components

In this particular component, we need to have this  DLL:

  • BizTalk.PipelineComponent.CSVFlatFileStructureValidation.dll

How to use it

Like all previous, to use the pipeline component, I recommend you to create generic or several generic pipelines that can be reused by all your applications and add the Message Archive Pipeline Component in the stage you desire. The component can be used in a stage of the receive and send pipelines.

Download

THIS COMPONENT IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

You can download CSV Structure Validation Pipeline Component from GitHub here:

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira

Logic Apps Development Tips and Tricks episode at Kent Weare Youtube Channel

Logic Apps Development Tips and Tricks episode at Kent Weare Youtube Channel

by | Jan 18, 2023 | BizTalk Community Blogs via Syndication

I had the pleasure of being invited a few weeks ago by my friend – and now Microsoft Principal Product Manager – Azure Logic Apps – Kent Weare to record a special episode on Logic Apps Development Tips and Tricks on his YouTube channel.

First of all, if you are unaware of his YouTube channel and you like or are interested in Azure Integration Services, I suggest you follow his channel, which is full of fantastic content. You can check and follow his channel here: https://www.youtube.com/@KentWeare

In this episode, we are going to discuss some of the most basic and important Logic Apps development best practices, tips, and tricks:

  • Naming Conventions, which will include Logic App, Action, and Connectors naming conventions
  • Error Handling and how to retrieve the error message inside Logic Apps
  • For Each Parallelism
  • Fixing API Connections and why you should care about this.
  • and comparing Logic Apps (Standard) and Azure Logic Apps (Consumption)

You can see the full episode here: https://www.youtube.com/watch?v=cLzplA1xVaM&t=479s

Let me know what you think about these Best practices, tips, and tricks or what you would like to be addressed in my series of blogs about this topic.

You can check all my tips and tricks here:

And of course, stay tuned for more Logic App Best practices, Tips, and Tricks.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira

January 16, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 16, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

by | Jan 15, 2023 | BizTalk Community Blogs via Syndication

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“f3080”:{“name”:”Main Accent”,”parent”:-1},”f2bba”:{“name”:”Main Light 10″,”parent”:”f3080″},”trewq”:{“name”:”Main Light 30″,”parent”:”f3080″},”poiuy”:{“name”:”Main Light 80″,”parent”:”f3080″},”f83d7″:{“name”:”Main Light 80″,”parent”:”f3080″},”frty6″:{“name”:”Main Light 45″,”parent”:”f3080″},”flktr”:{“name”:”Main Light 80″,”parent”:”f3080″}},”gradients”:[]},”palettes”:[{“name”:”Default”,”value”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]},”original”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]}}]}__CONFIG_colors_palette__

Azure Logic Apps Standard REST APIs (Part III)

Azure Logic Apps Standard REST APIs (Part III)

by | Jan 13, 2023 | BizTalk Community Blogs via Syndication

In my last two blog posts, I documented the Workflow Run Actions, and Workflow Runs REST APIs for Logic App Standard, you can read more about it here:

REST Operation Groups

Like Logic Apps Consumption, Logic App Standard REST APIs are organized in these REST Operation Groups:

  • Workflow Run Actions: Lists workflow run actions.
  • Workflow Runs: Provides operations for listing and canceling workflow runs.
  • Workflow Trigger Histories: Lists workflow trigger histories.
  • Workflow Triggers: Provides operations for listing and running workflow triggers.
  • Workflow Versions: Lists workflow versions.
  • Workflows: Provides operations for creating and managing workflows.

Today we are going to address the Workflow Trigger Histories REST APIs for Logic App Standard.

Workflow Trigger Histories

These are the available operations:

  • Get: Gets a workflow trigger history.
  • List: Gets a list of workflow trigger histories.
  • Resubmit: Resubmits a workflow run based on the trigger history.

This list may change since this is not the official list, and many things under the hood are different from Consumption to Standard.

Get

Request URL:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/icrosoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/triggers/{triggerName}/histories/{historyName}?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
triggerName path True string The workflow trigger name.
historyName path True string The workflow trigger history name. Corresponds to the run name for triggers that resulted in a run.
api-version query True string The API version.

Response:

Sample Request:

https://management.azure.com/subscriptions/XXXXXXXX/resourceGroups/RG-SPMSDN-LASTD-POC/providers/Microsoft.Web/sites/LASTD-SPMSDN-EAI-POC/hostruntime/runtime/webhooks/workflow/api/management/workflows/DemoHTTP/triggers/manual/histories/08585286433641737811956886654CU00?api-version=2018-11-01

Sample Response:

Status Code: 200

{
    "properties": {
        "startTime": "2023-01-06T00:05:21.3134356Z",
        "endTime": "2023-01-06T00:05:22.6998422Z",
        "status": "Succeeded",
        "correlation": {
            "clientTrackingId": "08585286433641737811956886654CU00"
        },
        "inputsLink": {
            "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/77611e515f054951b892c7da37d37e8c/triggers/manual/histories/08585286433641737811956886654CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxxxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286433641737811956886654CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=xxxxxxxx",
            "contentSize": 16
        },
        "outputsLink": {
            "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/77611e515f054951b892c7da37d37e8c/triggers/manual/histories/08585286433641737811956886654CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286433641737811956886654CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=xxxxxxx",
            "contentSize": 1126
        },
        "fired": true,
        "run": {
            "id": "/workflows/DemoHTTP/runs/08585286433641737811956886654CU00"
        },
        "workflow": {
            "id": "/workflows/DemoHTTP/versions/08585286433748374192",
            "name": "08585286433748374192",
            "type": "workflows/versions"
        }
    },
    "id": "/workflows/DemoHTTP/triggers/manual/histories/08585286433641737811956886654CU00",
    "name": "08585286433641737811956886654CU00",
    "type": "workflows/triggers/histories"
}

List

Request URL:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/triggers/{triggerName}/histories?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
triggerName path True string The workflow trigger name.
api-version query True string The API version.
$filter query False string The filter to apply on the operation. Options for filters include: Status, StartTime, and ClientTrackingId.
$top query False integer
int32		 The number of items to be included in the result.

Response:

Sample Request:

https://management.azure.com/subscriptions/xxxxxxx/resourceGroups/RG-SPMSDN-LASTD-POC/providers/Microsoft.Web/sites/LASTD-SPMSDN-EAI-POC/hostruntime/runtime/webhooks/workflow/api/management/workflows/DemoHTTP/triggers/manual/histories?api-version=2018-11-01

Sample Response:

Status Code: 200

{
    "value": [
        {
            "properties": {
                "startTime": "2023-01-06T00:05:21.3134356Z",
                "endTime": "2023-01-06T00:05:22.6998422Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585286433641737811956886654CU00"
                },
                "inputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxx/triggers/manual/histories/08585286433641737811956886654CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286433641737811956886654CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=xxxx",
                    "contentSize": 16
                },
                "outputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/triggers/manual/histories/08585286433641737811956886654CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286433641737811956886654CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=xxxxx",
                    "contentSize": 1126
                },
                "fired": true,
                "run": {
                    "id": "/workflows/DemoHTTP/runs/08585286433641737811956886654CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585286433748374192",
                    "name": "08585286433748374192",
                    "type": "workflows/versions"
                }
            },
            "id": "/workflows/DemoHTTP/triggers/manual/histories/08585286433641737811956886654CU00",
            "name": "08585286433641737811956886654CU00",
            "type": "workflows/triggers/histories"
        },
        {
            "properties": {
                "startTime": "2023-01-05T23:38:54.0737607Z",
                "endTime": "2023-01-05T23:38:54.6800302Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585286449514038376808472053CU00"
                },
                "inputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/triggers/manual/histories/08585286449514038376808472053CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286449514038376808472053CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=xxxxxx-h_rKlNU",
                    "contentSize": 16
                },
                "outputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/triggers/manual/histories/08585286449514038376808472053CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxx3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286449514038376808472053CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=xxxx",
                    "contentSize": 1131
                },
                "fired": true,
                "run": {
                    "id": "/workflows/DemoHTTP/runs/08585286449514038376808472053CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585286449696806038",
                    "name": "08585286449696806038",
                    "type": "workflows/versions"
                }
            },
            "id": "/workflows/DemoHTTP/triggers/manual/histories/08585286449514038376808472053CU00",
            "name": "08585286449514038376808472053CU00",
            "type": "workflows/triggers/histories"
        },
        {
            "properties": {
                "startTime": "2023-01-05T23:38:51.7266881Z",
                "endTime": "2023-01-05T23:38:52.3565097Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585286449537509247006194196CU00"
                },
                "inputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/triggers/manual/histories/08585286449537509247006194196CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286449537509247006194196CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=xxxx",
                    "contentSize": 16
                },
                "outputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxx/triggers/manual/histories/08585286449537509247006194196CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286449537509247006194196CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=xxxx",
                    "contentSize": 1131
                },
                "fired": true,
                "run": {
                    "id": "/workflows/DemoHTTP/runs/08585286449537509247006194196CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585286449696806038",
                    "name": "08585286449696806038",
                    "type": "workflows/versions"
                }
            },
            "id": "/workflows/DemoHTTP/triggers/manual/histories/08585286449537509247006194196CU00",
            "name": "08585286449537509247006194196CU00",
            "type": "workflows/triggers/histories"
        },
        {
            "properties": {
                "startTime": "2023-01-05T23:38:46.3971339Z",
                "endTime": "2023-01-05T23:38:48.5693481Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585286449590895092364058803CU00"
                },
                "inputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/triggers/manual/histories/08585286449590895092364058803CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286449590895092364058803CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=xxxx",
                    "contentSize": 16
                },
                "outputsLink": {
                    "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/triggers/manual/histories/08585286449590895092364058803CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxx%3d%3d&se=2023-01-06T20%3A00%3A00.0000000Z&sp=%2Ftriggers%2Fmanual%2Fhistories%2F08585286449590895092364058803CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=xxxx",
                    "contentSize": 1131
                },
                "fired": true,
                "run": {
                    "id": "/workflows/DemoHTTP/runs/08585286449590895092364058803CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585286449696806038",
                    "name": "08585286449696806038",
                    "type": "workflows/versions"
                }
            },
            "id": "/workflows/DemoHTTP/triggers/manual/histories/08585286449590895092364058803CU00",
            "name": "08585286449590895092364058803CU00",
            "type": "workflows/triggers/histories"
        }
    ]
}

Resubmit

Request URL:

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/icrosoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/triggers/{triggerName}/histories/{historyName}/resubmit?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
triggerName path True string The workflow trigger name.
historyName path True string The workflow trigger history name. Corresponds to the run name for triggers that resulted in a run.
api-version query True string The API version.

Response:

Name Type Description
202 Accepted OK

Sample Request:

https://management.azure.com/subscriptions/xxxxx/resourceGroups/RG-SPMSDN-LASTD-POC/providers/Microsoft.Web/sites/LASTD-SPMSDN-EAI-POC/hostruntime/runtime/webhooks/workflow/api/management/workflows/DemoHTTP/triggers/manual/histories/08585286433641737811956886654CU00/resubmit?api-version=2018-11-01

Sample Response:

Status Code: 202

We may also get some errors if you try to resume an invalid instance.

Stay tuned for the next Operation Group: Workflow Triggers.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira

Azure Logic Apps Standard REST APIs (Part II)

Azure Logic Apps Standard REST APIs (Part II)

by | Jan 11, 2023 | BizTalk Community Blogs via Syndication

In my last blog post, I documented the Workflow Run Actions REST APIs for Logic App Standard, you can read more about it here: Azure Logic Apps Standard REST APIs (Part I).

REST Operation Groups

Like Logic Apps Consumption, Logic App Standard REST APIs are organized in these REST Operation Groups:

  • Workflow Run Actions: Lists workflow run actions.
  • Workflow Runs: Provides operations for listing and canceling workflow runs.
  • Workflow Trigger Histories: Lists workflow trigger histories.
  • Workflow Triggers: Provides operations for listing and running workflow triggers.
  • Workflow Versions: Lists workflow versions.
  • Workflows: Provides operations for creating and managing workflows.

Today we are going to address the Workflow Runs REST APIs for Logic App Standard.

Workflow Runs

These are the available operations:

  • Cancel: Cancels a workflow run.
  • Delete: Deletes a workflow run.
  • Get: Gets a workflow run.
  • List: Gets a list of workflow runs.

This list may change since this is not the official list, and many things under the hood are different from Consumption to Standard.

Cancel

Request URL:

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/runs/{runId}/cancel?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
runId path True string The workflow run id (name).
api-version query True string The API version.

Response:

Name Type Description
200 OK OK

Sample Request:

https://management.azure.com/subscriptions/xxxxxxxxx/resourceGroups/RG-SPMSDN-LASTD-POC/providers/Microsoft.Web/sites/LASTD-SPMSDN-EAI-POC/hostruntime/runtime/webhooks/workflow/api/management/workflows/DemoHTTP/runs/08585286433641737811956886654CU00/cancel?api-version=2018-11-01

Sample Response:

Status Code: 200

We may also get some errors if you try to cancel an already completed instance.

{
    "error": {
        "code": "WorkflowRunCanNotBeCancelled",
        "message": "The workflow 'DemoHTTP' run '08585286433641737811956886654CU00' with state 'Succeeded' could not be canceled, because it is not active."
    }
}

Delete

Request URL:

DELETE https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/runs/{runId}?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
runId path True string The workflow run id (name).
api-version query True string The API version.

Response:

Name Type Description
200 OK OK
204 No Content No Content

Note: I wasn’t able to successfully test this API. But I assume it will exist.

Get

Request URL:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/runs/{runId}?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
runId path True string The workflow run id (name).
api-version query True string The API version.

Response:

Sample Request:

https://management.azure.com/subscriptions/xxxxxxxxxx/resourceGroups/RG-SPMSDN-LASTD-POC/providers/Microsoft.Web/sites/LASTD-SPMSDN-EAI-POC/hostruntime/runtime/webhooks/workflow/api/management/workflows/DemoHTTP/runs/08585286433641737811956886654CU00?api-version=2018-11-01

Sample Response:

Status Code: 200

We may also get some errors if you try to cancel an already completed instance.

{
    "properties": {
        "waitEndTime": "2023-01-06T00:05:21.4086338Z",
        "startTime": "2023-01-06T00:05:21.4086338Z",
        "endTime": "2023-01-06T00:05:23.8140158Z",
        "status": "Succeeded",
        "correlation": {
            "clientTrackingId": "08585286433641737811956886654CU00"
        },
        "workflow": {
            "id": "/workflows/DemoHTTP/versions/08585286433748374192",
            "name": "08585286433748374192",
            "type": "workflows/versions"
        },
        "trigger": {
            "name": "manual",
            "inputsLink": {
                "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxx/runs/08585286433641737811956886654CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxx%3d%3d&se=2023-01-06T18%3A00%3A00.0000000Z&sp=%2Fruns%2F08585286433641737811956886654CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=7I7ZCpuXQwhlKNl6RrVLe5yAFPF-VR3CVBzK-IfRNwI",
                "contentSize": 16
            },
            "outputsLink": {
                "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxx/runs/08585286433641737811956886654CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxx3d%3d&se=2023-01-06T18%3A00%3A00.0000000Z&sp=%2Fruns%2F08585286433641737811956886654CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=N-E5R7dsxwuoWFKav_EZFBC8_E-Xlf7eDkieJIsMyJk",
                "contentSize": 1126
            },
            "startTime": "2023-01-06T00:05:21.3134356Z",
            "endTime": "2023-01-06T00:05:21.3134356Z",
            "originHistoryName": "08585286433641737811956886654CU00",
            "correlation": {
                "clientTrackingId": "08585286433641737811956886654CU00"
            },
            "status": "Succeeded"
        },
        "outputs": {},
        "response": {
            "name": "Response",
            "outputsLink": {
                "uri": "https://lastd-spmsdn-eai-poc.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxx/runs/08585286433641737811956886654CU00/contents/ResponseOutputs?api-version=2018-11-01&code=QoTB_2yAu1mf6NMwZVEFwWd5xH4EgQBpXSFK3Q7zi7qQAzFuy-PBZw%3d%3d&se=2023-01-06T18%3A00%3A00.0000000Z&sp=%2Fruns%2F08585286433641737811956886654CU00%2Fcontents%2FResponseOutputs%2Fread&sv=1.0&sig=YFHL0CPNgytFe2OMHaymNcCaYCxpX3xH6BwrZNt-tHI",
                "contentSize": 46
            },
            "startTime": "2023-01-06T00:05:21.4639188Z",
            "endTime": "2023-01-06T00:05:23.7365848Z",
            "correlation": {
                "clientTrackingId": "08585286433641737811956886654CU00"
            },
            "code": "OK",
            "status": "Succeeded"
        }
    },
    "id": "/workflows/DemoHTTP/runs/08585286433641737811956886654CU00",
    "name": "08585286433641737811956886654CU00",
    "type": "workflows/runs"
}

List

Request URL:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/{logicAppStdName}/hostruntime/runtime/webhooks/workflow/api/management/workflows/{workflowName}/runs?api-version=2018-11-01

URI Parameters:

Name In Required Type Description
subscriptionId path True string The subscription id.
resourceGroupName path True string The resource group name.
logicAppStdName path True string The Logic App Standard name.
workflowName path True string The workflow name.
api-version query True string The API version.
$filter query False string The filter to apply on the operation. Options for filters include: Status, StartTime, and ClientTrackingId.
$top query False integer
int32		 The number of items to be included in the result.

Response:

Sample Request:

https://management.azure.com/subscriptions/xxxxxxxxxx/resourceGroups/RG-SPMSDN-LASTD-POC/providers/Microsoft.Web/sites/LASTD-SPMSDN-EAI-POC/hostruntime/runtime/webhooks/workflow/api/management/workflows/DemoHTTP/runs?api-version=2018-11-01

Sample Response:

Status Code: 200

We may also get some errors if you try to cancel an already completed instance.

{
    "value": [
        {
            "properties": {
                "waitEndTime": "2023-01-09T10:37:36.9988341Z",
                "startTime": "2023-01-09T10:37:36.9988341Z",
                "endTime": "2023-01-09T10:37:38.9480163Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585283462284798311177740271CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585283475919679565",
                    "name": "08585283475919679565",
                    "type": "workflows/versions"
                },
                "trigger": {
                    "name": "manual",
                    "inputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxx/runs/08585283462284798311177740271CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283462284798311177740271CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=hgIpAfmo4kOdJ_bNwXhvmmD3m_mo8KY3ANeKUwk86ZM",
                        "contentSize": 2
                    },
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxx/runs/08585283462284798311177740271CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283462284798311177740271CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=_rs0On_muhcy3a9Nq6nrB-3kOnW6Xa_NgkaBkvc3zQ0",
                        "contentSize": 3541
                    },
                    "startTime": "2023-01-09T10:37:36.9980725Z",
                    "endTime": "2023-01-09T10:37:36.9980725Z",
                    "originHistoryName": "08585283462284798311177740271CU00",
                    "correlation": {
                        "clientTrackingId": "08585283462284798311177740271CU00"
                    },
                    "status": "Succeeded"
                },
                "outputs": {}
            },
            "id": "/workflows/DemoHTTP/runs/08585283462284798311177740271CU00",
            "name": "08585283462284798311177740271CU00",
            "type": "workflows/runs"
        },
        {
            "properties": {
                "waitEndTime": "2023-01-09T10:15:00.3587608Z",
                "startTime": "2023-01-09T10:15:00.3587608Z",
                "endTime": "2023-01-09T10:15:00.6643048Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585283475851195588749398419CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585283475919679565",
                    "name": "08585283475919679565",
                    "type": "workflows/versions"
                },
                "trigger": {
                    "name": "manual",
                    "inputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxx/runs/08585283475851195588749398419CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283475851195588749398419CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=tSCoAq49tK2DQbQNcIpzNnTOcucvPTHmNwDEb7L_ZYM",
                        "contentSize": 2
                    },
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxx/runs/08585283475851195588749398419CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283475851195588749398419CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=EuCVyfV1kQjwwlLQplQqT39AumkGidYGhWDPA0Mv5ew",
                        "contentSize": 1144
                    },
                    "startTime": "2023-01-09T10:15:00.3580393Z",
                    "endTime": "2023-01-09T10:15:00.3580393Z",
                    "originHistoryName": "08585283475851195588749398419CU00",
                    "correlation": {
                        "clientTrackingId": "08585283475851195588749398419CU00"
                    },
                    "status": "Succeeded"
                },
                "outputs": {},
                "response": {
                    "name": "Response",
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxx/runs/08585283475851195588749398419CU00/contents/ResponseOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283475851195588749398419CU00%2Fcontents%2FResponseOutputs%2Fread&sv=1.0&sig=AcySKrg9iWVe1pGhLP4xdmvHuOfG3doS_tc4tY2LWtM",
                        "contentSize": 46
                    },
                    "startTime": "2023-01-09T10:15:00.3588287Z",
                    "endTime": "2023-01-09T10:15:00.6455744Z",
                    "correlation": {
                        "clientTrackingId": "08585283475851195588749398419CU00"
                    },
                    "code": "OK",
                    "status": "Succeeded"
                }
            },
            "id": "/workflows/DemoHTTP/runs/08585283475851195588749398419CU00",
            "name": "08585283475851195588749398419CU00",
            "type": "workflows/runs"
        },
        {
            "properties": {
                "waitEndTime": "2023-01-09T10:14:56.6507366Z",
                "startTime": "2023-01-09T10:14:56.6507366Z",
                "endTime": "2023-01-09T10:14:58.6732805Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585283475889371416241396129CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585283475919679565",
                    "name": "08585283475919679565",
                    "type": "workflows/versions"
                },
                "trigger": {
                    "name": "manual",
                    "inputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxx/runs/08585283475889371416241396129CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283475889371416241396129CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=D18HGfNtYLzq2AEtgFqVLkkRvULNPvCeCa1SvBpa3nQ",
                        "contentSize": 2
                    },
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxxxx/runs/08585283475889371416241396129CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283475889371416241396129CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=3axc0IdnGm4oO0rmJrfrX3YiDfpsR9nQ5ctDlPVeU-g",
                        "contentSize": 1144
                    },
                    "startTime": "2023-01-09T10:14:56.5500175Z",
                    "endTime": "2023-01-09T10:14:56.5500175Z",
                    "originHistoryName": "08585283475889371416241396129CU00",
                    "correlation": {
                        "clientTrackingId": "08585283475889371416241396129CU00"
                    },
                    "status": "Succeeded"
                },
                "outputs": {},
                "response": {
                    "name": "Response",
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxxxxxxxxx/runs/08585283475889371416241396129CU00/contents/ResponseOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283475889371416241396129CU00%2Fcontents%2FResponseOutputs%2Fread&sv=1.0&sig=h20YChZzmAiFqHJy6pHSxQIe0RPlxIwPX_8UlZC2OGQ",
                        "contentSize": 46
                    },
                    "startTime": "2023-01-09T10:14:56.6856426Z",
                    "endTime": "2023-01-09T10:14:58.6090884Z",
                    "correlation": {
                        "clientTrackingId": "08585283475889371416241396129CU00"
                    },
                    "code": "OK",
                    "status": "Succeeded"
                }
            },
            "id": "/workflows/DemoHTTP/runs/08585283475889371416241396129CU00",
            "name": "08585283475889371416241396129CU00",
            "type": "workflows/runs"
        },
        {
            "properties": {
                "waitEndTime": "2023-01-09T10:13:58.6761434Z",
                "startTime": "2023-01-09T10:13:58.6761434Z",
                "endTime": "2023-01-09T10:13:59.0232985Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585283476468021537543143313CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585283477145621096",
                    "name": "08585283477145621096",
                    "type": "workflows/versions"
                },
                "trigger": {
                    "name": "manual",
                    "inputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxxx/runs/08585283476468021537543143313CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283476468021537543143313CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=5bZVwL5pXWS0qAPRSxtfAzRxvibNObZAPTdBP30va-8",
                        "contentSize": 2
                    },
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxxxxxxxxxxxx/runs/08585283476468021537543143313CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283476468021537543143313CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=oHizYha7-xdqDGK8vQ23_4n3sRjNhf7dGPt3WKg-Gyg",
                        "contentSize": 1144
                    },
                    "startTime": "2023-01-09T10:13:58.6754443Z",
                    "endTime": "2023-01-09T10:13:58.6754443Z",
                    "originHistoryName": "08585283476468021537543143313CU00",
                    "correlation": {
                        "clientTrackingId": "08585283476468021537543143313CU00"
                    },
                    "status": "Succeeded"
                },
                "outputs": {},
                "response": {
                    "name": "Response",
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxxx/runs/08585283476468021537543143313CU00/contents/ResponseOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283476468021537543143313CU00%2Fcontents%2FResponseOutputs%2Fread&sv=1.0&sig=Ikp1b_4ziSKX411LM9aKpWmGZE_GNpBMUw6pPKLmCD0",
                        "contentSize": 20
                    },
                    "startTime": "2023-01-09T10:13:58.6761767Z",
                    "endTime": "2023-01-09T10:13:59.0014749Z",
                    "correlation": {
                        "clientTrackingId": "08585283476468021537543143313CU00"
                    },
                    "code": "OK",
                    "status": "Succeeded"
                }
            },
            "id": "/workflows/DemoHTTP/runs/08585283476468021537543143313CU00",
            "name": "08585283476468021537543143313CU00",
            "type": "workflows/runs"
        },
        {
            "properties": {
                "waitEndTime": "2023-01-09T10:13:55.0871282Z",
                "startTime": "2023-01-09T10:13:55.0871282Z",
                "endTime": "2023-01-09T10:13:57.0799951Z",
                "status": "Succeeded",
                "correlation": {
                    "clientTrackingId": "08585283476504944788005579297CU00"
                },
                "workflow": {
                    "id": "/workflows/DemoHTTP/versions/08585283477145621096",
                    "name": "08585283477145621096",
                    "type": "workflows/versions"
                },
                "trigger": {
                    "name": "manual",
                    "inputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxx/runs/08585283476504944788005579297CU00/contents/TriggerInputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283476504944788005579297CU00%2Fcontents%2FTriggerInputs%2Fread&sv=1.0&sig=syEc_IyPeOEkrkKVb9aMhxFBt6TXSJUlFvbAX9WM_S8",
                        "contentSize": 2
                    },
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxxxxxxxx/runs/08585283476504944788005579297CU00/contents/TriggerOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283476504944788005579297CU00%2Fcontents%2FTriggerOutputs%2Fread&sv=1.0&sig=66zkoZXdBg8Z5HhJY_ph2HKTRRALmBYkwzGPka2UZBE",
                        "contentSize": 1144
                    },
                    "startTime": "2023-01-09T10:13:54.9924658Z",
                    "endTime": "2023-01-09T10:13:54.9924658Z",
                    "originHistoryName": "08585283476504944788005579297CU00",
                    "correlation": {
                        "clientTrackingId": "08585283476504944788005579297CU00"
                    },
                    "status": "Succeeded"
                },
                "outputs": {},
                "response": {
                    "name": "Response",
                    "outputsLink": {
                        "uri": "https://lastd-la-with-error.azurewebsites.net:443/runtime/webhooks/workflow/scaleUnits/prod-00/workflows/xxxxxxxxxxx/runs/08585283476504944788005579297CU00/contents/ResponseOutputs?api-version=2018-11-01&code=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx%3d%3d&se=2023-01-12T02%3A00%3A00.0000000Z&sp=%2Fruns%2F08585283476504944788005579297CU00%2Fcontents%2FResponseOutputs%2Fread&sv=1.0&sig=4tvsLPQ3d5gfw2HfhMuezRS2SdYHZp2HvuhLnFB3SrM",
                        "contentSize": 20
                    },
                    "startTime": "2023-01-09T10:13:55.1265121Z",
                    "endTime": "2023-01-09T10:13:57.0138955Z",
                    "correlation": {
                        "clientTrackingId": "08585283476504944788005579297CU00"
                    },
                    "code": "OK",
                    "status": "Succeeded"
                }
            },
            "id": "/workflows/DemoHTTP/runs/08585283476504944788005579297CU00",
            "name": "08585283476504944788005579297CU00",
            "type": "workflows/runs"
        }
    ]
}

Stay tuned for the next Operation Group: Workflow Trigger Histories.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.
View all posts by Sandro Pereira

January 9, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

January 9, 2023 Weekly Update on Microsoft Integration Platform & Azure iPaaS

by | Jan 8, 2023 | BizTalk Community Blogs via Syndication

__CONFIG_colors_palette__{“active_palette”:0,”config”:{“colors”:{“f3080”:{“name”:”Main Accent”,”parent”:-1},”f2bba”:{“name”:”Main Light 10″,”parent”:”f3080″},”trewq”:{“name”:”Main Light 30″,”parent”:”f3080″},”poiuy”:{“name”:”Main Light 80″,”parent”:”f3080″},”f83d7″:{“name”:”Main Light 80″,”parent”:”f3080″},”frty6″:{“name”:”Main Light 45″,”parent”:”f3080″},”flktr”:{“name”:”Main Light 80″,”parent”:”f3080″}},”gradients”:[]},”palettes”:[{“name”:”Default”,”value”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]},”original”:{“colors”:{“f3080”:{“val”:”rgb(23, 23, 22)”,”hsl”:{“h”:60,”s”:0.02,”l”:0.09}},”f2bba”:{“val”:”rgba(23, 23, 22, 0.5)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.5}},”trewq”:{“val”:”rgba(23, 23, 22, 0.7)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.7}},”poiuy”:{“val”:”rgba(23, 23, 22, 0.35)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.35}},”f83d7″:{“val”:”rgba(23, 23, 22, 0.4)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.4}},”frty6″:{“val”:”rgba(23, 23, 22, 0.2)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.2}},”flktr”:{“val”:”rgba(23, 23, 22, 0.8)”,”hsl_parent_dependency”:{“h”:60,”s”:0.02,”l”:0.09,”a”:0.8}}},”gradients”:[]}}]}__CONFIG_colors_palette__