Is it possible to get the oracle response in json format RRS feed

  • Question

  • Hi,

    Currently i am executing oracle package of both input and output type as record  type. i am passing the input in xml file and getting back the result in xml file using biztalk application.  

    is it possible to get the output in json format? 

    Tuesday, May 10, 2016 7:51 AM


  • Hi Rachit,

    I am using biztalk server 2013 R2. in administration console -> sent port->  send pipeline-> only xml transmit and pass thru transmit pipelines are there. 

    there are no json related pipelines so do i need to install the json pipe line component separately in biztalk server 2013 R2.

    You have to Create custom pipelines to process JSON messages.

    Also refer: Working with JSON in BizTalk Server 2013 R2

    1. In the BizTalk Server application, from the Solution Explorer, right-click the project, and point to Add > New Item > Send Pipeline. Provide the pipeline name as XmlToJSONSendPipeline.btp, and then click Add.

    2. Within the Encode stage add the new JSON encoder. In the other stages and other pipeline components as shown in the screenshot, and save changes.

      Custom send pipeline

    Deploy and use the new pipeline.

    Rachit Sikroria (Microsoft Azure MVP)

    Tuesday, May 10, 2016 9:02 AM

All replies