QAS_EXECUTEQRY_REST_POST

This service operation is for synchronously executing an ad-hoc query and receiving the query results in the format selected in the service operation request. The response message depends on whether the request was for a file or a non file format.

Example Request:

http://<servername>:<port>/PSIGW/RESTListeningConnector/<defaultlocal node>/ExecuteAdhocQuery.v1/

POST Message

<?xml version="1.0"?>
<QAS_EXEQRY_SYNC_REQ_MSG>
 	<QAS_EXEQRY_SYNC_REQ>
		<QueryName/>
		<isConnectedQuery>N</isConnectedQuery>
 		<XMLString>
		<!--1 or more repetitions:-->
	<RECORD>
		<RCDNUM>1</RCDNUM>
 		<RCDNAME>PSMSGSETDEFN</RCDNAME>
		<CORRNAME>A</CORRNAME>
		<JOINTYPE></JOINTYPE>
		<JOINRCDALIAS></JOINRCDALIAS>
		<JOINFIELD></JOINFIELD>
  		<RCDSELECTNUM>1</RCDSELECTNUM>
	</RECORD>
	<!--1 or more repetitions:-->
	<FIELD>
		<FIELDNUM>1</FIELDNUM>
 		<FIELDNAME>MESSAGE_set_nbr</FIELDNAME>
 		<FIELDRCDNUM>1</FIELDRCDNUM>
	 	<DESCR></DESCR>
		<AGGREGATE_TYPE>None</AGGREGATE_TYPE>
		<HEADING_TYPE>RFT Short</HEADING_TYPE>
 		<HEADING></HEADING>
		<COLUMNNUM>1</COLUMNNUM>
		<ORDERBYNUM>1</ORDERBYNUM>
		<ORDERBYDIR></ORDERBYDIR>
		<FIELDSELECTNUM>1</FIELDSELECTNUM>
		<EXPRESSION_AS_FIELD></EXPRESSION_AS_FIELD>
	</FIELD>
 	<FIELD>
		<FIELDNUM>2</FIELDNUM>
		<FIELDNAME>descr</FIELDNAME>
		<FIELDRCDNUM>1</FIELDRCDNUM>
		<DESCR></DESCR>
		<AGGREGATE_TYPE>None</AGGREGATE_TYPE>
		<HEADING_TYPE>RFT Short</HEADING_TYPE>
 		<HEADING></HEADING>
		<COLUMNNUM>2</COLUMNNUM>
		<ORDERBYNUM>0</ORDERBYNUM>
		<ORDERBYDIR></ORDERBYDIR>
		<FIELDSELECTNUM>1</FIELDSELECTNUM>
		<EXPRESSION_AS_FIELD></EXPRESSION_AS_FIELD>
	</FIELD>
 	<SELECT>
		<SELECTNUM>1</SELECTNUM>
		<PARENTSELECTNUM>0</PARENTSELECTNUM>
		<SELECTTYPE>Main</SELECTTYPE>
		<QRYDISTINCT></QRYDISTINCT>
	</SELECT>
 	</XMLString> 
 		<OwnerType/>
		<BlockSizeKB>0</BlockSizeKB>
		<MaxRow>1000</MaxRow>
		<OutResultType>XMLP</OutResultType>
		<OutResultFormat>NONFILE</OutResultFormat>
		<Prompts/>
	 </QAS_EXEQRY_SYNC_REQ>
</QAS_EXEQRY_SYNC_REQ_MSG>

Example Response:

<?xml version="1.0"?>
<QAS_GETQUERYRESULTS_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/
Tools/schemas/QAS_GETQUERYRESULTS_RESP_MSG.VERSION_1">
    <query numrows="10" queryname="" xmlns="http://xmlns.oracle.com/
     Enterprise/Tools/schemas/QAS_QUERYRESULTS_XMLP_RESP.VERSION_1">
        <row rownumber="1">
            <MESSAGE_SET_NBR>1</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[PeopleTools Message Bar Items]]>
            </DESCR>
        </row>
        <row rownumber="2">
            <MESSAGE_SET_NBR>2</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[PeopleCode]]>
            </DESCR>
        </row>
        <row rownumber="3">
            <MESSAGE_SET_NBR>3</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[General Tools Messages]]>
            </DESCR>
        </row>
        <row rownumber="4">
            <MESSAGE_SET_NBR>4</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[Help Processor]]>
            </DESCR>
        </row>
        <row rownumber="5">
            <MESSAGE_SET_NBR>5</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[Help Text Manager]]>
            </DESCR>
        </row>
        <row rownumber="6">
            <MESSAGE_SET_NBR>6</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[Import Definition Manager]]>
            </DESCR>
        </row>
        <row rownumber="7">
            <MESSAGE_SET_NBR>7</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[Open Query API]]>
            </DESCR>
        </row>
        <row rownumber="8">
            <MESSAGE_SET_NBR>8</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[PeopleCode Editor]]>
            </DESCR>
        </row>
        <row rownumber="9">
            <MESSAGE_SET_NBR>9</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[Menu Definition Manager]]>
            </DESCR>
        </row>
        <row rownumber="10">
            <MESSAGE_SET_NBR>10</MESSAGE_SET_NBR>
            <DESCR>
                <![CDATA[Change Control]]>
            </DESCR>
        </row>
    </query>
</QAS_GETQUERYRESULTS_RESP_MSG>