Run SQL Query - return results in Response

Mirth 3.0.3.7171 - Windows



I have an external app that connects to a Mirth channel via HTTP request - it passed a NHI Number to the channel - the channel then performs an SQL query against a database and returns the results - so far so good



However I want to return the results to the original system that sent the query to Mirth



I cannot get that part to work



See attached channel - I do not see any output for the logger.info statements in Destination Response Transformer



It looks like the Response Transformer never gets executed - is that because the Destination is DB Writer



If thats the case how do I do it ?



Cheers,

Bill

Attached Files

NDHB_NHI_Query.xml (16.7 KB)

Run SQL Query - return results in Response