ArangoDB v3.4 reached End of Life (EOL) and is no longer supported.

This documentation is outdated. Please see the most recent version here: Latest Docs

Working with Documents using REST

Read document

reads a single document

GET /_api/document/{document-handle}

Path Parameters

  • document-handle (string, required): The handle of the document.

Header Parameters

  • If-None-Match (string, optional): If the “If-None-Match” header is given, then it must contain exactly one Etag. The document is returned, if it has a different revision than the given Etag. Otherwise an HTTP 304 is returned.

  • If-Match (string, optional): If the “If-Match” header is given, then it must contain exactly one Etag. The document is returned, if it has the same revision as the given Etag. Otherwise a HTTP 412 is returned.

Returns the document identified by document-handle. The returned document contains three special attributes: _id containing the document handle, _key containing key which uniquely identifies a document in a given collection and _rev containing the revision.

Responses

HTTP 200: is returned if the document was found

HTTP 304: is returned if the “If-None-Match” header is given and the document has the same version

HTTP 404: is returned if the document or collection was not found

HTTP 412: is returned if an “If-Match” header is given and the found document has a different version. The response will also contain the found document’s current revision in the _rev attribute. Additionally, the attributes _id and _key will be returned.

Examples

Use a document handle:

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69247

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRH5a---"
x-content-type-options: nosniff
Show response body

Use a document handle and an Etag:

shell> curl --header 'If-None-Match: "_bHcRH8O---"' --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69296

Unknown document handle:

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/unknownhandle

HTTP/1.1 Not Found
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

The rev query parameter has been withdrawn. The same effect can be achieved with the If-Match HTTP header.

Read document header

reads a single document head

HEAD /_api/document/{document-handle}

Path Parameters

  • document-handle (string, required): The handle of the document.

Header Parameters

  • If-None-Match (string, optional): If the “If-None-Match” header is given, then it must contain exactly one Etag. If the current document revision is not equal to the specified Etag, an HTTP 200 response is returned. If the current document revision is identical to the specified Etag, then an HTTP 304 is returned.

  • If-Match (string, optional): If the “If-Match” header is given, then it must contain exactly one Etag. The document is returned, if it has the same revision as the given Etag. Otherwise a HTTP 412 is returned.

Like GET, but only returns the header fields and not the body. You can use this call to get the current revision of a document or check if the document was deleted.

Responses

HTTP 200: is returned if the document was found

HTTP 304: is returned if the “If-None-Match” header is given and the document has the same version

HTTP 404: is returned if the document or collection was not found

HTTP 412: is returned if an “If-Match” header is given and the found document has a different version. The response will also contain the found document’s current revision in the Etag header.

Examples

shell> curl -X HEAD --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69286

Changes in 3.0 from 2.8:

The rev query parameter has been withdrawn. The same effect can be achieved with the If-Match HTTP header.

Read all documents

reads all documents from collection

PUT /_api/simple/all-keys

This route should no longer be used. All endpoints for Simple Queries are deprecated from version 3.4.0 on. They are superseded by AQL queries.

Query Parameters

  • collection (string, optional): The name of the collection. This parameter is only for an easier migration path from old versions. In ArangoDB versions < 3.0, the URL path was /_api/document and this was passed in via the query parameter “collection”. This combination was removed. The collection name can be passed to /_api/simple/all-keys as body parameter (preferred) or as query parameter.

Request Body

  • collection (string, required): The collection that should be queried

  • type (string, optional): The type of the result. The following values are allowed:

    • id: returns an array of document ids (_id attributes)
    • key: returns an array of document keys (_key attributes)
    • path: returns an array of document URI paths. This is the default.

Returns an array of all keys, ids, or URI paths for all documents in the collection identified by collection. The type of the result array is determined by the type attribute.

Note that the results have no defined order and thus the order should not be relied on.

Note: the all-keys simple query is deprecated as of ArangoDB 3.4.0. This API may get removed in future versions of ArangoDB. You can use the /_api/cursor endpoint instead with one of the below AQL queries depending on the desired result:

  • FOR doc IN @@collection RETURN doc._id to mimic type: id
  • FOR doc IN @@collection RETURN doc._key to mimic type: key
  • FOR doc IN @@collection RETURN CONCAT("/_db/", CURRENT_DATABASE(), "/_api/document/", doc._id) to mimic type: path

