MongoDB

13 min

MongoDB is a document database.

With the MongoDB app in Make, you can manage documents individually or in bulk, and perform bulk query actions in your MongoDB account.

Requirements

To use the MongoDB app in Make, you must have a MongoDB account and a running instance of a MongoDB database configured with public access to the Internet.

Connect MongoDB and Make

To get started, you must first create a connection between MongoDB and Make, allowing the two services to communicate.

To create the connection, you need to:

Whitelist IP addresses in MongoDB.

Obtain the connection string in MongoDB.

Create the connection in Make.

Whitelist IP addresses in MongoDB

Before you create the connection in Make, you should first whitelist the required IP addresses in your MongoDB account.

To do that:

In the header, select your Organization and Project.

In the SECURITY section in the left sidebar, click, click Network Access.

Then, click + ADD IP ADDRESS.

For the Access List Entry field, enter the IP addresses for your zone and click Confirm.

You can find the Make IP addresses here.

Obtain your connection string in Mongo DB

To create the connection in Make, you should also get the connection string from your MongoDB account.

To obtain the connection string:

In the header, select your Organization and Project.

In the left sidebar, click Clusters and select the Cluster you want to connect to.

Then click Connect.

Click Connect to your application > Drivers.

Copy your Connection string.

While pasting this Connection string into the Connection string field in Make, you need to replace <username> and <db_password>with your actual credentials.

You can obtain them from the MongoDB Admin. The Admin can either use personal credentials or create a dedicated database user for Make integration.

To create a new user:

In the SECURITY section in the left sidebar, click Database access.

Click +ADD NEW DATABASE USER.

Enter username and password, and click Add user.

Once the user is created, the <username> and <db_password> can be replaced with these credentials while paste the Connection string into Make.

