STORE

Deprecated since version 1.4: use database specific functions instead, e.g. MONGO.STORE

This function sends JSON data to a producer, which defines a database connection.

Syntax

=STORE(Object, Producer, Collection, Arrayhandling)

Arguments

Name

Description

Object

JSON Object with content to STORE

Producer

Producer to store with

Collection

The collection to store on

Arrayhandling

If the first element of the payload is an array object it is possible to store every elemnt single handed or as one big document. Use TRUE or FALSE to decide.

Return Value

TRUE or FALSE

Example

Function

Result

Comment

STORE(JSON(A1:B2), “Mongo Producer”, “Demo”, FALSE)

TRUE

The JSON(A1:B2) was stored as a whole in the “Demo” collection in the defined database of the “Mongo Producer”