Responses

HTTP 201: All went well.

HTTP 404: The collection does not exist.

Examples

Return all document paths

shell> curl -X PUT --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/simple/all-keys <<EOF
{ 
  "collection" : "products" 
}
EOF

HTTP/1.1 Created
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Return all document keys

shell> curl -X PUT --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/simple/all-keys <<EOF
{ 
  "collection" : "products", 
  "type" : "id" 
}
EOF

HTTP/1.1 Created
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Collection does not exist

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/doesnotexist

HTTP/1.1 Not Found
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

The collection name should now be specified in the URL path. The old way with the URL path /_api/document and the required query parameter collection still works.

Create document

creates documents

POST /_api/document/{collection}

Path Parameters

  • collection (string, required): The collection in which the collection is to be created.

Query Parameters

  • collection (string, optional): The name of the collection. This is only for backward compatibility. In ArangoDB versions < 3.0, the URL path was /_api/document and this query parameter was required. This combination still works, but the recommended way is to specify the collection in the URL path.

  • waitForSync (boolean, optional): Wait until document has been synced to disk.

  • returnNew (boolean, optional): Additionally return the complete new document under the attribute new in the result.

  • returnOld (boolean, optional): Additionally return the complete old document under the attribute old in the result. Only available if the overwrite option is used.

  • silent (boolean, optional): If set to true, an empty object will be returned as response. No meta-data will be returned for the created document. This option can be used to save some network traffic.

  • overwrite (boolean, optional): If set to true, the insert becomes a replace-insert. If a document with the same _key already exists the new document is not rejected with unique constraint violated but will replace the old document.

Request Body

(json, required)

A JSON representation of a single document or of an array of documents.

Creates a new document from the document given in the body, unless there is already a document with the _key given. If no _key is given, a new unique _key is generated automatically.

The body can be an array of documents, in which case all documents in the array are inserted with the same semantics as for a single document. The result body will contain a JSON array of the same length as the input array, and each entry contains the result of the operation for the corresponding input. In case of an error the entry is a document with attributes error set to true and errorCode set to the error code that has happened.

Possibly given _id and _rev attributes in the body are always ignored, the URL part or the query parameter collection respectively counts.

If the document was created successfully, then the Location header contains the path to the newly created document. The Etag header field contains the revision of the document. Both are only set in the single document case.

If silent is not set to true, the body of the response contains a JSON object (single document case) with the following attributes:

  • _id contains the document handle of the newly created document
  • _key contains the document key
  • _rev contains the document revision

In the multi case the body is an array of such objects.

If the collection parameter waitForSync is false, then the call returns as soon as the document has been accepted. It will not wait until the documents have been synced to disk.

Optionally, the query parameter waitForSync can be used to force synchronization of the document creation operation to disk even in case that the waitForSync flag had been disabled for the entire collection. Thus, the waitForSync query parameter can be used to force synchronization of just this specific operations. To use this, set the waitForSync parameter to true. If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

If the query parameter returnNew is true, then, for each generated document, the complete new document is returned under the new attribute in the result.

Responses

HTTP 201: is returned if the documents were created successfully and waitForSync was true.

HTTP 202: is returned if the documents were created successfully and waitForSync was false.

HTTP 400: is returned if the body does not contain a valid JSON representation of one document or an array of documents. The response body contains an error document in this case.

HTTP 404: is returned if the collection specified by collection is unknown. The response body contains an error document in this case.

HTTP 409: is returned in the single document case if a document with the same qualifiers in an indexed attribute conflicts with an already existing document and thus violates that unique constraint. The response body contains an error document in this case. In the array case only 201 or 202 is returned, but if an error occurred, the additional HTTP header X-Arango-Error-Codes is set, which contains a map of the error codes that occurred together with their multiplicities, as in: 1205:10,1210:17 which means that in 10 cases the error 1205 “illegal document handle” and in 17 cases the error 1210 “unique constraint violated” has happened.

