Monitor and track B2B transactions in Standard workflows for Azure Logic Apps (Preview)

Applies to: Azure Logic Apps (Standard)

To make sure that business operations run smoothly, maintain compliance, and troubleshoot problems in B2B enterprise integration scenarios, you need to accurately and reliably track B2B transactions that flow through your integration solutions. If you have Standard logic app workflows that work with X12, EDIFACT, or AS2 transactions, you have access to robust tracking capabilities that help you monitor B2B exchanges effectively.

With a Premium-level integration account, you can set up B2B tracking for Standard workflows using Azure Data Explorer. This capability accurately tracks all B2B transactions by having Azure Data Explorer store every transaction in a cluster and database, which provide lossless tracking along with visualization and querying capabilities.

For example, you get a tracking dashboard so you that can efficiently monitor, search, and analyze B2B transactions. For more detailed analysis, you can create advanced queries in your cluster database. With tracking data stored in Azure Data Explorer, you can extend Microsoft Power BI dashboards or build custom dashboards with your data.

This guide provides a short overview about how B2B tracking works, how to set up this capability for your Standard logic app resource and workflows, and how to open the tracking dashboard.

Limitations and known issues

• In this preview release, tracking currently handles only X12 and AS2 transactions.

How does B2B tracking work

The following table describes how various components work together to support B2B tracking:

Prerequisites

• An Azure account and subscription. If you don't have a subscription, sign up for a free Azure account.

• A Premium-level integration account. If you don't have this integration account, see Create and manage integration accounts for B2B workflows in Azure Logic Apps.

• A Standard workflow that uses AS2 or X12 built-in actions

  Currently, B2B tracking supports only transactions processed by these actions.

• An Azure Data Explorer cluster and database to store transaction logs and tracking data.

  If you don't have an existing cluster and database, see Quickstart: Create an Azure Data Explorer cluster and database and What is Azure Data Explorer.

Set up B2B tracking

For this task, you need to create a tracking store in your integration account. An integration account currently supports only one default tracking store.

Create a tracking store for your integration account

1. In the Azure portal, open your Premium-level integration account.

2. On the integration account menu, under Settings, select Tracking stores.

3. On the toolbar, select Add. On the Add tracking store pane, provide the following information:

   Property	Value
   Subscription	The Azure subscription for your Azure Data Explorer cluster.
   Azure Data Explorer	The cluster name in Azure Data Explorer.
   Database	The cluster database name.

   For example:

   

4. When you're done, select OK.

Disable or enable B2B tracking at the agreement level

If you have existing agreements between trading partners in your integration account, you can disable or reenable tracking for each agreement. By default, tracking is enabled for agreements. Currently, you can disable or reenable tracking for an agreement only through JSON view.

1. In the Azure portal, open your Premium-level integration account.

2. On the integration account menu, under Settings, select Agreements. Select an agreement.

3. On the Agreements page toolbar, select Edit as JSON.

4. In the agreement, find the sendAgreement and receiveAgreement objects.

5. To disable tracking, change trackingState to Disabled. To reenable tracking, change trackingState to or Enabled.

For more information, see the following documentation:

• Add agreements between partners in integration accounts
• Add trading partners to integration accounts

Troubleshoot tracking setup problems

For tracking to work correctly, make sure that all the following conditions are met:

• A tracking store exists in your integration account.
• In an agreement, the trackingState attribute is set to Enabled.

Open the tracking dashboard

1. Before you use the tracking dashboard, make sure that your workflow runs some X12, EDIFACT, or AS2 built-in actions so that the tracking store contains data.

2. On your integration account menu, under Monitoring, select B2B tracking, which opens the dashboard.

   By default, the Overview tab is selected and shows a high-level summary with graphs for all supported message types, message statuses, partners with the most errors, and a message summary for each partner.

   Tab	Description
   Overview	View a high-level summary for all supported message types.
   AS2	View the details for all collected AS2 transactions.
   X12	View the details for all collected X12 transactions.

   For example:

   

3. To change the dashboard's time interval from the default value, from the TimeRange list, select the interval you want.

4. To view the details for the collected messages, select the AS2 or X12 tab.

   The selected tab shows the collected messages along with their properties and values.

   The following example shows the available details for collected X12 messages:

   

Database tables

In your Azure Data Explorer cluster, the database stores transaction data in a table-structured format. This table structure provides the capability for you to efficiently query and retrieve B2B tracking data, provide structured insights into message flow, processing status, and troubleshoot problems.

• The table named AS2TrackRecords stores AS2 transactions.
• The table named EdiTrackRecords stores X12 and EDIFACT transactions.

Manage tracking stores with the REST API

You can use the Azure Logic Apps REST API to programmatically create, update, delete, and retrieve your tracking store.

Create or update a tracking store

Create a tracking store or update an existing one.

PUT https://management.azure.com/subscriptions/{subscription-ID}/resourceGroups/{resource-group-name}/providers/Microsoft.Logic/integrationAccounts/{integration-account-name}/groups/default/trackingstores/{tracking-store-name}?api-version=2016-06-01

Request body

{ 
  "properties": {
    "adxClusterUri": "https://{cluster-name}.kusto.windows.net",
    "databaseName": "{database-name}"
  }
}

Response

Return the details for the created or updated tracking store.

Get a specific tracking store

Get the details about a specific tracking store.

GET https://management.azure.com/subscriptions/{subscription-ID}/resourceGroups/{resource-group-name}/providers/Microsoft.Logic/integrationAccounts/{integration-account-name}/groups/default/trackingstores/{tracking-store-name}?api-version=2016-06-01

Parameters:

Response

Return the details about the specified tracking store.

Get all tracking stores

Get all the tracking stores in your integration account.

GET https://management.azure.com/subscriptions/{subscription-ID}/resourceGroups/{resource-group-name}/providers/Microsoft.Logic/integrationAccounts/{integration-account-name}/groups/default/trackingstores?api-version=2016-06-01

Response

Return a list of tracking stores associated with your integration account.

Delete a tracking store

Delete an existing tracking store from your integration account.

DELETE https://management.azure.com/subscriptions/{subscription-ID}/resourceGroups/{resource-group-name}/providers/Microsoft.Logic/integrationAccounts/{integration-account-name}/groups/default/trackingstores/{tracking-store-name}?api-version=2016-06-01

Response

Return a success response for a successfully deleted tracking store.

Related content

• Schemas for tracking B2B transactions - Standard workflows