MONGO.DELETE

Stores data on a Mongo database.

Syntax

=MONGO.DELETE(Connection, Collection, QueryJSON, Target, [Timeout])

Arguments

Name	Type	Description
Connection	Connection	Reference to connection used for deleting. The database name is configured in the affiliated connection settings.
Collection	String	Choose an existing collection, where the item is stored.
QueryJSON	JSON	Define a query using a JSON cell range, which defines the object(s) to be deleted.
Target	Target	INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed.
Timeout (optional)	Number	Define Timeout in seconds.

Return

Type	Description
Boolean or Error	TRUE, if no error.

Examples

Formula	Result	Comment
=MONGO.DELETE(MongoConnection!,"TestCollection", JSON(A1:B4))	TRUE	This deletes all documents in the database with the values from A1:B4 using the "Producer" in the collection "TestCollection".