Integration

Get Involved. Join the Conversation.

Topic

    Noam Tamarkin
    The OIC Invoke endpoint convert body json field integer to...
    Topic posted November 11, 2019 by Noam Tamarkin, tagged Integration 
    15 Views, 4 Comments
    Title:
    The OIC Invoke endpoint convert body json field integer to string
    Content:

    I have a POST service on OIC with JSON body that have integer fields.

    When I check the call to the service provider log, I see that the double are becoming strings For example:

    Original request body:[
    {
    "itemNumber" : "551",
    "section" : null,
    "statusId" : 11
    },
    {
    "itemNumber" : "99-30",
    "section" : 3,
    "statusId" : 2
    }
    ]
     
    The request body that the service provider gets:
    [
    {
    "itemNumber" : "551",
    "section" : "",
    "statusId" : "11"
    },
    {
    "itemNumber" : "99-30",
    "section" : "3",
    "statusId" : "2"
    }
    ]

    That is rejected by the service provider.

    I made sure that the WSDL's of OIC show data type of double  on Trigger and Invoke requests.

    Any ideas?

     

    Thansk,

    Noam

    Version:
    19.3.3.190924.1600-31522

    Comment

     

    • Hemanth Lakkaraju

      Can you show the mapping? What datatype you see in the mapping when you hover over the elements - String or Double? What is the error from target service? How did you figure out the request body that service provider gets?

      I suspect the problem is not with the double element but element "section" - Is this specified as nillable in wsdl?

    • Noam Tamarkin

      Hi,

      The data types are double and nillable for the 2 fields "section" ,"statusId".

      I have attached the WSDL's and the XSLT (in a a zip file).

      I hope this would be god enough.

      Thanks for the help and fast response,

      Noam

      D.zip (6KB)
      • Hemanth Lakkaraju

        This seems to be a known issue on your OIC version - 19.3.3.190924.1600-31522. This is fixed in next version and please await until next version is released. If there is an urgency, please raise an SR with Oracle to expedite the upgrade for your instance.

    • Noam Tamarkin

      Hi,

       

      Thanks for your explanation.

      I will open the SR.

      Best Regards,

      Noam