MongoDB

Connect to MongoDB database

Configuration

Find Documents

Operation
Find Documents
Host*
localhost or your.mongodb.host
Port*
27017
Database Name*
your_database
Username*
mongodb_user
Password*
••••••••
Auth Source
admin
SSL Mode
Preferred
Collection Name*
users
Query Filter (JSON)
json
{"status": "active"}
Limit
100
Sort (JSON)
json
{"createdAt": -1}
Find Documents (mongodb_query)

Execute find operation on MongoDB collection

Input
ParameterTypeRequiredDescription
hoststringYesMongoDB server hostname or IP address
portnumberYesMongoDB server port (default: 27017)
databasestringYesDatabase name to connect to
usernamestringNoMongoDB username
passwordstringNoMongoDB password
authSourcestringNoAuthentication database
sslstringNoSSL connection mode (disabled, required, preferred)
collectionstringYesCollection name to query
querystringNoMongoDB query filter as JSON string
limitnumberNoMaximum number of documents to return
sortstringNoSort criteria as JSON string
Output
ParameterTypeDescription
messagestringOperation status message
documentsarrayArray of documents returned from the query
documentCountnumberNumber of documents returned

Insert Documents

Operation
Insert Documents
Host*
localhost or your.mongodb.host
Port*
27017
Database Name*
your_database
Username*
mongodb_user
Password*
••••••••
Auth Source
admin
SSL Mode
Preferred
Collection Name*
users
Documents (JSON Array)*
json
[{"name": "John Doe", "email": "john@example.com", "status": "active"}]
Insert Documents (mongodb_insert)

Insert documents into MongoDB collection

Input
ParameterTypeRequiredDescription
hoststringYesMongoDB server hostname or IP address
portnumberYesMongoDB server port (default: 27017)
databasestringYesDatabase name to connect to
usernamestringNoMongoDB username
passwordstringNoMongoDB password
authSourcestringNoAuthentication database
sslstringNoSSL connection mode (disabled, required, preferred)
collectionstringYesCollection name to insert into
documentsarrayYesArray of documents to insert
Output
ParameterTypeDescription
messagestringOperation status message
documentCountnumberNumber of documents inserted
insertedIdstringID of inserted document (single insert)
insertedIdsarrayArray of inserted document IDs (multiple insert)

Update Documents

Operation
Update Documents
Host*
localhost or your.mongodb.host
Port*
27017
Database Name*
your_database
Username*
mongodb_user
Password*
••••••••
Auth Source
admin
SSL Mode
Preferred
Collection Name*
users
Filter (JSON)*
json
{"name": "Alice Test"}
Update (JSON)*
json
{"$set": {"name": "Jane Doe", "email": "jane@example.com"}}
Upsert
False
Update Multiple
False
Update Documents (mongodb_update)

Update documents in MongoDB collection

Input
ParameterTypeRequiredDescription
hoststringYesMongoDB server hostname or IP address
portnumberYesMongoDB server port (default: 27017)
databasestringYesDatabase name to connect to
usernamestringNoMongoDB username
passwordstringNoMongoDB password
authSourcestringNoAuthentication database
sslstringNoSSL connection mode (disabled, required, preferred)
collectionstringYesCollection name to update
filterstringYesFilter criteria as JSON string
updatestringYesUpdate operations as JSON string
upsertbooleanNoCreate document if not found
multibooleanNoUpdate multiple documents
Output
ParameterTypeDescription
messagestringOperation status message
matchedCountnumberNumber of documents matched by filter
modifiedCountnumberNumber of documents modified
documentCountnumberTotal number of documents affected
insertedIdstringID of inserted document (if upsert)

Delete Documents

Operation
Delete Documents
Host*
localhost or your.mongodb.host
Port*
27017
Database Name*
your_database
Username*
mongodb_user
Password*
••••••••
Auth Source
admin
SSL Mode
Preferred
Collection Name*
users
Filter (JSON)*
json
{"status": "inactive"}
Delete Multiple
False
Delete Documents (mongodb_delete)

Delete documents from MongoDB collection

Input
ParameterTypeRequiredDescription
hoststringYesMongoDB server hostname or IP address
portnumberYesMongoDB server port (default: 27017)
databasestringYesDatabase name to connect to
usernamestringNoMongoDB username
passwordstringNoMongoDB password
authSourcestringNoAuthentication database
sslstringNoSSL connection mode (disabled, required, preferred)
collectionstringYesCollection name to delete from
filterstringYesFilter criteria as JSON string
multibooleanNoDelete multiple documents
Output
ParameterTypeDescription
messagestringOperation status message
deletedCountnumberNumber of documents deleted
documentCountnumberTotal number of documents affected

Aggregate Pipeline

Operation
Aggregate Pipeline
Host*
localhost or your.mongodb.host
Port*
27017
Database Name*
your_database
Username*
mongodb_user
Password*
••••••••
Auth Source
admin
SSL Mode
Preferred
Collection Name*
users
Aggregation Pipeline (JSON Array)*
json
[{"$group": {"_id": "$status", "count": {"$sum": 1}}}]
Aggregate Pipeline (mongodb_execute)

Execute MongoDB aggregation pipeline

Input
ParameterTypeRequiredDescription
hoststringYesMongoDB server hostname or IP address
portnumberYesMongoDB server port (default: 27017)
databasestringYesDatabase name to connect to
usernamestringNoMongoDB username
passwordstringNoMongoDB password
authSourcestringNoAuthentication database
sslstringNoSSL connection mode (disabled, required, preferred)
collectionstringYesCollection name to execute pipeline on
pipelinestringYesAggregation pipeline as JSON string
Output
ParameterTypeDescription
messagestringOperation status message
documentsarrayArray of documents returned from aggregation
documentCountnumberNumber of documents returned

Usage Instructions

Integrate MongoDB into the workflow. Can find, insert, update, delete, and aggregate data.

Notes

  • Category: tools
  • Type: mongodb