Built-in apps
MongoDB
13 min
mongodb is a document database with the mongodb app in {{product name}} , you can manage documents individually or in bulk, and perform bulk query actions in your mongodb account requirements to use the mongodb app in {{product name}} , you must have a mongodb account and a running instance of a mongodb database configured with public access to the internet connect mongodb and {{product name}} to get started, you must first create a connection between mongodb and {{product name}} , allowing the two services to communicate to create the connection, you need to mongodb /#whitelist ip addresses in mongodb mongodb docid 0tdo8r2ak8ijdp9no472x mongodb /#create the connection in whitelist ip addresses in mongodb before you create the connection in {{product name}} , you should first whitelist the required ip addresses in your mongodb account to do that log in to your mongodb account 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 {{product name}} , you should also get the connection string from your mongodb account to obtain the connection string log in to your mongodb account 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 connection string step 3 copy your connection string while pasting this connection string into the connection string field in {{product name}} , you need to r eplace \<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 {{product name}} you can also add the database name to the connection string (e g , mongodb+srv //\<username> \<password>@myclass 9fnerah mongodb net/ \<database name> \<database name> ?retrywrites=true\&w=majority ) it will be chosen as a default option for the database connection field in {{product name}} create the connection in {{product name}} once you have your mongodb connection string, you're ready to create the connection in {{product name}} to create the connection log in to your {{product name}} account, add an mongodb module to your {{scenario singular lowercase}} , and click create a 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 {{scenario plural lowercase}} if you want to make changes to your connection in the future, follow the steps connect an application docid\ so88fm6pkt0g adkddfzz mongodb modules after connecting to the mongodb app, you can use the following types of modules to build your {{scenario plural lowercase}} documents get a document retrieves a document by its object id or a query field description connection mongodb /#connect mongodb and 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 example if you select object id as a document search method, you'll get the contents of that document in the output create a document creates a document using json or a data structure field description connection mongodb /#connect mongodb and 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 f ollow the mongo db type representations for certain data json string enter a json string with the data you want to add to the document example 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 update a document updates a document using json, a data structure, or update operators field description connection mongodb /#connect mongodb and 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 f ollow 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 delete a document deletes a document using an object id or a query field description connection mongodb /#connect mongodb and 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 bulk create documents (advanced) 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 mongodb /#connect mongodb and 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 f ollow 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 example 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 bulk update documents (advanced) 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 mongodb /#connect mongodb and 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 f ollow 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 bulk delete documents (advanced) 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 mongodb /#connect mongodb and 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 search documents with a query returns all documents matching a query field description connection mongodb /#connect mongodb and 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 {{product name}} will return during one execution cycle example 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 singular lowercase}} update documents with a query updates all the documents matching a query using json, a data structure, or update operators field description connection mongodb /#connect mongodb and 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 f ollow 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 delete documents with a query deletes all documents matching a query field description connection mongodb /#connect mongodb and 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