Amazon DynamoDB + Trello Integrations

Trello is a web-based task management application. It is used by individuals, teams, organizations and businesses for managing projects and personal tasks.The users can create boards to organize the tasks. They can add checklists (called cards), comments, files and labels to the cards. Trello is used for many purposes including managing personal, academic, business projects and team projects. The service is free for use up to a limit of 100 users and 10,000 cards.As an application developer, you may be interested in integrating your applications with Trello. You can do it using Amazon API Gateway. Amazon API Gateway is a fully managed service that makes it easy for developers to create, publish, maintain, monitor, and secure APIs at any scale. Amazon API Gateway provides a simple web service API that developers use to publish their services to AWS.Amazon API Gateway allows you to publish any RESTful web service endpoint, such as your existing web service or backend application, as an API. With Amazon API Gateway, you can easily manage all aspects of API lifecycle – design, development, testing, deployment, security, performance, monitoring, and maintenance – through a single console.With Amazon API Gateway you can quickly create flexible REST APIs that support multiple authentication methods via API key or token based authentication. You can enable HTTPS (secure HTTP. access to your APIs via both SNI (Server Name Indication. and ALPN (Application-Layer Protocol Negotiation. SSL protocols. And you can deliver the responses from your APIs in JSON or XML format.However, if you have an existing application developed in Java or .NET framework, it's not easy to create REST APIs for those applications by using Amazon API Gateway alone.To address this concern, Amazon has released an SDK for Java called Amazon DynamoDB Accelerator . It is a library that leverages Amazon DynamoDB to make it easier for you to build scalable applications and keep them highly available and performant.Here is how it works:You can configure your application to save the data into a table in Amazon DynamoDB. When an application client inserts data into the table, it triggers a Lambda function invocation which processes the inserted data and then puts the data into another table in Amazon DynamoDB in parallel. This process is illustrated below:The code snippet below shows how you can configure the table in DynamoDB Accelerator:And here is how you can save a record from an application client:The code snippet below shows how you can read the data saved in the table in DynamoDB Accelerator:In this post I am going to show how you can integrate your application with Trello using Amazon DynamoDB Accelerator .

Integration of Amazon DynamoDB and Trello

First of all, you need to sign up on both Amazon AWS and Trello . Then go to the AWS Console and open the Amazon DynamoDB Accelerator service page . Click on Upload Application button and upload your WAR file i.e. Your application file. It might take some time for your file to be uploaded so please be patient.If your file is successfully uploaded then click on Next Step button as shown below:Now you will see an Access Key ID and Secret Access Key that are needed for integrating your application with Trello . Please note that these keys will NOT be displayed again after this step so please copy the keys somewhere safe before moving forward. Please note that these keys are different than the AWS Access Key ID and Secret Access Key that you see on your own AWS account page so do not use them here (Note. You will see these keys on your own AWS account page):Now create an AWS CloudFormation template that will install DynamoDB Accelerator on Amazon EC2 instance:Now create an AWS CloudFormation stack named "DynamoDBAccelerator" based on the template that you created above:Once your stack is created successfully then open DynamoDB Accelerator console . You should see your application running in it:Now open Trello site and register/login yourself on it (if you are not already registered/logged-in):Now click on Integrations link as shown below:In the next page click on Add Service menu / button:In the next page select "DynamoDB" option from the left column as shown below:In the next page search for "DynamoDB Accelerator" i.e. Type "DynamoDBAccelerator" in search box of "Get New Services" window as shown below:Select DynamoDB Accelerator service from the search results as shown above and click on Connect/Save button:In the next screen click on Enable button as shown below:In the next screen choose "Create new group" option as shown below:In the next screen name your group i.e. type "My Group" in text field as shown below:Now click on Save button as shown below:Now select group that you just created i.e. type "My Group" in text field of "Add Service" window as shown below:Now select tab "Integrations" of "My Group" window as shown below:Now click on Integrations link of "Integrations" tab as shown below:In the next page click on Add Service menu / button:In the next page select "AWS Service Endpoint" option from left column as shown below:Select "AmazonDynamoDB" option from search results as shown below:Now click on Connect/Save button as shown below:In the next screen select "Configure new endpoint" option as shown below:In the next screen enter "Endpoint URL" i.e. type https://localhost/ as shown below:In the next screen enter "Region" i.e. type one of the following region names depending upon where you want your application endpoints to reside . us-east-1 , us-west-1 , us-west-2 , eu-west-1 , eu-central-1 , ap-southeast-1 , ap-northeast-1 , ap-southeast-2 , sa-east-1 , us-gov-west-1 , cn-north-1 . In this example I am going to use us-east-1 region only because I live there :. Note that you must change region name accordingly if you want your endpoints to reside in some other region :. Now click on Next Step button as shown below:In the next screen enter "AppID" i.e. type aws_dynamodb_accelerator_apigw_appid as shown below:Enter "AppKey" i.e. type aws_dynamodb_accelerator_apigw_key as shown below:Now click on Next Step button as shown below:     Step 6 is very important because if you forget to select "Enable CORS" option then your Trello will not be able to communicate with your API endpoint properly! So please select CORS one! :. Now click on Next Step button as shown below. Now click on Save button as shown below. Now you will see your newly created integration under Integrations section i.e. type My Group in text field of Get New Services window as shown below. Now go back to Trello site and sign in/log in again if you are not already logged in :. Now go to Boards Tab / Window . Now create a new board named Test Board . Now create three lists named List 1 , List 2 , List 3 . Now create two cards named Card 1 , Card 2 . Now go back to AWS Console and go to DynamoDB Accelerator console and click on Monitoring menu / tab and then click on Refresh Data button as shown below. You will see that data has been saved successfully into Trello . Here is what it looks like when I clicked on Refresh Data button . Now go back to Trello site and open List 1 (i.e. list's name. And you should see two cards there :. This was just a demo to show how you can integrate your application with Trello using AWS DynamoDB Accelerator . I hope it was helpful for you :. Cheers!

The process to integrate Amazon DynamoDB and Trello may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick solution to help you automate your workflows. Click on the button below to begin.