Examples

Create a document in a collection named products. Note that the revision identifier might or might not by equal to the auto-generated key.

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products <<EOF
{ "Hello": "World" }
EOF

HTTP/1.1 Created
content-type: application/json; charset=utf-8
etag: "_bHcRH1S---"
location: /_db/_system/_api/document/products/69198
x-content-type-options: nosniff
Show response body

Create a document in a collection named products with a collection-level waitForSync value of false.

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products <<EOF
{ "Hello": "World" }
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRH0S---"
location: /_db/_system/_api/document/products/69182
x-content-type-options: nosniff
Show response body

Create a document in a collection with a collection-level waitForSync value of false, but using the waitForSync query parameter.

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products?waitForSync=true <<EOF
{ "Hello": "World" }
EOF

HTTP/1.1 Created
content-type: application/json; charset=utf-8
etag: "_bHcRH4q---"
location: /_db/_system/_api/document/products/69238
x-content-type-options: nosniff
Show response body

Unknown collection name

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products <<EOF
{ "Hello": "World" }
EOF

HTTP/1.1 Not Found
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Illegal document

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products <<EOF
{ 1: "World" }
EOF

HTTP/1.1 Bad Request
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Insert multiple documents:

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products <<EOF
[{"Hello":"Earth"}, {"Hello":"Venus"}, {"Hello":"Mars"}]
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
x-content-type-options: nosniff

[ 
  { 
    "_id" : "products/69207", 
    "_key" : "69207", 
    "_rev" : "_bHcRH2C--_" 
  }, 
  { 
    "_id" : "products/69208", 
    "_key" : "69208", 
    "_rev" : "_bHcRH2C--B" 
  }, 
  { 
    "_id" : "products/69209", 
    "_key" : "69209", 
    "_rev" : "_bHcRH2C--D" 
  } 
]

Use of returnNew:

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products?returnNew=true <<EOF
{"Hello":"World"}
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRH2m---"
location: /_db/_system/_api/document/products/69218
x-content-type-options: nosniff
Show response body
shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products <<EOF
{ "Hello": "World", "_key" : "lock" }
EOF

HTTP/1.1 Created
content-type: application/json; charset=utf-8
etag: "_bHcRH3G---"
location: /_db/_system/_api/document/products/lock
x-content-type-options: nosniff

shell> curl -X POST --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products?overwrite=true <<EOF
{ "Hello": "Universe", "_key" : "lock" }
EOF

HTTP/1.1 Created
content-type: application/json; charset=utf-8
etag: "_bHcRH3e--A"
location: /_db/_system/_api/document/products/lock
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

The collection name should now be specified in the URL path. The old way with the URL path /_api/document and the required query parameter collection still works. The possibility to insert multiple documents with one operation is new and the query parameter returnNew has been added.

Replace document

replaces a document

PUT /_api/document/{document-handle}

Path Parameters

  • document-handle (string, required): This URL parameter must be a document handle.

Query Parameters

  • waitForSync (boolean, optional): Wait until document has been synced to disk.

  • ignoreRevs (boolean, optional): By default, or if this is set to true, the _rev attributes in the given document is ignored. If this is set to false, then the _rev attribute given in the body document is taken as a precondition. The document is only replaced if the current revision is the one specified.

  • returnOld (boolean, optional): Return additionally the complete previous revision of the changed document under the attribute old in the result.

  • returnNew (boolean, optional): Return additionally the complete new document under the attribute new in the result.

  • silent (boolean, optional): If set to true, an empty object will be returned as response. No meta-data will be returned for the replaced document. This option can be used to save some network traffic.

Header Parameters

  • If-Match (string, optional): You can conditionally replace a document based on a target revision id by using the if-match HTTP header.

Request Body

(json, required)

A JSON representation of a single document.

Replaces the document with handle with the one in the body, provided there is such a document and no precondition is violated.

If the If-Match header is specified and the revision of the document in the database is unequal to the given revision, the precondition is violated.

If If-Match is not given and ignoreRevs is false and there is a _rev attribute in the body and its value does not match the revision of the document in the database, the precondition is violated.

