Mongo Query

The Mongo Query component allows you to execute queries on a collection of a MongoDB database.

By default, it will retrieve all the documents. Additionally, you can filter which documents are retrieved based on query and specify a sort order.

Configuration

General

Connection string

A MongoDB connection string.

Example: mongodb://<username>:<password>@localhost:27017/<databaseName>

Here <databaseName> is the database to connect to.

Collection Name

The name of the collection to query.

Example: documents

TLS

Use TLS

Whether or not to use TLS in case your mongoDB requires TLS.

Allow Invalid Certificates

Checking this will disable certificate validation.

warning

Specifying this option in a production environment makes your application insecure and potentially vulnerable to expired certificates and to foreign processes posing as valid client instances.

Certificate Authority File

One or more certificate authorities to trust when making a TLS connection.

Example: .\ca.pem

info

All configuration values listed below can be overridden using the incoming object.
If a configuration value expects an object (for example query, sort or projection), the value must be provided as stringified JSON in the incoming object.

Query

A Mongo query that can be passed in find(). Example: {"kind":"CONTAINER"}

note

The Query input field uses HandleBars. You can use Handlebars to create dynamic queries. For more information, please read HandleBars

For nested keys, you can use the so-called dot-notation.

An empty query value or empty object {} will return all the data from the database.

Override key: query (stringified JSON)

Sort

Specify in the sort parameter the field or fields to sort by and a value of 1 or -1 to specify an ascending or descending sort respectively.

Example: {"kind":1}

Override key: sort (stringified JSON)

Projection

Specify in the projection parameter the field or fields you want to include or exclude from the query result. A value of 1 indicates inclusion and a value of 0 indicates exclusion.

note

Inclusion and exclusion cannot be used simultaneously.

Example: {"kind":1}

Override key: projection (stringified JSON)

Distinct

The distinct method retrieves an array of unique values for a specified field in a collection.

Example: kind

Override key: distinct (string)

Limit

Specify a limit on the number of documents that you want to retrieve.

Override key: limit (number)

Skip

Specify the amount of documents that should be skipped before results are retrieved.

Override key: skip (number)

Enable parsing numberDecimal

By default Mongo will retrieve NumberDecimals (in this example 1.05) as { $numberDecimal: "1.05" }. By enabling parsing numberDecimal the returning value will be a float: 1.05 instead.

note

Rounded numbers will parse to a number that does not have its decimals anymore. For example { "testKey": { $numberDecimal: "1.0" } } will parse to { "testKey": 1 }.

Override key: parseNumberDecimal (boolean)

Rate limit

Batch size

Allows you to configure the batch size.

Override key: batchSize (number)

Interval

The interval in milliseconds in which the requests happen.

Override key: interval (number)

Inputs | Outputs

Mongo-Query

Input

Output

Error

00 0 (ilygfry455)

The incoming data is not used unless the query uses a variable from this object. The incoming data can be empty if you don't need any variables.

Example:

//query in config:
{ "kind":"{{kind}}" }

//incoming data:
{
  _id: "135176441e008d9d0c5ba0cee61783ce",
  kind: "CONTAINER"
}