Test Azure Logical Transformation App

Download 13.11 Kb.
NameTest Azure Logical Transformation App
A typeTest


This whitepaper provides information on how to create Azure logic app for xml transformation.

This app will pick up the source xml from on premise directory, convert xml to another format and put that xml into another on premise directory.

For me that was the first step, but in a real BizTalk scenario there at least has to be one map! My scenario is to read from my local laptop ‘inbox’ folder, transform the message and write to the same laptop to an ‘output’ folder.

Components Required

Below are the software and components for creating the Sample

  • Visual Studio 2012.

  • Windows Azure BizTalk Services SDK

  • Azure Subscription.

Step by Step

  • Create Service Bus namespace on Azure portal.

  • Create and configure File connector API to connect local on premise directory with Azure.

  • Create Schema and Map required to transform XML format.

  • Create BizTalk Transformation API and upload created map in API

  • Test Azure Logical Transformation App.

Create ServiceBus namespace

We need to create Azure Service Bus namespaces, since it’s required for configuring file connector. File connector under the hood uses the Service Bus Relay technology to connect to the on premise environment.

Service Bus namespace can be created from the old portal.

You can copy the connection string of the service bus from the connection information, which is required for configuring the File connector.

Create and Configure File connector for Directory

Create File Connector to connect with on premise local directory.

Goto Marketplace->Api Apps->File Connector.

Name: SharedDriveAFileConnector.

Roor Folder: D:\Azure\ShareDriveA

Service Bus Connection String: copied from the Service bus connection information.

Once you click the create button, it will take about a minute to provision the File connector (API App), before you can use it in your solution (Azure Logic App). You need to repeat the above steps to configure the second File connector to the destination location,

Goto Marketplace->Api Apps->File Connector.

Name: SharedDriveBFileConnector.

Roor Folder: D:\Azure\ShareDriveB

Service Bus Connection String: copied from the Service bus connection information.

As you can notice there is a warning sign in the blade showing “Hybrid Connection – On Premise Setup Incomplete”, just click on that box, which will open up “Hybrid Connection” blade. You will see a link labelled ON-PREMISES HYBRID CONNECTION MANAGER “Download and configure”, clicking on that will download the on-premise agent file. Copy that file to the server where you’ll have your folder location, and start installing it (internet connection is required of course), the installer will ask for service bus relay connection string as shown below

Once you provide that information and completed the installation procedure, leave few seconds and check back on the File Connector blade, it should now show the connection successfully established as shown below.

Create BizTalk Transformation API

We have to transform one XML to another so we will use BizTalk Transform API and use into our logic app.

Again go to the Azure Marketplace, search for “BizTalk Transform service” and create a new instance. Steps for creating the BizTalk Transform service is straight forward and doesn’t need any hybrid connection step up.

Once API created we can add map into the service.

Create BizTalk Schema and Map

Create the BizTalk Schema and Map in Visual Studio 2012.

  1. Create Input Schema

  1. Create Output Schema

  1. Create Map for transformation.

  1. Upload Map into the BizTalk Transformation Service API App.

Create Azure Logic App

Goto Azure portal

New-> Logic Apps->Logic App->

Name: AzureTransformationApp

Click on Trigger and Action

Configure BizTalk Transformation Service.

Configure File Connector.

Test the Application

1: Drop the input file at source location.

2: Check the target location







You can check the status of runs from the dashboard.

Possible Error

How to Check Errors in Azure Logic Apps:

Go to Logic App.

Click on Trigger History

Error “duplicate collection entry”:

Error Statement: Cannot add duplicate collection entry of type 'mimeMap' with unique key attribute 'fileExtension' set to '.json'

Solution: Remove the mimeMap tag from IIS service which was created for File Connector

Error “Access Denied”:

Check access of folder location.

Share in:


Test Azure Logical Transformation App iconSigning app Note: signing the app is only necessary when you intend...

Test Azure Logical Transformation App iconRemote Event Handlers in O365 & Azure Part 5: Setup the Windows Azure...

Test Azure Logical Transformation App iconDownload the app To get started, make sure you are using an iPhone...

Test Azure Logical Transformation App iconDescription of Product: Outlook Mobile app for ios is the business-class...

Test Azure Logical Transformation App iconBlind Square is a combination Point of Interest poi and basic navigating...

Test Azure Logical Transformation App iconIs the app name that appears to users. For this project, use "My First App."

Test Azure Logical Transformation App iconWalkthrough: Deploying a SignalR autohosted App to Office 365 Written...

Test Azure Logical Transformation App iconClaroCom is an ios app designed for aac (Augmentative and Alternative...

Test Azure Logical Transformation App iconLogical Fallacies Packet 1

Test Azure Logical Transformation App iconHigher Education in Transformation 2016

forms and shapes

When copying material provide a link © 2017