If a precondition is violated, an HTTP 412 is returned.

If the document exists and can be updated, then an HTTP 201 or an HTTP 202 is returned (depending on waitForSync, see below), the Etag header field contains the new revision of the document and the Location header contains a complete URL under which the document can be queried.

Optionally, the query parameter waitForSync can be used to force synchronization of the document replacement operation to disk even in case that the waitForSync flag had been disabled for the entire collection. Thus, the waitForSync query parameter can be used to force synchronization of just specific operations. To use this, set the waitForSync parameter to true. If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

If silent is not set to true, the body of the response contains a JSON object with the information about the handle and the revision. The attribute _id contains the known document-handle of the updated document, _key contains the key which uniquely identifies a document in a given collection, and the attribute _rev contains the new document revision.

If the query parameter returnOld is true, then the complete previous revision of the document is returned under the old attribute in the result.

If the query parameter returnNew is true, then the complete new document is returned under the new attribute in the result.

If the document does not exist, then a HTTP 404 is returned and the body of the response contains an error document.

Responses

HTTP 201: is returned if the document was replaced successfully and waitForSync was true.

HTTP 202: is returned if the document was replaced successfully and waitForSync was false.

HTTP 400: is returned if the body does not contain a valid JSON representation of a document. The response body contains an error document in this case.

HTTP 404: is returned if the collection or the document was not found.

HTTP 412: is returned if the precondition was violated. The response will also contain the found documents’ current revisions in the _rev attributes. Additionally, the attributes _id and _key will be returned.

Examples

Using a document handle

shell> curl -X PUT --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69308 <<EOF
{"Hello": "you"}
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRH9---_"
location: /_db/_system/_api/document/products/69308
x-content-type-options: nosniff
Show response body

Unknown document handle

shell> curl -X PUT --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69330 <<EOF
{}
EOF

HTTP/1.1 Not Found
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Produce a revision conflict

shell> curl -X PUT --header 'If-Match: "_bHcRH9e---"' --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69318 <<EOF
{"other":"content"}
EOF

HTTP/1.1 Precondition Failed
content-type: application/json; charset=utf-8
etag: "_bHcRH9a--A"
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

There are quite some changes in this in comparison to Version 2.8, but few break existing usage:

  • the rev query parameter is gone (was duplication of If-Match)
  • the policy query parameter is gone (was non-sensical)
  • the ignoreRevs query parameter is new, the default true gives the traditional behavior as in 2.8
  • the returnNew and returnOld query parameters are new

There should be very few changes to behavior happening in real-world situations or drivers. Essentially, one has to replace usage of the rev query parameter by usage of the If-Match header. The non-sensical combination of If-Match given and policy=last no longer works, but can easily be achieved by leaving out the If-Match header.

The collection name should now be specified in the URL path. The old way with the URL path /_api/document and the required query parameter collection still works.

Replace documents

replaces multiple documents

PUT /_api/document/{collection}

Path Parameters

  • collection (string, required): This URL parameter is the name of the collection in which the documents are replaced.

Query Parameters

  • waitForSync (boolean, optional): Wait until the new documents have been synced to disk.

  • ignoreRevs (boolean, optional): By default, or if this is set to true, the _rev attributes in the given documents are ignored. If this is set to false, then any _rev attribute given in a body document is taken as a precondition. The document is only replaced if the current revision is the one specified.

  • returnOld (boolean, optional): Return additionally the complete previous revision of the changed documents under the attribute old in the result.

  • returnNew (boolean, optional): Return additionally the complete new documents under the attribute new in the result.

Request Body

(json, required)

A JSON representation of an array of documents.

Replaces multiple documents in the specified collection with the ones in the body, the replaced documents are specified by the _key attributes in the body documents.

If ignoreRevs is false and there is a _rev attribute in a document in the body and its value does not match the revision of the corresponding document in the database, the precondition is violated.

If the document exists and can be updated, then an HTTP 201 or an HTTP 202 is returned (depending on waitForSync, see below).

