Skip to main content

DELETE

POST

The DELETE statement is used to delete one or multiple documents based on the WHERE clause..

DELETE statement syntax

DELETE [collection_name] 
WHERE [$where:dict, a=b, ...];

Query Example

{
  "query": "DELETE articles WHERE $where",
  "variables": {
    "where": {
      "location:$in": ["NY", "NC"]
    }
  }
}

Request​

Body

    query stringrequired

    The X-SQL Query string

    variables objectrequired

    The variables

Responses​

Archive or Delete response

Schema
    data object
    _ref string

    The reference ID to be used to restore archived or deleted documents

Loading...