Pipelines are probably the least properly utilized tools in the BizTalk toolbox. Pipeline is important part of BizTalk server in message processing. It is a component of Microsoft BizTalk Server that provides an implementation of the Pipes and Filters integration pattern. As per BizTalk runtime architecture, pipeline comes just after receive message on receive port/receive … Continue reading BizTalk Pipeline
Handle Array/List Json messages in BizTalk Receive Pipeline
This blog is to explain how to handle below requirements in BizTalk Receive Pipeline. Handle Non-List/Array json messagesHandle List/Array json messagesRemove special characters before Json Decoder pipeline stage Let's discuss these points. Handle Non-List/Array json messages By default, BizTalk Receive Pipeline Json Decoder can convert the Json message to Xml message. Example: { "ForeignTax": … Continue reading Handle Array/List Json messages in BizTalk Receive Pipeline
BizTalk Custom Pipeline to Convert Excel file to Flat file
This blog explains how to convert .xlsx to Flat file in BizTalk using Custom Pipeline. Below pipeline component is generic one which can be applied to any excel files for FlatFile conversion. Sample Input (Excel File): Sample Output (Flat File): Please follow below steps. Take a class library project and keep code which is present … Continue reading BizTalk Custom Pipeline to Convert Excel file to Flat file
BizTalk Custom Pipeline to Convert Excel file to Xml file
This blog explains how to convert .xls to Xml file in BizTalk using Custom Pipeline. Below pipeline component is generic one, which can be applied to any excel files for xml conversion. Sample Input (Excel File): Sample Output (Xml File): Please follow below steps. Take a class library project and keep the code mentioned in … Continue reading BizTalk Custom Pipeline to Convert Excel file to Xml file
Custom Pipeline to Add DocType in Message
Sometimes we require to add some element, tag, DocType in incoming or outgoing message from BizTalk. We can achieve this by using custom pipeline. But we should use this pipeline component in Decode or encode stage of Pipeline. In this sample custom pipeline, we convert the message in string. So you can take this code … Continue reading Custom Pipeline to Add DocType in Message
BAM Activity in Custom Pipeline
Sometimes requirement cannot be fulfil by using tracking profile editor for BAM logging. Here in this code I am explaining about how to use BAM in custom pipeline. And also I am using EnableContinuation method so that we can get all the details in single row in BAM table while using different stage of BAM … Continue reading BAM Activity in Custom Pipeline
