MONGO.QUERY

Gets data from your Mongo database. You can use the Function Wizard for this function.

Syntax

=MONGO.QUERY(Producer, Collection, QueryJSON, Target[, ResultKeys, PageSize, Page, Sort, Timeout])

Arguments

Name Description
Producer Producer to use for deleting. The database name is configured in the affiliated Connector.
Collection Choose an existing collection, where the item is stored.
QueryJSON Define a query using a JSON cell range, which defines the object(s) to be deleted.
Target Defines a place to show query result.
ResultKeys Optional. Filter the query result.
PageSize Optional. Number of Documents to return per page.
Page Optional. Index of page to return.
Sort Optional. Sort query result ascending or descending. Use 1 and -1 to sort by creation time, or use a JSON cell range.
Timeout Optional. Define Timeout.

Return Value

TRUE, if successful.

Examples

Function Result Comment
=MONGO.QUERY(“Producer”, “TestCollection”, JSON(A1:B4), INBOX()) TRUE All documents in the database with the values from A1:B4 using the “Producer” in the collection “TestCollection” will be shown in the Inbox of the current Streamsheet.