Optionally, the query parameter waitForSync can be used to force synchronization of the document replacement operation to disk even in case that the waitForSync flag had been disabled for the entire collection. Thus, the waitForSync query parameter can be used to force synchronization of just specific operations. To use this, set the waitForSync parameter to true. If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

The body of the response contains a JSON array of the same length as the input array with the information about the handle and the revision of the replaced documents. In each entry, the attribute _id contains the known document-handle of each updated document, _key contains the key which uniquely identifies a document in a given collection, and the attribute _rev contains the new document revision. In case of an error or violated precondition, an error object with the attribute error set to true and the attribute errorCode set to the error code is built.

If the query parameter returnOld is true, then, for each generated document, the complete previous revision of the document is returned under the old attribute in the result.

If the query parameter returnNew is true, then, for each generated document, the complete new document is returned under the new attribute in the result.

Note that if any precondition is violated or an error occurred with some of the documents, the return code is still 201 or 202, but the additional HTTP header X-Arango-Error-Codes is set, which contains a map of the error codes that occurred together with their multiplicities, as in: 1200:17,1205:10 which means that in 17 cases the error 1200 “revision conflict” and in 10 cases the error 1205 “illegal document handle” has happened.

Responses

HTTP 201: is returned if the documents were replaced successfully and waitForSync was true.

HTTP 202: is returned if the documents were replaced successfully and waitForSync was false.

HTTP 400: is returned if the body does not contain a valid JSON representation of an array of documents. The response body contains an error document in this case.

HTTP 404: is returned if the collection was not found.

Changes in 3.0 from 2.8:

The multi document version is new in 3.0.

Update document

updates a document

PATCH /_api/document/{document-handle}

Path Parameters

  • document-handle (string, required): This URL parameter must be a document handle.

Query Parameters

  • keepNull (boolean, optional): If the intention is to delete existing attributes with the patch command, the URL query parameter keepNull can be used with a value of false. This will modify the behavior of the patch command to remove any attributes from the existing document that are contained in the patch document with an attribute value of null.

  • mergeObjects (boolean, optional): Controls whether objects (not arrays) will be merged if present in both the existing and the patch document. If set to false, the value in the patch document will overwrite the existing document’s value. If set to true, objects will be merged. The default is true.

  • waitForSync (boolean, optional): Wait until document has been synced to disk.

  • ignoreRevs (boolean, optional): By default, or if this is set to true, the _rev attributes in the given document is ignored. If this is set to false, then the _rev attribute given in the body document is taken as a precondition. The document is only updated if the current revision is the one specified.

  • returnOld (boolean, optional): Return additionally the complete previous revision of the changed document under the attribute old in the result.

  • returnNew (boolean, optional): Return additionally the complete new document under the attribute new in the result.

  • silent (boolean, optional): If set to true, an empty object will be returned as response. No meta-data will be returned for the updated document. This option can be used to save some network traffic.

Header Parameters

  • If-Match (string, optional): You can conditionally update a document based on a target revision id by using the if-match HTTP header.

Request Body

(json, required)

A JSON representation of a document update as an object.

Partially updates the document identified by document-handle. The body of the request must contain a JSON document with the attributes to patch (the patch document). All attributes from the patch document will be added to the existing document if they do not yet exist, and overwritten in the existing document if they do exist there.

Setting an attribute value to null in the patch document will cause a value of null to be saved for the attribute by default.

If the If-Match header is specified and the revision of the document in the database is unequal to the given revision, the precondition is violated.

If If-Match is not given and ignoreRevs is false and there is a _rev attribute in the body and its value does not match the revision of the document in the database, the precondition is violated.

If a precondition is violated, an HTTP 412 is returned.

If the document exists and can be updated, then an HTTP 201 or an HTTP 202 is returned (depending on waitForSync, see below), the Etag header field contains the new revision of the document (in double quotes) and the Location header contains a complete URL under which the document can be queried.

Optionally, the query parameter waitForSync can be used to force synchronization of the updated document operation to disk even in case that the waitForSync flag had been disabled for the entire collection. Thus, the waitForSync query parameter can be used to force synchronization of just specific operations. To use this, set the waitForSync parameter to true. If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

