Published in


Rest Api with ApiGateway and DynamoDb

The common approach of software development is use a middleware function to manipulate the data between api and database.

The serverless way to achieve this in AWS world is use a lambda function to do this job as following sample:

Sometimes (a lot of times to be honest) we just use this to as proxy to database. What about remove this useless code and keep the things simple and clean as a possible?

This is a “good scenario”, you can have here a container or even a application deployed on a Ec2, consuming a lot of resources for exactly nothing.

With a ApiGateway using mapping templates you can implement a restfull api, with almost zero line codes and delivery a good solution in a record time with lower cost possible . The schema you can see bellow:

Once you convinced , let’s to this

1- Create a DynamoDB table

To this sample, I’ve create a super simple table just with id, name and userName. I won’t detail how to do this, but you can see the steps here:

2- Create a Role

Your role should have access to your table, for this sample I’ve created a full dynamo db, sure in a real world is a good practice create a fine granulated access for each api,table and method

Polices of the Role

3- Create Your Api Gateway

Create a API Gateway with the following structure :

On method post, you should point the Dynamo db and indicate your role created in the previous step

Once created, you should create a mapping template to convert a body content from the post rest request to a PutItem DynamoDb request, in the Integration Request > Mapping Templates add a new item with content type application/json with the following content:

"TableName": "users",
"Item": {
"uid": {
"S": "$context.requestId"
"name": {
"S": "$input.path('$.name')"
"userName": {
"S": "$input.path('$.userName')"

What this code means? this maps the body name and username from body from the post method to the properties “name” and “userName” dynamoDb request. The uid is filled with a requestId unique generated by api gateway request.

Once this done, let’s do our first test and analyse the response:

As you can see, the rest call is converted to putitem invoke to dyname and the response was 200, the item has been created and you can check on dynamo db console:)

4- Create a Resource and Get Method

Create a Resource with resource path {username} and a get method associated. Configure the get method almost as the post, but changing the “PutItem” to “Query”, once the action now needed is that query in the database.

Now we need to create again the Mapping Templates on Integration Request, but now with the following translation:

"TableName": "users",
"IndexName": "userName-index",
"KeyConditionExpression": "userName = :val",
"ExpressionAttributeValues": {
":val": {
"S": "$input.params('username')"

This maps the resource param username to dynamoDb with the condition “userName” and does the query.

Now, we need to create a additional step and create a mapping to the response, on Integration Response > Mapping Templates add a new item with content type application/json with the following content:

#set($inputRoot = $input.path('$'))
"users": [
#foreach($elem in $inputRoot.Items) {
"uid": "$elem.uid.S",
"name": "$",
"userName": "$elem.userName.S"

Let`s test and analyse the response:

We have passed the username created early “rocampana” witch contains a array (with just one item) with all users with this profile registered on database.

And now we have two methods:

post — users/
get — users/{username}

Those responses on rest style with almost zero code and a clean and cheapest infrastructure possible

Now, ensure that your api gateways resources is accessed securely and be happy




BRLink is a company focused on Cloud Computing, Machine Learning, Analytics and App Modernization. We can help you with your cloud journey

Recommended from Medium

iOS Dev Course: Keyboard Observer

Cost Effective Offsite Personal Backups with Amazon Glacier

I will convert psd, xd, figma, sketch to html css bootstrap

By Nikolay S, Andrey P, Nikita S, Andrey D, Max E, Nikita M.

7 Online tools for Front-End Development 👨🏻‍💻

The Project Success Trifecta

Securing APIs with APIkey

What are the types of Automation Testing?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rafael Campana

Rafael Campana

Tech Manager @ BRLink — AWS Certified Developer & Big Data

More from Medium

Testing with DynamoDB Toolbox

What is Serverless Architecture? And Why Businesses Are Going Serverless

AWS S3 Read and Write Operations using AWS Lambda (Typescript/Javascript)

How to upload files or images to aws s3 storage on graphql in apollo server using localstack —…