Hi Bernad, In your query change the following, both the element name and the row names are same therefore it throws the error message, change the name element and row names to have different values. Then you can make request with header as xml or json. JSON mapping is not required.
<result element="Employees" rowName="Employees"> eg: <result element="Employees" rowName="Employee"> Best regards. On Thu, Oct 25, 2018 at 2:47 PM Sangeeth Karunaratne <[email protected]> wrote: > Hi Bernad, > > Yes , first write the output mapping in JSON and then you can receive the > response in either xml or in json based on the Accept header value. > > Best regards. > > On Thu, Oct 25, 2018 at 2:39 PM Bernard Paris <[email protected]> > wrote: > >> Hello, >> >> the response is formatted JSON or XML depending on the incoming Accept >> header value. So the DSS XML datas should be transformed to JSON when JSON >> is requested. >> >> Do you mean we'd better do the opposite: have JSON format first from DSS >> then convert to XML if needed ? >> >> Bernard >> >> >> Le 25 oct. 2018 à 10:33, Sangeeth Karunaratne <[email protected]> a >> écrit : >> >> Hi Bernad, >> >> Its seems that you have generated the response for your SQL query with >> output type as XML and trying to receive a response in JSON format. >> Please refer this documentation for mapping the output in JSON format. >> >> https://docs.wso2.com/display/EI640/Using+JSON+with+Data+Services >> >> On Tue, Oct 16, 2018 at 3:36 PM Bernard Paris <[email protected]> >> wrote: >> >>> Hi devs, >>> >>> we are facing this issue with IE6.3.0 >>> https://github.com/wso2/product-ei/issues/2523 >>> >>> Is there any workaround or fix ? Is this issue present in newer 6.4.0 >>> version ? >>> >>> Many thanks, >>> regards >>> >>> Bernard >>> https://www.uclouvain.be >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >> >> Best regards. >> -- >> *Sangeeth Karunaratne* >> Software Engineering Intern | WSO2 Inc. >> >> Email: [email protected] >> Mobile: +94767031534 >> Web: http://wso2.com >> >> >> >> >> > > -- > *Sangeeth Karunaratne* > Software Engineering Intern | WSO2 Inc. > > Email: [email protected] > Mobile: +94767031534 > Web: http://wso2.com > > > > -- *Sangeeth Karunaratne* Software Engineering Intern | WSO2 Inc. Email: [email protected] Mobile: +94767031534 Web: http://wso2.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