If silent is not set to true, the body of the response contains a JSON object with the information about the handle and the revision. The attribute _id contains the known document-handle of the updated document, _key contains the key which uniquely identifies a document in a given collection, and the attribute _rev contains the new document revision.

If the query parameter returnOld is true, then the complete previous revision of the document is returned under the old attribute in the result.

If the query parameter returnNew is true, then the complete new document is returned under the new attribute in the result.

If the document does not exist, then a HTTP 404 is returned and the body of the response contains an error document.

Responses

HTTP 201: is returned if the document was updated successfully and waitForSync was true.

HTTP 202: is returned if the document was updated successfully and waitForSync was false.

HTTP 400: is returned if the body does not contain a valid JSON representation of a document. The response body contains an error document in this case.

HTTP 404: is returned if the collection or the document was not found.

HTTP 412: is returned if the precondition was violated. The response will also contain the found documents’ current revisions in the _rev attributes. Additionally, the attributes _id and _key will be returned.

Examples

Patches an existing document with new content.

shell> curl -X PATCH --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69154 <<EOF
{ 
  "hello" : "world" 
}
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRHx2--_"
location: /_db/_system/_api/document/products/69154
x-content-type-options: nosniff

shell> curl -X PATCH --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69154 <<EOF
{ 
  "numbers" : { 
    "one" : 1, 
    "two" : 2, 
    "three" : 3, 
    "empty" : null 
  } 
}
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRHyG--_"
location: /_db/_system/_api/document/products/69154
x-content-type-options: nosniff

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69154

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHyG--_"
x-content-type-options: nosniff

shell> curl -X PATCH --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69154?keepNull=false <<EOF
{ 
  "hello" : null, 
  "numbers" : { 
    "four" : 4 
  } 
}
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRHye--_"
location: /_db/_system/_api/document/products/69154
x-content-type-options: nosniff

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69154

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHye--_"
x-content-type-options: nosniff
Show response body

Merging attributes of an object using mergeObjects:

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69168

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHzK--_"
x-content-type-options: nosniff

shell> curl -X PATCH --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69168?mergeObjects=true <<EOF
{ 
  "inhabitants" : { 
    "indonesia" : 252164800, 
    "brazil" : 203553000 
  } 
}
EOF

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69168

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHza--_"
x-content-type-options: nosniff

shell> curl -X PATCH --header 'accept: application/json' --data-binary @- --dump - http://localhost:8529/_api/document/products/69168?mergeObjects=false <<EOF
{ 
  "inhabitants" : { 
    "pakistan" : 188346000 
  } 
}
EOF

HTTP/1.1 Accepted
content-type: application/json; charset=utf-8
etag: "_bHcRHzq--_"
location: /_db/_system/_api/document/products/69168
x-content-type-options: nosniff

shell> curl --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69168

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHzq--_"
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

There are quite some changes in this in comparison to Version 2.8, but few break existing usage:

  • the rev query parameter is gone (was duplication of If-Match)
  • the policy query parameter is gone (was non-sensical)
  • the ignoreRevs query parameter is new, the default true gives the traditional behavior as in 2.8
  • the returnNew and returnOld query parameters are new

There should be very few changes to behavior happening in real-world situations or drivers. Essentially, one has to replace usage of the rev query parameter by usage of the If-Match header. The non-sensical combination of If-Match given and policy=last no longer works, but can easily be achieved by leaving out the If-Match header.

The collection name should now be specified in the URL path. The old way with the URL path /_api/document and the required query parameter collection still works.

Update documents

updates multiple documents

PATCH /_api/document/{collection}

Path Parameters

  • collection (string, required): This URL parameter is the name of the collection in which the documents are updated.

