MONGO.STORE
Stores data on a Mongo database.
Syntax
=MONGO.STORE(Connection, Collection, Document)
Arguments
| Name | Type | Description |
|---|---|---|
| Connection | Connection | Reference to connection used for storing. The database name is configured in the affiliated connection settings. |
| Collection | String | Use an existing collection or type in any new collection name you need. |
| Document | JSON | Define the payload of your document by using a JSON cell range. |
Return
| Type | Description |
|---|---|
| Boolean or Error | TRUE, if no error. |
Examples
| A | B | |
|---|---|---|
| 1 | PatientID | 52243843 |
| 2 | PatientName | Meier |
| 3 | PatientSurname | Jack |
| 4 | VisitNumber | 532 |
| 5 | Gender | M |
| 6 | Counts | 2 |
| 7 | ||
| 8 | Collection Name: | DataSet1 |
| Formula | Result | Comment |
|---|---|---|
| TRUE | This stores the values in range A1:B6 in the collection in cell B8 |