Can my REST procedure create JSON response instead of XML?

[shiloh.jordan]

Hi,

I have a REST virtual procedure inside my view model that returns XML - shown below:

Is there a way to create JSON transformation instead of XML?

When testing my REST war, the response can be returned as XML or JSON, but my JSON does not produce literal values. Type information in JSON should be "21" = string vs 21=numeric.  However, my response has double quotes around both string and numeric.  How can I create JSON response in REST procedure?

All help is appreciated

Thanks

[rareddy]

Shiloh,

The Rest procedure the way you designed above, takes the XML output you generated and converts that to JSON automatically. It is not smart enough to figure out the differences in the data type representation. My suggestion would be, if you do not care about XML output, rewrite the same procedure using JSON based functions instead of XML functions and return the JSON payload the way you need. But if you do that convert the "xml_out:XMLLiteral" to clob.

Ramesh..

[shiloh.jordan]

Thanks for quick response Ramesh...

Much appreciated.