Query Parameters

  • keepNull (boolean, optional): If the intention is to delete existing attributes with the patch command, the URL query parameter keepNull can be used with a value of false. This will modify the behavior of the patch command to remove any attributes from the existing document that are contained in the patch document with an attribute value of null.

  • mergeObjects (boolean, optional): Controls whether objects (not arrays) will be merged if present in both the existing and the patch document. If set to false, the value in the patch document will overwrite the existing document’s value. If set to true, objects will be merged. The default is true.

  • waitForSync (boolean, optional): Wait until the new documents have been synced to disk.

  • ignoreRevs (boolean, optional): By default, or if this is set to true, the _rev attributes in the given documents are ignored. If this is set to false, then any _rev attribute given in a body document is taken as a precondition. The document is only updated if the current revision is the one specified.

  • returnOld (boolean, optional): Return additionally the complete previous revision of the changed documents under the attribute old in the result.

  • returnNew (boolean, optional): Return additionally the complete new documents under the attribute new in the result.

Request Body

(json, required)

A JSON representation of an array of document updates as objects.

Partially updates documents, the documents to update are specified by the _key attributes in the body objects. The body of the request must contain a JSON array of document updates with the attributes to patch (the patch documents). All attributes from the patch documents will be added to the existing documents if they do not yet exist, and overwritten in the existing documents if they do exist there.

Setting an attribute value to null in the patch documents will cause a value of null to be saved for the attribute by default.

If ignoreRevs is false and there is a _rev attribute in a document in the body and its value does not match the revision of the corresponding document in the database, the precondition is violated.

If the document exists and can be updated, then an HTTP 201 or an HTTP 202 is returned (depending on waitForSync, see below).

Optionally, the query parameter waitForSync can be used to force synchronization of the document replacement operation to disk even in case that the waitForSync flag had been disabled for the entire collection. Thus, the waitForSync query parameter can be used to force synchronization of just specific operations. To use this, set the waitForSync parameter to true. If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

The body of the response contains a JSON array of the same length as the input array with the information about the handle and the revision of the updated documents. In each entry, the attribute _id contains the known document-handle of each updated document, _key contains the key which uniquely identifies a document in a given collection, and the attribute _rev contains the new document revision. In case of an error or violated precondition, an error object with the attribute error set to true and the attribute errorCode set to the error code is built.

If the query parameter returnOld is true, then, for each generated document, the complete previous revision of the document is returned under the old attribute in the result.

If the query parameter returnNew is true, then, for each generated document, the complete new document is returned under the new attribute in the result.

Note that if any precondition is violated or an error occurred with some of the documents, the return code is still 201 or 202, but the additional HTTP header X-Arango-Error-Codes is set, which contains a map of the error codes that occurred together with their multiplicities, as in: 1200:17,1205:10 which means that in 17 cases the error 1200 “revision conflict” and in 10 cases the error 1205 “illegal document handle” has happened.

Responses

HTTP 201: is returned if the documents were updated successfully and waitForSync was true.

HTTP 202: is returned if the documents were updated successfully and waitForSync was false.

HTTP 400: is returned if the body does not contain a valid JSON representation of an array of documents. The response body contains an error document in this case.

HTTP 404: is returned if the collection was not found.

Changes in 3.0 from 2.8:

The multi document version is new in 3.0.

Removes a document

removes a document

DELETE /_api/document/{document-handle}

Path Parameters

  • document-handle (string, required): Removes the document identified by document-handle.

Query Parameters

  • waitForSync (boolean, optional): Wait until deletion operation has been synced to disk.

  • returnOld (boolean, optional): Return additionally the complete previous revision of the changed document under the attribute old in the result.

  • silent (boolean, optional): If set to true, an empty object will be returned as response. No meta-data will be returned for the removed document. This option can be used to save some network traffic.

Header Parameters

  • If-Match (string, optional): You can conditionally remove a document based on a target revision id by using the if-match HTTP header.

If silent is not set to true, the body of the response contains a JSON object with the information about the handle and the revision. The attribute _id contains the known document-handle of the removed document, _key contains the key which uniquely identifies a document in a given collection, and the attribute _rev contains the document revision.

If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

If the query parameter returnOld is true, then the complete previous revision of the document is returned under the old attribute in the result.

Responses

HTTP 200: is returned if the document was removed successfully and waitForSync was true.

HTTP 202: is returned if the document was removed successfully and waitForSync was false.

HTTP 404: is returned if the collection or the document was not found. The response body contains an error document in this case.

