MongoDB Delete

Deletes records in MongoDB

Processing

Performs a deleteOne operation using the given configuration.

Name	Type	Description
Query
Connection	dict	The MongoDB connection to use. Evaluated for each input row
Database	string	The database to use. Evaluated for each input row
Collection	string	The collection to delete from. Evaluated for each input row
Filter	string or dict	Specifies a filter that finds the document to delete as a BSON document. If you wish to delete a document by id, supply a filter of the form: `{ '_id' id_value }` In case the id value is of type ObjectId, it takes the form of a dict: `{'$oid' '5f760ed2513b2a82a014cee4'}` Evaluated for each input row

The Filter setting is parsed as a BSON document when given as string.

Values and BSON are converted as per the following table:

Dicts of the form {'$oid' string} are converted to BSON ObjectIds and vice versa.

Function values cannot be converted to BSON.

Converting a dict to BSON generally results in an unspecified key order in the BSON object.

If the order of keys is important, you can supply a specially constructed dict of the form:

{
  :__bson [
    [key1, value1],
    [key2, value2],
    ...
  ]
}

Such dicts are converted to a BSON object with the order of key-value pairs preserved:

{
  key1: value1,
  key2: value2,
  ...
}

You can use the BSON widget to generate such dicts in the UI.

Name	Type	Description
deleted_count	long	The number of documents that were deleted.