• Mapper
• JSON Parser

• Mapper
• JSON Formatter

Default value: MongoDB - Find

Example: Find Customer Records

The database that the collection is defined in. If not specified, then the MongoDB account database will be used.

Default value: N/A

Example: assets

Required. The MongoDB collection name to execute the find on.

Default value: N/A

Example: users

The query condition represents the find query parameter. It is an expression that evaluates to an object or JSON string. If no query condition is defined, then all records of the collection will be retrieved. When the expression evaluates to an object, only strict mode is supported. When the expression evaluates to a JSON string, both strict mode and mongo shell mode are supported. More information about MongoDB Extended JSON can be found here.

Example: (with '=' button pressed/expression enabled)

$id represents an integer in this example.

{"id": {$lte: $id}}

or

'{"id": {$lte:' + $id + '}}'

Default value: N/A

Specifies which fields must be returned in the matching documents. You can include or exclude fields. You can use the following values:

• 1 or true to include the field
• 0 or false to exclude the field

Default value: N/A

Example: {age:0, status:0}

Orders the documents in the result set. To use multiple sort orders, enter comma-separated sort conditions.

Default value: N/A

Example: {age: -1}

Required. This property limits the number of documents returned in a batch. More can be read here.

The definition of this property is different from the same property in other DB Snaps.

Assume Batch size is n,

• if n > 1, get all documents in the collection that match (returns n documents at a time, or as many that can fit in the batch buffer)
• if n = 1, get only one document in the collection that matches
• if n = 0, get all documents in the collection that match (returns as many documents that can fit in the batch buffer at a time)
• if n < 0, get n documents in the collection that match (e.g. if n = -10, get only 10 documents that match)

In MongoDB 3.4, the batch buffer size is 16MB. In previous versions, the batch buffer size is 4MB. The initial batch will always return a maximum of 101 documents. More can be read here.

Default value: 0

Example: 0

The starting document for the query. The result set starts from this document.

Default value: N/A

Example: 100

The number of documents the query must return.

Default value: N/A

Example: 20

If selected, the output result is grouped in a single array.

Default status: Deselected

If selected, the input document will be passed through to the output view under the key 'original'.

Default status: Selected

Specify the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response.

Default value: 0

Example: 4

Specify the time interval between two retry requests.

Default value: 1

Example: 5

If selected, no document will be written to the output view when the FIND operation does not produce any result. If this property is not selected and the Pass through property is selected, the input document will be passed through to the output view.

Default status: Deselected

Snap execution

Default value: Validate & Execute

Example: Execute only

To run a query using UUIDs, perform the following:

1. As the current MongoDB JAR does not support UUIDs in a query, you must use the latest version of the MongoDB driver. Navigate to your MongoDB account settings and select the latest available JAR.
2. The new versions of the MongoDB driver do not support date/time strings without timezones. To correctly parse dates, enter a timezone in the Snap Time Zone Offset settings. For example, 2013-08-29T17:56:44.161<Z>, where "Z" is the time offset.
3. Enter the following query in the Query Condition field of the Snap settings:

   "{\"user_id\": new BinData(3,\""+ Base64.encode(Uint8Array.of(...$user_id.replaceAll('-', '').match(/(\w\w)/g).map(x => parseInt(x, 16)))) + "\")}"