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.

    • To get around this issue we created a Custom Pipeline Component to remove the BOM.

  • 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 “: “”

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top