BizTalk Component to convert any excel to XML file

namespace excelPipelinecomponent { using System; using System.IO; using System.Text; using System.Drawing; using System.Resources; using System.Reflection; using System.Diagnostics; using System.Collections; using System.ComponentModel; using Microsoft.BizTalk.Message.Interop; using Microsoft.BizTalk.Component.Interop; using Microsoft.BizTalk.Component; using Microsoft.BizTalk.Messaging; using Microsoft.BizTalk.Streaming; using NPOI.XSSF.UserModel; using System.Xml; using NPOI.SS.UserModel; [ComponentCategory(CategoryTypes.CATID_PipelineComponent)] [System.Runtime.InteropServices.Guid("626ec459-f33a-431c-b368-d690a389157b")] [ComponentCategory(CategoryTypes.CATID_Decoder)] public class myOwnExcel : Microsoft.BizTalk.Component.Interop.IComponent, IBaseComponent, IPersistPropertyBag, IComponentUI { private System.Resources.ResourceManager resourceManager = new System.Resources.ResourceManager("excelPipelinecomponent.myOwnExcel",...

Logic Apps : Create JSON or XML using XSLT through Function App

Original Post in msdn Introdu​ctio​n Recently,I have delivered a set of Logic Apps to my client which accepts SOAP messages from Salesforce and delivers into Azure DB. I have observed that we use Integration Account for transforming XMLs in Logic Apps using XSLT that costs alone 1000 USD monthly extra. Enterprise Integration Pack To transform a...

Leverage your Logic Apps performance using Azure Functions

Original post is available in MSDN Introduction In this article, I am going to give a heads-up how the performance degrades when you intend to do every operation inside Logic Apps and also how to leverage our LA performance using Azure Functions. Scenario Inside my flow, I need to call an API that outputs JSON. My...

BizTalk Azure installation

I have recently has gone half through and installed Biztalk in Azure. I have created  2 BizTalk Virtual Machiens and one SQL Server to configure the backend. I was successfully able to connect the SQL instance in both BizTalk Virtual machines, I have Run SQL Server Configuration Manager - > SQL Server Network Configuration ->Protocols...

Deployment of Logic App using VS 2015

I have got the “Parameter ‘Environment’ is obsolete.” error, while deploying my first Logic app through Visual Studio 2015, which has no meaning to the actual error. 13:53:14 – ‘C:\Users\{username}\documents\visual studio 2015\Projects\Auto\Auto\bin\Debug\staging\Auto\Deploy-AzureResourceGroup.ps1’ -StorageAccountName ” -ResourceGroupName ‘baraneespecific’ -ResourceGroupLocation ‘centralus’ -TemplateFile ‘c:\users\{username}\documents\visual studio 2015\projects\auto\auto\azuredeploy.json’ -TemplateParametersFile ‘c:\users\{username}\documents\visual studio 2015\projects\auto\auto\logicapp.parameters.json’ -ArtifactStagingDirectory ‘.’ -DSCSourceFolder ‘.\DSC’ -ValidateOnly 13:53:14 – [WARNING] Parameter ‘Environment’...

Parallel Processing in Logic App

Introduction Logic Apps provide a way to simplify and implement scalable integrations and workflows in the cloud. It provides a visual designer to model and automate your process as a series of steps known as a workflow. There are many connectors across the cloud and on-premises to quickly integrate across services and protocols. Whilst designing...

Redirect

  Visit : howtologicapp.wordpress.com

Parallel shape in Logic A

Check out the latest Article https://social.technet.microsoft.com/wiki/contents/articles/37620.parallel-processing-in-logic-app.aspx Introduction In this article I would like to explain batch processing using parallel shape in Logic App. Parallel Processing in Logic app is a mechanism by which two or more different actions can take place concurrently but independently. Scenario Consider an example, We are going to create an Logic...

Logic App Dev Tips – 1

Problem During the development of Logic App, in the response shape if the previous used shapes output is not visible in the designer Solution: Check the runafter() contains the shape that you are trying. For example, in the below Logic App I have a parallel shape that contains 5 Rest calls and after that one response...

Parallel Processing in Logic App

Hi Friends, in this article I would like to explain parallel processing in Logic App. Parallel Processing in Logic app is a mechanism by which two or more different actions can take place concurrently but independently. Consider an example that calls 2 independent list of Services in parallel and One with 25 seconds of delay. First...

Standard vs Enterprise Here is the difference between Enterprise and Standard edition solutions.

Debatching in LogicApp

https://social.technet.microsoft.com/wiki/contents/articles/37351.azure-logicapp-debatching-splitting-messages-and-process-them-separately.aspx Table of Contents Introduction Scenario Using Singleton Technique JSON Message Using Debatching Technique splitOn Output Conclusion Introduction Hi friends,  In this article I would like to explain Debatching technique in Logic app with two examples.  Debatching is a technique of splitting your messages based on any repeated element in the message and process them...