You can also add the database name to the connection string (e.g., mongodb+srv://<username>:<password>@myclass.9fnerah.mongodb.net/<database name>?retrywrites=true&w=majority). It will be chosen as a default option for the Database connection field in Make.

Create the connection in Make

Once you have your MongoDB connection string, you're ready to create the connection in Make.

To create the connection:

Optional: In the Connection name field, enter a name for the connection.

In the Connection string field, enter the connection string copied above.

Click Save.

If prompted, authenticate your account and confirm access.

You have successfully created the connection and can now use the MongoDB app in your scenarios. If you want to make changes to your connection in the future, follow the steps here.

MongoDB modules

After connecting to the MongoDB app, you can use the following types of modules to build your scenarios:

Documents

Retrieves a document by its Object ID or a query.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Enter Object ID Search by query
Object ID	Enter Object ID (e.g., 68c1688aeb6a133fb1d0e39d)
Query	Enter a query to specify the search.
Projection	Specify which fields to include or exclude from the query result.

If you select Object ID as a document search method, you'll get the contents of that document in the output:

Creates a document using JSON or a data structure.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document input method	Select document creation method: Data structure JSON string
Data structure	Create a data structure or choose the existing one. Make sure to follow the Mongo DB Type Representations for certain data.
JSON string	Enter a JSON string with the data you want to add to the document.

A simplified example could be when you pull the data from the Google Sheets > Watch New Rows module and want to create a document in MongoDB with this data (e.g., full name, age, and city). You can define the following data structure, and later map the values in the corresponding fields:

Or add data as a JSON string:

A document will be created in your MongoDB database:

Updates a document using JSON, a data structure, or update operators.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Enter Object ID Search by query
Object ID	Enter Object ID.
Query	Enter a query to specify the search.
Update input method	Select document search method: Data structure JSON string Update operators
Data structure	Create a data structure or choose the existing one. Make sure to follow the Mongo DB Type Representations for certain data.
JSON string	Enter a JSON string with the data you want to add to the document.
Update operators	Use MongoDB update operators for particular updates in the documents.

Deletes a document using an Object ID or a query.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Enter Object ID Search by query
Object ID	Enter Object ID.
Query	Enter a query to specify the search.

Multiple Documents

Creates multiple documents using JSON or a data structure. This module has built-in aggregation.

Field	Description
Source Module	Select the module whose output you want to aggregate.
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document input method	Select document creation method: Data structure JSON string
Data structure	Create a data structure or choose the existing one. Make sure to follow the Mongo DB Type Representations for certain data.
JSON string	Enter a JSON string with the data you want to add to the document.
Group by	Use this field in case you need to create documents in more than one Collection within one execution. Map the Database and Collection in this field.
Stop processing after an empty aggregation	When selected, Make stops when there are no results.

You can use MongoDB > Bulk create documents (advanced) as an aggregator. For example, when you pull the data from the Google Sheets > Watch New Rows module and want to create multiple documents in MongoDB with this data (e.g., full name, age, and city). You can define the data structure and map the values from the Google Sheets to the MongoDB module in the corresponding fields:

Several documents will be created in your MongoDB database:

Updates multiple documents using JSON, a data structure, or update operators. This module has built-in aggregation.

Field	Description
Source Module	Select the module whose output you want to aggregate.
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Create if not found	Select whether a new document shall be created automatically if no matching document is found.
Document search method	Select document search method: Enter Object ID Search by query
Object ID	Enter Object ID.
Query	Enter a query to specify the search.
Update input method	Select document search method: Data structure JSON string Update operators
Data structure	Create a data structure or choose the existing one. Make sure to follow the Mongo DB Type Representations for certain data.
JSON string	Enter a JSON string with the data you want to add to the document.
Update operators	Use MongoDB update operators for particular updates in the documents.
Group by	Use this field in case you need to create documents in more than one Collection within one execution. Map the Database and Collection in this field.
Stop processing after an empty aggregation	When selected, Make stops when there are no results.

Deletes multiple documents by their Object IDs or a query. This module has built-in aggregation.

Field	Description
Source Module	Select the app module you are using to aggregate the fields you need.
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Enter Object ID Search by query
Object ID	Enter Object ID.
Query	Enter a query to specify the search.
Group by	Use this field in case you need to create documents in more than one Collection within one execution. Map the Database and Collection in this field.
Stop processing after an empty aggregation	When selected, Make stops when there are no results.

Queries

Returns all documents matching a query.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Search by query
Object ID	Enter Object ID.
Query	Enter a query to specify the search.
Sort	Define the order in which documents should be returned.
Projection	Specify which fields to include or exclude from the query result.
Limit	Set the maximum number of results Make will return during one execution cycle.

A simplified example could be when you have a database in MongoDB with the documents containing full name, age, and city. To find people from Madrid, you can use the {"city":"Madrid"} query:

In the output, you'll get all the results that match the query. You can further use this data in any other relevant module of your scenario.

Updates all the documents matching a query using JSON, a data structure, or update operators.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Search by query
Query	Enter a query to specify the search.
Update input method	Select document search method: Data structure JSON string Update operators
Data structure	Create a data structure or choose the existing one. Make sure to follow the Mongo DB Type Representations for certain data.
JSON string	Enter a JSON string with the data you want to add to the document.
Update operators	Use MongoDB update operators for particular updates in the documents.

Deletes all documents matching a query.

Field	Description
Connection	Create a connection to your MongoDB account.
Database	Enter the MongoDB database name where the collection is stored, or leave it blank if you defined a default database in the connection string.
Collection	Enter the MongoDB collection name.
Document search method	Select document search method: Search by query
Query	Enter a query to specify the search.

MongoDB resources

MongoDB API documentation

MongoDB Get Started Guides

MongoDB

Requirements

Connect MongoDB and Make

Whitelist IP addresses in MongoDB

Obtain your connection string in Mongo DB

Create the connection in Make

MongoDB modules

Documents

Get a document

Create a document

Update a document

Delete a document

Multiple Documents

Bulk create documents (advanced)

Bulk update documents (advanced)

Bulk delete documents (advanced)

Queries

Search documents with a query

Update documents with a query

Delete documents with a query

MongoDB resources

MongoDB

Requirements

Connect MongoDB and Make﻿

Whitelist IP addresses in MongoDB

Obtain your connection string in Mongo DB

Create the connection in Make﻿

MongoDB modules

Documents

Get a document

Create a document

Update a document

Delete a document

Multiple Documents

Bulk create documents (advanced)

Bulk update documents (advanced)

Bulk delete documents (advanced)

Queries

Search documents with a query

Update documents with a query

Delete documents with a query

MongoDB resources

Connect MongoDB and Make

Create the connection in Make