Can my REST procedure create JSON response instead of XML?

shiloh.jordan Nov 13, 2017 8:30 PM

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

1. Re: Can my REST procedure create JSON response instead of XML?

rareddy Nov 14, 2017 9:00 AM (in response to shiloh.jordan)

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..
Actions
2. Re: Can my REST procedure create JSON response instead of XML?

shiloh.jordan Nov 14, 2017 4:27 PM (in response to rareddy)

Thanks for quick response Ramesh...

Much appreciated.
Actions

Go to original post