REST JSON Christmas Puzzle – Work around

Posted: January 4, 2016  |  Categories: BizTalk Uncategorized
Tags: JSON Pipeline

I created the following workaround  to my Christmas puzzle . I created a custom pipeline that includes the Json encoder and BRE pipeline framework pipeline components.

jsonpipeline

I created a business rule shown below to replace null,  with “ “, in the JSON message and ran this from the BRE pipeline component framework. This would not be good with large messages but I went with this because my JSON messages will be small.

BRE

Please let me know if you find a better work around.

  • The one issue with the above work around is that it adds a Byte Order Mark to the message. This is a problem with some systems.

  • Pingback: BizTalk 2013 R2 known bugs, issues & quirks | BizTalk musings()

  • Also the the Action should be as follows, otherwise if the last null is the last item it will not get replaced.
    Replace the string “: null in the message body with the string “: “”

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top