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 |
|---|---|---|
| TRUE | This deletes all documents in the database with the values from A1:B4 using the "Producer" in the collection "TestCollection". |