• Mapper
• JSON Generator

• Mapper
• JSON Formatter

Default value: MongoDB - Group

Example: Group Customer Churn Data

The database that contains the documents. If you do not specify a database, then the Snap uses the MongoDB account database.

Default value: N/A

Example: assets

Required. The MongoDB collection name to execute the grouping.

Default value: N/A

Example: users

An expression that represents the query parameter. If no query condition is defined, then MongoDB retrieves all the documents of the collection. 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.

Default value: N/A

Example: {num:1}

Required. The condition to group documents and create a single document for each distinct group. Read here for details on group conditions.

Default value: N/A

Example: {"_id": "$Churn", "num_customer": {$sum: 1}, "total": {$sum: "$TotalCharges"}}

The condition to order the documents in the result set. To use multiple sort orders, enter comma-separated sort conditions. Read here for details on sort conditions.

Default value: N/A

Example: {age: -1}

Required. The number of documents to return in a batch. Click here for more details on how MongoDB batches documents.

If n is the batch size, the Snap behaves as follows:

• If n > 1, the Snap gets all the documents in the collection that match the query condition (returns n documents at a time, or as many that can fit in the batch buffer)
• If n = 1, the Snap gets only one document in the collection that matches the query condition
• If n = 0, the Snap gets all documents in the collection that match the query condition (returns as many documents that can fit in the batch buffer at a time)
• If n < 0, the Snap gets n documents in the collection that match the query condition (for example, if n = -10, the Snap gets 10 documents)

In MongoDB 3.4, the batch buffer size is 16MB. In previous versions, the batch buffer size is 4MB. The initial batch always returns a maximum of 101 documents. Click here for details.

Default value: 0

Example: 0

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

Default status: Deselected

If selected, results are grouped in one single field named result, instead of an array.

Default status: Deselected

If selected, the input document is 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

Snap execution

Default value: Execute only

Example: Validate & Execute