Built-in apps
MongoDB
13 min
mongodb is a document database with the mongodb app in , you can manage documents individually or in bulk, and perform bulk query actions in your mongodb account requirements to use the mongodb app in , you must have a https //www mongodb com/ and a running instance of a mongodb database configured with public access to the internet connect mongodb and to get started, you must first create a connection between mongodb and , allowing the two services to communicate to create the connection, you need to docid 0tdo8r2ak8ijdp9no472x docid 0tdo8r2ak8ijdp9no472x docid 0tdo8r2ak8ijdp9no472x whitelist ip addresses in mongodb before you create the connection in , 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 https //help make com/allow connections to and from make ip addresses obtain your connection string in mongo db to create the connection in , 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 , 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 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 create the connection in once you have your mongodb connection string, you're ready to create the connection in to create the connection log in to your account, add an mongodb module to your , 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 if you want to make changes to your connection in the future, follow the steps docid\ so88fm6pkt0g adkddfzz mongodb modules after connecting to the mongodb app, you can use the following types of modules to build your documents get a document retrieves a document by its object id or a query true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type 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 true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type 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 true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type delete a document deletes a document using an object id or a query true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type multiple documents bulk create documents (advanced) creates multiple documents using json or a data structure this module has built in aggregation true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type 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 true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type bulk delete documents (advanced) deletes multiple documents by their object ids or a query this module has built in aggregation true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type queries search documents with a query returns all documents matching a query true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type 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 update documents with a query updates all the documents matching a query using json, a data structure, or update operators true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type delete documents with a query deletes all documents matching a query true 210left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type mongodb resources https //www mongodb com/docs/ https //www mongodb com/docs/guides/