Format of the request and response without adapter action
You can use this option to execute a specified SQL query against the Tivoli Netcool/OMNIbus database. The following table describes the request elements for the actor adapter without adapter action.
Elements for actor adapter request without adapter action
The following figure shows a template for an actor adapter request without adapter action.
XML template for an actor adapter request without adapter action
<OMNIbusAdapterRequest>
<action></action>
</OMNIbusAdapterRequest>
The following figure shows a sample actor adapter request without adapter action. Use the adapter request XML when you create a custom process by using the Call Adapter activity in TrueSight Orchestration Development Studio.
XML sample of an actor adapter request without adapter action
<OMNIbusAdapterRequest>
<action>select * from foo</action>
</OMNIbusAdapterRequest>
The Tivoli Netcool/OMNIbus actor adapter returns an adapter response that contains the results from the SQL query defined in the adapter request.
The following table describes the elements of the Tivoli Netcool/OMNIbus actor adapter response to a request without adapter action.
Elements of the Tivoli Netcool/OMNIbus actor adapter response to a request without adapter action
The following figure illustrates an XML template for an actor adapter response to a request without adapter action.
XML template for an actor adapter response to a request without action
<omnibus-response>
<row>
<column name="Serial">numeric value</column>
</row>
<metadata>
<queryExecuted>select * from foo</queryExecuted>
<execution-milliseconds>numeric value</execution-milliseconds>
<responseRowCount>1</responseRowCount>
<responseColumnCount>1</responseColumnCount>
<status>sucess</status>
<error>present only with status of 'error'</error>
</metadata>
</omnibus-response>