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
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"createdDate":"2019-08-08T05:55:06.119Z","description":"Analysis of vehicle accident","executable":false,"id":"5d4d0aba988cdf4baca6f3f7","isBusinessQuery":false,"isDynamic":false,"skipSchemaValidations":false,"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"}