[ https://issues.jboss.org/browse/TEIIDDES-1882?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-1882: ---------------------------------------- +100 for the feature. Actually I was helping somebody today with the very use case, once the https://issues.jboss.org/browse/TEIIDDES-1829 correctly resolved, then the using the JSONTOXML is pretty straight forward, all it would require couple extra things * When JSON data is read, automatically convert it to XML, so that XML wizards can be used as is * In result transformation, use the JSONTOXML function as shown in example below. ex: {code} CREATE VIRTUAL PROCEDURE BEGIN SELECT now.id AS id FROM (EXEC csdyn.invokeHttp('GET', null, 'http://api.tvbuzz.nl/api/2.0/nl_NL/column/now/trending', 'TRUE')) AS f, XMLTABLE('/foo/data/now' PASSING JSONTOXML('foo', f.result) COLUMNS id integer PATH 'id') AS now; END {code} -- This message was sent by Atlassian JIRA (v6.2.6#6264)