Sorry, this is my complete first time trying this.
I'm wanting to take a SQL query and get the results using the Compass SQL Query Platform APIs in the Infor Data Fabric set of APIs, but I keep returning no results.
I'm trying this query, for example:
select * from oeeh where enterdt = '2024-02-20'
When I run it on our datalake using DBeaver, I get results.
But when I try to use the API, I'm not seeing results (or at least, I'm not understanding).
I'm starting by going to the POST /jobs/ api and executing that SQL statement as the query body.
I'm getting the query ID back and waiting for it to show finished in the GET /status/ API.
Once finished, I'm going to the /result/ api and entering the query id. Based on what I'm seeing in DBeaver, I'm expecting results, but this is all that is returned. What am I doing wrong? Thanks!
Response headers
cache-control: no-cache,no-store,max-age=0,must-revalidate content-type: application/x-ndjson expires: 0 pragma: no-cache
