Create new queries
POST {{baseUrl}}/queries
Returns id of created query
Request Body
{"sqlStatement"=>"<base64>", "name"=>"<string>", "description"=>"<string>", "isBusinessQuery"=>false, "ontologyId"=>"<string>", "isDynamic"=>false}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string | ||
Accept | string |
RESPONSES
status: Created
{"createdDate":"2019-08-08T05:55:06.119Z","description":"Analysis of vehicle accident","executable":false,"id":"5d4d0aba988cdf4baca6f3f7","isBusinessQuery":true,"isDynamic":true,"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"}