MongoDB
The MongoDB node empowers your automation architecture to seamlessly query, insert, and update documents within massive NoSQL databases. Effortlessly bypass the limitations of basic spreadsheet storage and unleash enterprise-grade data processing without writing complex backend connection scripts.
What can you do with MongoDB?
Native Aggregation Pipelines
Unleash the full power of MongoDB by running complex $match, $group, and $lookup aggregation pipelines directly inside the workflow loop to aggregate millions of documents instantly.
Dynamic JSON Updates
Aggressively Upsert or selectively update deep JSON object fields natively. Pass dynamic workflow variables into your update conditions to prevent duplicate data.
Zero Memory Overflow
Built with a hardened Anti-OOM safety architecture. It enforces strict limit caps and contextual query cancellations, guaranteeing your queries never crash the main execution engine.
Detailed Usage & Configuration
The MongoDB node transforms nLink into a high-performance NoSQL Database-as-a-Service pipeline engine, allowing you to instantly interact with your massive unstructured document stores.
1. Dynamic CRUD Operations
- Find & Count: Surgically retrieve documents based on JSON queries. Support for
LimitandSkipenables flawless pagination. - Insert Documents: Easily funnel large arrays of JSON data gathered from an HTTP Request directly into your collections.
- Update / Upsert: Confidently modify existing records. If the target document doesn't exist, the Upsert capability ensures a new document is gracefully created without throwing errors.
2. Executing Aggregations
For heavy-duty data analysis, the standard Find operation isn't enough. The Node exposes the Aggregate operation to process entire pipelines natively.
[
{ "$match": { "status": "active" } },
{ "$group": { "_id": "$customerId", "total": { "$sum": "$amount" } } }
]
You can pass this exact array via dynamic expressions. To construct complex pipelines programmatically before querying, utilize the Code Node.
1000 documents. To retrieve more, enforce pagination using the Skip parameter.
