Bubble.io and Amazon DynamoDB integration: Step-by-Step Guide 2024

Bubble.io does not directly support integration with Amazon DynamoDB out of the box. However, you can perform this integration by creating a RESTful API using AWS Lambda and API Gateway, then consuming that API in Bubble.io.

Here's a step by step guide to integrate Bubble.io with Amazon DynamoDB:

Step 1: Setting up AWS CLI

Before you proceed ensure AWS CLI (Command Line Interface) is installed and configured on your machine. Refer to the official AWS CLI documentation for the instructions on the same.

Step 2: Create a DynamoDB Table

Create a DynamoDB table with the required attributes. Remember, when using the table, the item's identity is composed of a Partition key, and optionally, a sort key.

You can create a table from AWS CLI with following command:

aws dynamodb create-table --table-name YOUR-TABLE-NAME --attribute-definitions AttributeName=YOUR-PARTITION-KEY,AttributeType=S AttributeName=YOUR-SORT-KEY,AttributeType=N --key-schema AttributeName=YOUR-PARTITION-KEY,KeyType=HASH AttributeName=YOUR-SORT-KEY,KeyType=RANGE --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5

Replace YOUR-TABLE-NAME, YOUR-PARTITION-KEY and YOUR-SORT-KEY with appropriate values.

Step 3: Creating the Lambda Function

You will need to package your function code and dependencies in a .zip file to create the Lambda function.

• Create a .js file with following content:

var aws = require('aws-sdk');
aws.config.region = 'us-east-1'; // Replace with your AWS region
var dynamodb = new aws.DynamoDB();

exports.handler = (event, context, callback) => {

    var params = {
        TableName : "YOUR-TABLE-NAME", // Replace with your table name
        Key: { 
            "YOUR-PARTITION-KEY" : {S: "VALUE"},  // Replace with your partition key and its value
            "YOUR-SORT-KEY" : {N: "VALUE"} // Replace with your sort key and its value, remove if you do not have a sort key
        }
    };

    dynamodb.getItem(params, function(err, data) {
        if (err) {
            callback(err, null);
        } else {
            callback(null, data);
        }
    });
};

Replace YOUR-TABLE-NAME, YOUR-PARTITION-KEY and YOUR-SORT-KEY with appropriate values.

• Then package the AWS SDK and this script in a .zip file.

Step 4: Deploying the Lambda Function

Deploy the function on AWS Lambda using the AWS CLI with the following command:

aws lambda create-function --function-name FUNCTION-NAME --runtime nodejs12.x --role ROLE-ARN --handler HANDLER-FILE-NAME.handler --zip-file fileb://file-path/ZIP-FILE-NAME.zip

Replace FUNCTION-NAME with a name for your AWS Lambda Function, ROLE-ARN with the Amazon Resource Name(ARN) for the AWS IAM Role, HANDLER-FILE-NAME with the name of your JavaScript file, and ZIP-FILE-NAME with the path to your .zip file.

Step 5: Setting up API Gateway

After creating the AWS Lambda function, you will need to expose it as a REST API that can be integrated with Bubble.io:

• Go to the API Gateway service on AWS Console.
• Click on Create API
• Choose REST API and click on Build
• Configure the API according to your needs
• Create a GET method for the Resource
• Inside the GET method, choose the Lambda function you created
• Deploy the API

Step 6: Integrate with Bubble.io

• Go to your app on Bubble.io
• Navigate to the Plugins tab and install the API Connector plugin
• Navigate to the API tab and add a new API
• Set the API URL to the Invoke URL of the AWS API Gateway
• Set the method to GET
• Set the parameters and headers as needed
• Initialize and test the call
• After successful initialization, you can consume the API in your workflows.

That's it, your Bubble.io app is now integrated with Amazon DynamoDB via AWS Lambda and AWS API Gateway. You can use the same methodology to perform CRUD operations on the DynamoDB Table. However, you will need to modify the code in the Lambda function and configure corresponding API Gateway methods (POST, PUT, DELETE etc.) for each operation.