PowerPlatformConnectors/certified-connectors/MongoDB
DianaMDB 5cd625bb66
Added OpenAI plugin related changes to swagger (#3425)
2024-04-30 15:31:01 +05:30
..
Readme.md MongoDB Connector (#1745) 2022-07-01 21:06:56 +02:00
apiDefinition.swagger.json Added OpenAI plugin related changes to swagger (#3425) 2024-04-30 15:31:01 +05:30
apiProperties.json Diana mdb preview test 1 (#2227) 2022-12-16 16:27:26 -08:00

Readme.md

MongoDB Connector

MongoDB is the leading modern, general purpose, document-based, distributed database, designed to unleash the power of software and data for developers and the applications they build. The MongoDB Data API provides you REST access to your data in MongoDB Atlas ,the database-as-a-service offering by MongoDB. The API includes endpoints that create, read, update, delete, and aggregate documents in your cluster.

Publisher: MongoDB

Prerequisites

  1. Create an MongoDB Atlas Cluster

Get started by creating a MongoDB Atlas Account with a running Cluster, hosting the Database that you want to connect to from the Power Platform.

  1. Enable the Data API

  2. Create a Data API Key

Supported Operations

Perform CRUD operations and aggregations on your data in minutes. Below are teh supported operations:

  1. Find a Single Document
  2. Find Multiple Documents
  3. Insert a Single Document
  4. Insert Multiple Documents
  5. Update a Single Document
  6. Update Multiple Documents
  7. Replace a Single Document
  8. Delete a Single Document
  9. Delete Multiple Documents
  10. Run an Aggregation Pipeline

Read the full documentation of the operations and their examples here

Getting Started

  1. In the Base URL field in the General tab, replace the placeholder "Data API App ID" with the App ID from the URL endpoint under Data API tab in your Atlas cluster.
  2. For some APIs which expect a Json request or response , the layout/sample of the json needs to be added using the "Import from Sample" option for the Request or Response under the Definition tab.

Known Limitations

  1. Data API logs all requests and stores the logs for 30 days.They can be viewed from the Data API screen in the Logs tab
  2. The Data API has restrictions in terms of the size of the Request and the Response body and the response time which is detailed here

Deployment Instructions

Please use these instructions to deploy this connector as a custom connector within Microsoft Power Automate and Power Apps