Skip to main content

GetMongoRecord

Description

A record-based version of GetMongo that uses the Record writers to write the MongoDB result set.

Tags

fetch, get, json, mongo, mongodb, record

Properties

In the list below required Properties are shown with an asterisk (*). Other properties are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.

Display NameAPI NameDefault ValueAllowable ValuesDescription
Client Servicemongo-client-serviceController Service:
MongoDBClientService

Implementations:
MongoDBControllerService
If configured, this property will use the assigned client service for connection pooling.
Record Writer *get-mongo-record-writer-factoryController Service:
RecordSetWriterFactory

Implementations:
AvroRecordSetWriter
CSVRecordSetWriter
FreeFormTextRecordSetWriter
JsonRecordSetWriter
RecordSetWriterLookup
ScriptedRecordSetWriter
XMLRecordSetWriter
The record writer to use to write the result sets.
Mongo Database Name *Mongo Database NameThe name of the database to use

Supports Expression Language, using FlowFile attributes and Environment variables.
Mongo Collection Name *Mongo Collection NameThe name of the collection to use

Supports Expression Language, using FlowFile attributes and Environment variables.
Schema Name *mongodb-schema-name${schema.name}The name of the schema in the configured schema registry to use for the query results.

Supports Expression Language, using FlowFile attributes and Environment variables.
Query Output Attributemongo-query-attributeIf set, the query will be written to a specified attribute on the output flowfiles.

Supports Expression Language, using FlowFile attributes and Environment variables.
QueryQueryThe selection criteria to do the lookup. If the field is left blank, it will look for input from an incoming connection from another processor to provide the query as a valid JSON document inside of the FlowFile's body. If this field is left blank and a timer is enabled instead of an incoming connection, that will result in a full collection fetch using a "{}" query.

Supports Expression Language, using FlowFile attributes and Environment variables.
ProjectionProjectionThe fields to be returned from the documents in the result set; must be a valid BSON document

Supports Expression Language, using FlowFile attributes and Environment variables.
SortSortThe fields by which to sort; must be a valid BSON document

Supports Expression Language, using FlowFile attributes and Environment variables.
LimitLimitThe maximum number of elements to return

Supports Expression Language, using FlowFile attributes and Environment variables.
Batch SizeBatch SizeThe number of elements to be returned from the server in one batch

Supports Expression Language, using FlowFile attributes and Environment variables.

Dynamic Properties

This component does not support dynamic properties.

Relationships

NameDescription
failureAll input FlowFiles that are part of a failed query execution go here.
originalAll input FlowFiles that are part of a successful query execution go here.
successAll FlowFiles that have the results of a successful query execution go here.

Reads Attributes

This processor does not read attributes.

Writes Attributes

NameDescription
mongo.collection.nameThe collection where the results came from.
mongo.database.nameThe database where the results came from.

State Management

This component does not store state.

Restricted

This component is not restricted.

Input Requirement

This component allows an incoming relationship.

System Resource Considerations

This component does not specify system resource considerations.

See Also