Input 

Document

• Min: 1

• Max: 1

Any Snap with document output view.

A map data to evaluate expression properties and/or to update documents in a MongoDB collection

. Each input document produces one document at the output view or the error view.

Output

Document

• Min: 0

• Max: 1

Any Snap with document input 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
    }
  }
}

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:

• Stop Pipeline Execution: Stops the current pipeline execution when the Snap encounters an error.

• Discard Error Data and Continue: Ignores the error, discards that record, and continues with the rest of the records.

• Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Label*

Default Value: MongoDB - Update
Example: MongoDB - Update

String

Specify a name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Database name

Default Value: N/A
Example: assets

String/Expression/Suggestion

Specify the database in which the collection is defined. If you do not specify one, the database configured in the MongoDB Account will be used.

Collection name*

Default Value:

 N/A
Example: leads

String/Expression/Suggestion

Select or enter a MongoDB collection name.

Update query*

Default value:N/A
Example:
(with '=' expression enabled) 

$id represents an integer in this example.

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

or

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

Textbox

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.

Learn more about MongoDB Extended JSON

.

Update operation

Default Value: $set
Example: $min

String/Expression/Suggestion

Specify the operation to be performed on the update query.

Exclude list

List of input fields to exclude from the dataset.

Exclude field

Default Value: _id
Example: $ranking

 String/Suggestion

Specify the list of input fields that must be removed from the dataset before sending the dataset to MongoDB.

Array filters

Default Value:N/A
Example:

$arrayFilters

Expression/Textbox

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

Upsert

Default Value: Deselected

Checkbox

Select this checkbox to insert a document from the input view if no document in the collection matches the update query criteria. 

Update all that match

Default Value: 

Selected

Checkbox

Select this checkbox to update all documents in the collection that match the update query criteria

; otherwise the Snap updates only one document. 

Pass through

Default value:

Selected

Checkbox

Select this checkbox to pass the input document

through to the output

view under the key 'original'. The document

is passed to the Parameter output view, and it will also be passed to the Result Set output view if

output is

sent from this view.

Snap execution

Default

Value:

Execute only
Example: Validate & Execute

Dropdown list

Select one of the three modes in which the Snap executes. Available options are:

• Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

• Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

• Disabled: Disables the Snap and all Snaps that are downstream from it.