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

KeyDatatypeRequiredDescription
Content-Typestring
Acceptstring

RESPONSES

status: Created

{&quot;createdDate&quot;:&quot;2019-08-08T05:55:06.119Z&quot;,&quot;description&quot;:&quot;Analysis of vehicle accident&quot;,&quot;executable&quot;:false,&quot;id&quot;:&quot;5d4d0aba988cdf4baca6f3f7&quot;,&quot;isBusinessQuery&quot;:true,&quot;isDynamic&quot;:true,&quot;name&quot;:&quot;crashanalysis&quot;,&quot;ontologyId&quot;:&quot;A065E2E5D2A36888AF88469073786B6F&quot;,&quot;pendingActions&quot;:[{&quot;field&quot;:&quot;sqlStatement&quot;,&quot;message&quot;:&quot;vehicle is not mapped in ontology&quot;},{&quot;field&quot;:&quot;sqlStatement&quot;,&quot;message&quot;:&quot;vehicle is not mapped in ontology&quot;}],&quot;sqlStatement&quot;:&quot;SELECT vehicle.vin, make.def FROM vehicle, make WHERE vehicle.make = make.id&quot;,&quot;updatedDate&quot;:&quot;2019-08-09T01:45:09.105Z&quot;}