HTTP 412: is returned if a “If-Match” header or rev is given and the found document has a different version. The response will also contain the found document’s current revision in the _rev attribute. Additionally, the attributes _id and _key will be returned.

Examples

Using document handle:

shell> curl -X DELETE --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69088

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHq2---"
location: /_db/_system/_api/document/products/69088
x-content-type-options: nosniff
Show response body

Unknown document handle:

shell> curl -X DELETE --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69132

HTTP/1.1 Not Found
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Revision conflict:

shell> curl -X DELETE --header 'If-Match: "_bHcRHsq---"' --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69098

HTTP/1.1 Precondition Failed
content-type: application/json; charset=utf-8
etag: "_bHcRHsm---"
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

There are only very few changes in this in comparison to Version 2.8:

  • the rev query parameter is gone (was duplication of If-Match)
  • the policy query parameter is gone (was non-sensical)
  • the returnOld query parameter is new

There should be very few changes to behavior happening in real-world situations or drivers. Essentially, one has to replace usage of the rev query parameter by usage of the If-Match header. The non-sensical combination of If-Match given and policy=last no longer works, but can easily be achieved by leaving out the If-Match header.

Removes multiple documents

removes multiple document

DELETE /_api/document/{collection}

Path Parameters

  • collection (string, required): Collection from which documents are removed.

Query Parameters

  • waitForSync (boolean, optional): Wait until deletion operation has been synced to disk.

  • returnOld (boolean, optional): Return additionally the complete previous revision of the changed document under the attribute old in the result.

  • ignoreRevs (boolean, optional): If set to true, ignore any _rev attribute in the selectors. No revision check is performed.

Request Body

(json, required)

A JSON array of strings or documents.

The body of the request is an array consisting of selectors for documents. A selector can either be a string with a key or a string with a document handle or an object with a _key attribute. This API call removes all specified documents from collection. If the selector is an object and has a _rev attribute, it is a precondition that the actual revision of the removed document in the collection is the specified one.

The body of the response is an array of the same length as the input array. For each input selector, the output contains a JSON object with the information about the outcome of the operation. If no error occurred, an object is built in which the attribute _id contains the known document-handle of the removed document, _key contains the key which uniquely identifies a document in a given collection, and the attribute _rev contains the document revision. In case of an error, an object with the attribute error set to true and errorCode set to the error code is built.

If the waitForSync parameter is not specified or set to false, then the collection’s default waitForSync behavior is applied. The waitForSync query parameter cannot be used to disable synchronization for collections that have a default waitForSync value of true.

If the query parameter returnOld is true, then the complete previous revision of the document is returned under the old attribute in the result.

Note that if any precondition is violated or an error occurred with some of the documents, the return code is still 200 or 202, but the additional HTTP header X-Arango-Error-Codes is set, which contains a map of the error codes that occurred together with their multiplicities, as in: 1200:17,1205:10 which means that in 17 cases the error 1200 “revision conflict” and in 10 cases the error 1205 “illegal document handle” has happened.

Responses

HTTP 200: is returned if waitForSync was true.

HTTP 202: is returned if waitForSync was false.

HTTP 404: is returned if the collection was not found. The response body contains an error document in this case.

Examples

Using document handle:

shell> curl -X DELETE --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69122

HTTP/1.1 OK
content-type: application/json; charset=utf-8
etag: "_bHcRHt2---"
location: /_db/_system/_api/document/products/69122
x-content-type-options: nosniff
Show response body

Unknown document handle:

shell> curl -X DELETE --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69143

HTTP/1.1 Not Found
content-type: application/json; charset=utf-8
x-content-type-options: nosniff
Show response body

Revision conflict:

shell> curl -X DELETE --header 'If-Match: "_bHcRHtS---"' --header 'accept: application/json' --dump - http://localhost:8529/_api/document/products/69110

HTTP/1.1 Precondition Failed
content-type: application/json; charset=utf-8
etag: "_bHcRHtO---"
x-content-type-options: nosniff
Show response body

Changes in 3.0 from 2.8:

This variant is new in 3.0. Note that it requires a body in the DELETE request.

❮  Basics and Terminology

© ArangoDB - the native multi-model NoSQL database