Added a JDBC Node in App Connect Designer and can execute a query (SELECT) but it doesn't appear there is a way to map the actual output of the query to a REST response (for example).  All I can see in the response node is "Data" or $JDBCCustomQuery.Data but there are no child fields of Data that I can reference in the response node.  Am I missing something?  Is there a step by step for this because the docs don't cover it.

And I can do this in Toolkit, just trying to see how it works in Designer.

Hi Dave,

The output of the custom query will be a json which is included as part of the JDBCCustomQuery.Data . You will need to add a JSON Parser node after the JDBC node and parse the output. 

You can use the  "test node" feature to look at a sample response and use that to generate the required schema for your JSON Parser node.