infor

Compass SQL query platform (version 2).

The Compass API allows you to retrieve and interact data that has been stored in the Infor Datalake via SQL query.

This API is broken up into two parts:

* • General
* • Jobs

The Jobs API contains the endpoints that allow you execute Compass queries. The General API contains only one endpoint, _ping_, which allows you to check the availability of the Compass services. The general workflow for executing a Compass query is as follows:

* • Submit a query
* • Periodically check on the status of the query until it has completed or been canceled
* • Retrieve the query results


Compass SQL Query Platform

General

Checks the availability of the Compass service provided by the _queryExecutor_.
Note that the body of the response is irrelevant.  Any other HTTP status code response other than 200,
which could be from an intermediate load balancer or other component, indicates an inability
to successfully call the service.


Ping call for the Compass API

Jobs

Submit a Compass query as an asynchronous job.

A successful response will include a queryId. The supplied queryId can then be used to cancel the query, check the status of the query, and retrieve the results of the query once the query has completed executing.


Submits a Compass SQL job request.

Cancel a query using the queryId that was provided when submitting a Compass job.

An OK response status, HTTP 200, indicates a successful cancel request. Note that calling cancel on a completed/failed query will have no effect.



Cancels running SQL query.

Retrieve the query results using the queryId that was provided when submitting the a query.

Use this API after the Compass Status API indicates that the query has finished successfully, failed, or has been cancelled.
A query that finished successfully returns the query results, and a query that fails or was cancelled displays an error message.


Get the result for a queryId that was provided from a Compass job.

Check the status of a query using the queryId that was provided when submitting a Compass job.

The response indicates the current query status. Possible values for "status" property in the response:

* • RUNNING - indicates that the query is executing.
* • FINISHED - indicates that the query completed successfully. Use the GET result API call to retrieve the results.
* • FAILED - indicates that the query is finished and ended in error. Use the GET result API call to retrieve the error details.
* • CANCELED - indicates that the query has been canceled.


Sections