No announcement yet.

Sending JSON from Oracle DB to HTTP Sender

  • Filter
  • Time
  • Show
Clear All
new posts

  • Sending JSON from Oracle DB to HTTP Sender

    Dear Support,

    I am little new in Mirth Connect and have query on below situation in order to configure mirth:

    We are having Oracle Database Connection and web services from 3rd party with a POST requires on HTTP Interface.

    Web Interface requires JSON Data input using POST Method, So I was wondering If I add all my Oracle SQL Queries, will Mirth form JSON output data elements in one message and automatically send to web service using Destination as HTTP Sender?

    Also i have noticed that when mirth is forming JSON data, it add extra html tags in message like <result> I dont know why mirth is adding this extra tags?
    For e.g. below message formed by Json: -
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <engnm>Mrs. Alpha Bravo Delta Epsilon Charlie</engnm>

    Any support/tutorial specifically on JSON implementation using Oracle DB to HTTP Sender will be highly appreciated.

    Also do i need to code like javascript or something in order to achive above?

    Kindly guide me.

  • #2
    A Database Reader generates an XML message, which is what you have shared in your question. "Result" is your query result, and it contains elements for the db columns you selected.

    You will have to transform this to JSON. The web service you are sending this to likely requires the JSON to be formatted in a specific way. You should find out what that needs to look like.


    • #3
      transform this to JSON?

      Dear, yes mirth add additional element <result> in generated message. How can I convert XML to JSON and use trasforming feature of Mirth.

      Any tutorial or steps to achieve will be highly appreciated.