Skip to main content

MONGO.AGGREGATE

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

Syntax

=MONGO.AGGREGATE(Producer, Collection, Aggregate JSON, Target[, Result Keys, Timeout])

Arguments

NameDescription
ProducerProducer to use for aggregating. The database name is configured in the affiliated Connector.
CollectionChoose an existing collection, where the items are stored.
Aggregate JSONDefine an aggregation using a JSON cell range.
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.
Result KeysOptional. Filter the result.
TimeoutOptional. Define Timeout.

Return Value

TRUE, if no error.