API Flows - How to use values from Request Body service DataLakeCompass (DATAFABRIC/compass/v2/jobs/

manaus

If need to use the DATAFABRIC/compass/v2/jobs/ service in an API flow but are unable to add a query to the request body, do you have any suggestions on how to proceed?

*** Content Type : text/plain

robert-nevinger

If it the query you are after, use Compass to generate it.  Navigate to DataFabric -> Datalake -> Compass

Search for an object e.g. HCM_Employee,

You can generate SQL for the Object, or Object Properties, just select the ellipses to the right, then Generate the SQL you need  

SELECT
  "HCM_Employee"."Employee"
FROM
  "HCM_Employee"

You can cut & paste the SQL into your API flow, ION API swagger, IPA, Postman etc.

Keep in mind that a Datafabric API is asynchronous, so the jobs end point returns a queryid, not the data,  A status & result end point will also be needed.