I have a scenario like below. Please suggest me on this.
I am able to connect to database for retrieving the data but I don't know which format (txt,xls,etc) it is. I am setting the variable and storing the data into this variable jdbc.xmlquery.
We have data conversion like XML to JSON and vice versa.We can use XSL transformation to transfer the data what ever the format we required.
My question here is Can we convert the data from XML to JSON thru XSLT in a single transformation.
Please suggest me on this.