When data has been published to Infor's Datalake from Infor or non-Infor applications we can access this data from the newly provided Compass API via ION APIs as follows:
Find the datalakeapi API & click Documentation:
The API methods exposed are:
We will use the POST / jobs API to submit our query, then GET /jobs/status to see if the query has completed and finally GET /jobs/result to get the result of the query.
This returns a query ID that we can use to obtain the status of our query and eventually get the result of the query:
Querying the status of the compass API call via GET /jobs/status:
As the status is FINISHED we can now request the result of the query by calling GET /jobs/result:
So the result of the query (select count(*) from MITBAL) against our data in Datalake is 22,624 records.
We can then leverage this capability through external tools like Powershell as described here.