Infor API | Compass V2

Infor API | Compass V2

## Sections
• [Compass SQL Query Platform](https://developer.infor.com/compass-v2/compass-sql-query-platform.md): 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
• [General](https://developer.infor.com/compass-v2/general.md): General services
  • [Ping call for the Compass API](https://developer.infor.com/compass-v2/general/ping-call-for-the-compass-api.md): 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.
• [Jobs](https://developer.infor.com/compass-v2/jobs.md): Submit and interact with Compass Jobs
  • [Submits a Compass SQL job request.](https://developer.infor.com/compass-v2/jobs/submits-a-compass-sql-job-request.md): 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.
  • [Cancels running SQL query.](https://developer.infor.com/compass-v2/jobs/cancels-running-sql-query.md): 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.
  • [Get the result for a queryId that was provided from a Compass job.](https://developer.infor.com/compass-v2/jobs/get-the-result-for-a-queryid-that-was-provided-from-a-compass-job.md): 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.
  • [Check the status of a queryId provided by the executed Compass job.](https://developer.infor.com/compass-v2/jobs/check-the-status-of-a-queryid-provided-by-the-executed-compass-job.md): 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.