tweakstreet-logo
  • Enter search terms

MongoDB Insert

Inserts records into MongoDB and returns record ids

Processing

Inserts the given document into the specified collection. The id of the inserted document is available in step results.

Settings

Name Type Description
Query
Connection
 dict

The MongoDB connection to use.

Evaluated for each input row
Database
 string

The database to use.

Evaluated for each input row
Collection
 string

The collection to insert into.

Evaluated for each input row
Document
 string or dict

The document to insert.

Evaluated for each input row
Processing
Batch Size
 long

The number of documents to insert in one batch.

If set 0 or nil documents are inserted one by one.

Evaluated once when the step initializes
Ordered Batch
 boolean

If true, batch inserts are run as ordered operations, otherwise they run as unordered operations.

Evaluated once when the step initializes
Bypass Validation
 boolean

If true, insert operations bypass schema validation.

Evaluated once when the step initializes

The document to insert is parsed as a BSON document when given as string.

Values and BSON are converted as per the following table:

Value Type Bson Type
boolean bool
long int or long
double double
decimal decimal
datetime date
string string
binary binary
list array
dict object

Dicts of the form {'$oid' string} are converted to BSON ObjectIds and vice versa.

Function values cannot be converted to BSON.

Note:

Converting a dict to BSON generally results in an unspecified key order in the BSON object.

If the order of keys is important, you can supply a specially constructed dict of the form:

{
  :__bson [
    [key1, value1],
    [key2, value2],
    ...
  ]
}

Such dicts are converted to a BSON object with the order of key-value pairs preserved:

{
  key1: value1,
  key2: value2,
  ...
}

You can use the BSON widget to generate such dicts in the UI.

Results

Name Type Description
inserted_id
 any The id of the inserted document.
On this page