Retrieve query by query id
GET {{baseUrl}}/queries/:id
Returns a Data Query SQL Model
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Accept | string |
RESPONSES
status: OK
{"createdDate":"2019-08-08T05:55:06.119Z","description":"Analysis of vehicle accident","executable":false,"id":"5d4d0aba988cdf4baca6f3f7","isBusinessQuery":true,"isDynamic":true,"resultType":"FILE","resultDetail":{"fileType":"PARQUET","location":"/sdiresults/"},"name":"crashanalysis","ontologyId":"A065E2E5D2A36888AF88469073786B6F","pendingActions":[{"field":"sqlStatement","message":"vehicle is not mapped in ontology"},{"field":"sqlStatement","message":"vehicle is not mapped in ontology"}],"sqlStatement":"SELECT vehicle.vin, make.def FROM vehicle, make WHERE vehicle.make = make.id","updatedDate":"2019-08-09T01:45:09.105Z","lastTenExecutionJobIds":["5d4d0aba988cdf4bata6f3f7"]}