Skip to main content
Version: Streamsheets 3.0

MONGO.STORE

Stores data on a Mongo database.

Syntax

=MONGO.STORE(Connection, Collection, Document)

Arguments

NameTypeDescription
ConnectionConnectionReference to connection used for storing. The database name is configured in the affiliated connection settings.
CollectionStringUse an existing collection or type in any new collection name you need.
DocumentJSONDefine the payload of your document by using a JSON cell range.

Return

TypeDescription
Boolean or ErrorTRUE, if no error.

Examples

AB
1PatientID52243843
2PatientNameMeier
3PatientSurnameJack
4VisitNumber532
5GenderM
6Counts2
7
8Collection Name:DataSet1
FormulaResultComment
=MONGO.STORE(MongoConnection!,B8,JSON(A1:B6))
TRUEThis stores the values in range A1:B6 in the collection in cell B8