Query Execution Services

Query Execution Services are used to run the query from a third-party application.

SOAP Query Execution Services

This table lists service operations used to execute a query:

Service Operation Name	Description
QAS_CANCELQUERY_OPER	Returns the status of query cancellation.
QAS_QUERYSTATUS_OPER	Returns query execution status.
QAS_EXECUTEQRYSYNC_OPER	Returns query result.
QAS_EXECUTEQRYASYNC_OPER	Returns query result.
QAS_EXECUTEQRYSYNCPOLL_OPER	Runs the query through process scheduler and returns the query instance ID. The service operation QAS_GETQUERYRESULTS_OPER is used to retrieve the results.
QAS_GETQUERYRESULTS_OPER	Used to return the query results when the query is executed on the PeopleSoft database using QAS_EXECUTEQRYSYNCPOLL_OPER.
QAS_EXECUTECPQSYNC_OPER	Returns the composite query result in a WebRowset format. This operation is useful for end users who do not have database connection information to establish ODBC connections.

RESTful Query Execution Services

This table lists service operations used to execute a query:

Service Operation Name	Description
QAS_EXECUTEQRY_REST_GET	Used to return the query result when the query is executed synchronously.
QAS_EXECUTEQRY_REST_POST	Used to return the query result in the selected format when an ad-hoc query is executed synchronously.
QAS_EXECUTEQRYPOLL_REST_GET	Runs the query through process scheduler and returns the query instance ID. The service operation QAS_GETQUERYRESULTS_REST_GET is used to retrieve the results.
QAS_EXECUTEQRYPOLL_REST_POST	Runs an ad-hoc query through process scheduler and returns the query instance ID. The service operation QAS_GETQUERYRESULTS_REST_GET is used to retrieve the results.
QAS_GETQUERYRESULTS_REST_GET	Used to return the query results when the query is executed on the PeopleSoft database using QAS_EXECUTEQRYPOLL_REST_GET.
QAS_CANCELQUERY_REST_GET	Returns the status of query cancellation.
QAS_QUERYSTATUS_REST_GET	Returns query execution status.