Skip to main content
Version: Streamsheets 2.4


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


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


ProducerProducer to use for deleting. The database name is configured in the affiliated Connector.
CollectionChoose an existing collection, where the item is stored.
QueryJSONDefine a query using a JSON cell range, which defines the object(s) to searched for.
TargetINBOX(), 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.
ResultKeysOptional. Filter the query result.
PageSizeOptional. Number of Documents to return per page.
PageOptional. Index of page to return.
SortOptional. Sort query result ascending or descending. Use 1 and -1 to sort by creation time, or use a JSON cell range.
TimeoutOptional. Define Timeout.

Return Value

TRUE, if no error.


=MONGO.QUERY(|Producer, "TestCollection", JSON(A1:B4), INBOX())TRUEAll 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.