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, "skipSchemaValidations"=>false, "resultType"=>"<string>", "resultDetail"=>{"fileType"=>"PARQUET", "location"=>"/sdiresults/"}}

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;skipSchemaValidations&quot;:false,&quot;resultType&quot;:&quot;FILE&quot;,&quot;resultDetail&quot;:{&quot;fileType&quot;:&quot;PARQUET&quot;,&quot;location&quot;:&quot;/sdiresults/&quot;},&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;}