Dowell DataCube API

Available APIs

• Data CRUD
  Handles CRUD operations on MongoDB collections.
  /api/crud/
  GET Request Body

  {
                      "db_name": "example_db",
                      "coll_name": "example_collection",
                      "filters": {"field": "value"},
                      "limit": 50,
                      "offset": 0,
                      "is_deleted": false
                  }

  POST Request Body

  {
                      "db_name": "example_db",
                      "coll_name": "example_collection",
                      "data": {
                          "field1": "value1",
                          "field2": "value2"
                      }
                  }

  PUT Request Body

  {
                      "db_name": "example_db",
                      "coll_name": "example_collection",
                      "operation": "update",
                      "query": {"field": "value"},
                      "update_data": {"field1": "new_value"}
                  }

  DELETE Request Body

  {
                      "db_name": "example_db",
                      "coll_name": "example_collection",
                      "operation": "soft_delete",
                      "query": {"field": "value"}
                  }

  Example Responses
  GET:

  {
                      "success": true,
                      "message": "Data found!",
                      "data": [...]
                  }

  POST:

  {
                      "success": true,
                      "message": "Documents inserted successfully!"
                  }

  PUT:

  {
                      "success": true,
                      "message": "Document updated successfully"
                  }

  DELETE (soft_delete):

  {
                      "success": true,
                      "message": "Document soft-deleted successfully"
                  }

  DELETE (hard delete):

  {
                      "success": true,
                      "message": "Document deleted successfully"
                  }

• List Collections
  Lists all collections for a specified database.
  /api/list_collections/
  GET Request Body

  {
                      "db_name": "example_db"
                  }

  Example Responses
  GET:

  {
                      "success": true,
                      "message": "Collections retrieved successfully",
                      "data": ["collection1", "collection2", ...]
                  }

• Add Collection
  Adds new collections to an existing database, specifying document fields for each collection.
  /api/add_collection/
  POST Request Body

  {
                      "db_name": "example_db",
                      "collections": [...]
                  }

  Example Responses
  POST:

  {
                      "success": true,
                      "message": "Collections added successfully"
                  }

• Create Database
  Creates a new database with specified collections and fields.
  /api/create_database/
  POST Request Body

  {
                      "db_name": "new_database",
                      "collections": [...]
                  }

  Example Responses
  POST:

  {
                      "success": true,
                      "message": "Database created successfully"
                  }

• List Databases
  Lists all databases in the MongoDB cluster with pagination and optional filtering.
  /api/list_databases/
  GET Request Body

  {
                      "page": 1,
                      "page_size": 10,
                      "filter": "example"
                  }

  Example Responses
  GET:

  {
                      "success": true,
                      "message": "Databases retrieved successfully"
                  }

• Get Metadata
  Fetches metadata for a specific database, including collections, fields, and additional metadata.
  /api/get_metadata/
  GET Request Body

  {
                      "db_name": "example_db"
                  }

  Example Responses
  GET:

  {
                      "success": true,
                      "message": "Metadata retrieved successfully",
                      "data": {
                          "database_name": "example_db",
                          "number_of_collections": 3,
                          "number_of_fields": 12,
                          "collections_metadata": [...]
                      }
                  }