Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Venkatesh Reddy
    Publish JSON message into AmazonMQ
    Topic posted August 14, 2019 by Venkatesh ReddyRed Ribbon: 250+ Points 
    5 Views
    Title:
    Publish JSON message into AmazonMQ
    Summary:
    Adding extra special characters in AmazonMQ while publishing JSON message which is in String variable
    Content:

    Hi,

    Development done in oracle soa 12.2.1.3

    Consuming JSON message by Dequeueing  in base64 format so that decoded that base64 and assign to one string variable which is having JSON message like below.

    ****************************

    {

          "OrderStatus": {

                "Header": {

                      "Transaction Number":  "CPQ-3260-37210612",

                      "Transaction Internal ID":"37210612",

                      "Customer Id": "300000030758103",

                      "CPQ Source System Code": "ORA_BM_CPQ",

                      "SubscriptionEndDate":"2019-08-16 00:00:00",

                      "Subscription Id": "300000031172516",

                      "Source Order No":"WEB1234",

                      "Account Number": "300000030758103",

                      "Subscription Status": "success",

                      "UCN Number": "600007791",

                      "Subscription Number":"CPQ-3260-37210612",

                "LineLevel":      {

                      "Install To": "9355 SAPPINGTON RD; SAINT LOUIS; MO; US; 63126-3043;",

                      "Contract End Date": "2019-08-16 00:00:00",

                      "Line BOM Part Number": "560001",

                      "Status": "Fulfilled",

                      "gracePeriodDays_l": "10",

                      "autoRenew_l": "Yes"

                                        }

                                  }

    }

    }

    **************************

    while publishing same String variable data(JSON message like above)  into AmazonMQ, but AmazonMQ storing that JSON message like below(Added extra special chars like " \ and \n"

    "{\n      \"OrderStatus\": {\n            \"Header\": {\n                  \"Transaction Number\":  \"CPQ-3260-98765403030\",\n                  \"Transaction Internal ID\":\"37210612\",\n                  \"Customer Id\": \"300000030758103\",\n                  \"CPQ Source System Code\": \"ORA_BM_CPQ\",\n                  \"SubscriptionEndDate\":\"2019-08-16 00:00:00\",\n                  \"Subscription Id\": \"300000031172516\",\n                  \"Source Order No\":\"WEB1234\",\n     

     

    How ca we remove those special chars' while publishing String variable JSON message.    

    Can you please help me out.

     

    Version:
    Oracle SOACS 12.2.1.3

    Comment