Deleting dataΒΆ

The request to delete data takes a where clause indicating what to delete. The syntax of where clause is same as in the select query.

The full syntax of a delete query can be found here.

GraphQL
JSON API
mutation delete_article {
  delete_article (where: {rating: {_lte: 1}}) {
      affected_rows
  }
}

POST /v1/query HTTP/1.1
Content-Type: application/json
Authorization: Bearer <auth-token> # optional if cookie is set
X-Hasura-Role: <role>  # optional. Pass if only specific user role has access

{
    "type" : "delete",
    "args" : {
        "table" : "article",
        "where": {
           "rating": { "$lte" : 1 }
        }
    }
}
« previous | next »
Want to contribute or report missing content? Check out the github repo for docs.
Powered by Sphinx. Copyright © 2019 Hasura.