I am trying use SQL as a Webservice in IWS and i am simply configuring a
basic Select SQL statement which have two result fields as shown below
"Select name,number from student"
After deploying the service and try executing using the Postman tool, i am
getting response as below
{
"sql_Student_R": [
{
"NAME": "STEVE",
"NUMBER": "131313"
},
{
"NAME": "JOHN",
"NUMBER": "121212"
}
]
}
I want to convert the result to be in below format
[
{
"NAME": "STEVE",
"NUMBER": "131313"
},
{
"NAME": "JOHN",
"NUMBER": "121212"
}
]
Do we have any configuration to say do not wrap the result?
I already tried making the Wrap Output Parameter as "false" but no luck.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.