• Mapper
• JSON Parser

Optional. This Snap has at most one document output view.

{
  "updatedDocuments": n,
  "matchedDocuments": m,
  "updateOfExisting": [true or false],
  "inserted": [true or false],
  "original": {input document}
}

• In the above output:
  • updatedDocuments - is the number of MongoDB documents that are changed in the update query. The updateOfExisting is true if updatedDocuments is greater than 0.
  • matchedDocuments - is the number of MongoDB documents that match the query for potential change.
  • updateOfExisting - is true if there are any updatedDocuments, otherwise, false.

For example, if the existing documents are:

{
  "name": "Ralph",
  "color": "blue",
  "available": true
}
{
  "name": "Sally",
  "color": "blue",
  "available": false
}

And an update with query{} and input document of:

{
  "available": true
}

then the result will be as follows:

{
  "updatedDocuments": 1,
  "matchedDocuments": 2,
  "updateOfExisting": true,
  "inserted": false,
  "original": {
    {
      "available": true
    }
  }
}

• Mapper
• JSON Formatter

Label

Default value: MongoDB - Update

The database in which the collection is defined. If not specified, then the MongoDB account database will be used.

Default value: N/A

Example: assets

Required. Select or enter a MongoDB collection name.

Default value: N/A

Example: leads

Required. The update query represents the update query parameter. It is an expression that evaluates to an object or JSON string. When the expression evaluates to an object, only strict mode is supported. When the expression evaluates to a JSON string, both strict mode and mongo shell mode are supported. More information about MongoDB Extended JSON can be found here.

Example: (with '=' expression enabled)

$id represents an integer in this example.

{"id": {$lte: $id}}

or

'{"id": {$lte:' + $id + '}}'

Default value: N/A

The operation to be performed on the update query.

Default value: $set

Example: $min

The filter conditions to determine the array elements you want to modify for the update operation. This field supports upstream values.

Default value: N/A

Example: $arrayFilters

If selected, a document from the input view is inserted if no document in the collection matches the update query criteria.

Default status: Deselected

If selected, all documents in the collection that match the update query criteria are updated; otherwise the Snap updates only one document.

Default status: Selected

If selected, the input document will be passed through to the output view under the key 'original'. The document will be passed to the Parameter output view, and it will also be passed to the Result Set output view if there is output sent from this view.

Default status: Selected

Specify the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response.

Default value: 0

Example: 4

Specify the time interval between two retry requests.

Default value: 1

Example: 5

Snap execution

Default value: Execute only

Example: Validate & Execute