Update query by query id

PATCH {{baseUrl}}/queries/:id

Query attributes [description,ontologyId,name,sqlStatement] can only be patched. Returns Updated Data Query SQL Model.

Request Body

{"description"=>"<string>", "isBusinessQuery"=>false, "ontologyId"=>"<string>", "isDynamic"=>"<boolean>", "name"=>"<string>", "sqlStatement"=>"<base64>"}

HEADERS

KeyDatatypeRequiredDescription
Content-Typestring
Acceptstring

RESPONSES

status: OK

{&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;:false,&quot;isDynamic&quot;:false,&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;}