MongoDB (In Process)

This documentation provides a detailed, step-by-step guide for integrating your Mindbody account with Pabbly Connect. Following these instructions will enable you to establish a seamless connection between the two platforms.

How to authorize MongoDB in Pabbly Connect?

• Within Pabbly Connect, established a connection between Mindbody and Pabbly Connect.

Integration Steps:

1. Select "MongoDB" Trigger/Action:

Within Pabbly Connect, navigate to the action step and choose "Mindbody" as the application then in the action event select the event you wish to perform, such as "".


2. Configure the Connection:

To establish a connection, select "Add New Connection" and log in to your Mindbody account. If you already have an existing connection, you can opt for "Select Existing Connection" instead.


How to activate the permission on MongoDB to establish a proper connection.

Network Access Setup:

• Go to your MongoDB Atlas account.
• Navigate to "Network Access" under "Security".
• Click "Add IP Address" and enter your IP address to allow access to the MongoDB database from your location.

Obtain the connection string in Mongo DB:​

• Log in to your MongoDB account. In the left sidebar, click "Database > Clusters > Connect".

1. Connection String Format:

Code:
mongodb+srv://<username>:<password>@myclass.9fnerah.mongodb.net/<database_name>?retryWrites=true&w=majority

Example:

mongodb+srv://John:[email protected]/Product?retryWrites=true&w=majority

​

Field Specifications​

custom_json​

• Description: custom_json is a predefined JSON structure used within the API. This field has a fixed format, which ensures consistent data structures are maintained across different records.

Example:

{"name":"John Doe",
"age":24
}

custom_data​

• Description: custom_data is a flexible field where users can create their own JSON structure. It allows JSON in MongoDB's canonical format and relaxed format, providing more flexibility for data input.
  • Canonical format: Standard MongoDB JSON format, ideal for explicitly defined keys and data types.
  • Relaxed format: More user-friendly, allowing JSON values to be interpreted in a simplified format (e.g., numbers as plain integers without quotes).

     {            
          "name": "John Doe",           
           "age": {
                    "$numberInt": "28"
                },
                "isDeveloper": true,
                "createdAt": {
                    "$date": "2024-10-06T10:30:00Z"
                },
                "balance": {
                    "$numberDecimal": "1000.123456789"
                },
                "height": {
                    "$numberDouble": "5.75"
                },
                "Num1_64": {
                    "$numberLong": "546"
                },
                "Num2_32": {
                    "$numberInt": "10"
                },
                "infiniteNumber1": {
                    "$numberDouble": "Infinity"
                },
                      "bin04": {
                        "$binary": {
                            "base64": "NTUwZTg0MDBlMjliNDFkNGE3MTY0NDY2NTU0NDAwMDA=",
                            "subType": "00"
                        }
                    },
                "projects": [
                    {
                        "title": "Chat Application",
                        "year": {
                            "$numberInt": "2061"
                        },
                        "technologies": [
                            "React",
                            "Node.js",
                            "MongoDB"
                        ]
                    },
                    {
                        "title": "E-commerce Website",
                        "year": {
                            "$numberInt": "2024"
                        },
                        "technologies": [
                            "MERN Stack",
                            "Express"
                        ]
                    }
                ],
                "projects2": [
                    {
                        "title": "Chat Application 23",
                        "year": {
                            "$numberInt": "2025"
                        },
                        "technologies": [
                            "React",
                            "Node.js",
                            {
                                "$numberInt": "28"
                            }
                        ]
                    }
                ],
                "Regex_1": {
                    "$regularExpression": {
                        "pattern": "^Anurag$",
                        "options": "i"
                    }
                },
                "timestampField": {
                    "$timestamp": {
                        "t": 1565545664,
                        "i": 1
                    }
                },
                "uuid": {
                    "$uuid": "3b241101-e2bb-4255-8caf-4136c566a962"
                },
                "Binary_data_1": {
                    "bin1": {
                        "$binary": {
                            "base64": "SGVsbG8sIFdvcmxkIQ==",
                            "subType": "00"
                        }
                    },
                    "bin2": {
                        "$binary": {
                            "base64": "SGVsbG8gU2FyYW5zaCBLYWlzZSBobw==",
                            "subType": "00"
                        }
                    }
                },
                "userId": {
                    "$oid": "60ad4e26adf5692f72b57a28"
                }
            }

Unique Data​

• Indexing: MongoDB's index feature is used to ensure data uniqueness in the database. By creating an index on specific fields, the database prevents duplicate records, enforcing unique data entries.

Base64 Encoding​

For encoding values to Base64 format, you can use the following URL:

• Base64 Encode Tool
  Select the Encode option for converting data to Base64 format as needed for your MongoDB documents.

MongoDB Documentation for Data Insertion:
MongoDB Canonical Format/Relaxed Format