AWS Lambda

🔒 Secure Integration Using AWS Lambda

In some cases, for security or internal policy reasons, you may prefer not to give Aissist direct access to your information systems. A simple solution is to create a lightweight API that grants restricted access, controls what data can be retrieved, filters or processes it as needed, and defines exactly what output Aissist can use.

One great tool for this is AWS Lambda — a serverless platform that lets you run code without worrying about server management, scaling, or load balancing. It’s cost-effective (you only pay for what you use) and easy to set up, making it a perfect choice for creating a simple RESTful API for Aissist.

In this tutorial, we'll show you how to build a basic AWS Lambda function that fetches booking information from your internal database.

---

🛠️ Step-by-Step Guide

Step 1: Write Your Data Retrieval Code

Create a simple Python script to pull booking details using a booking ID:

import mysql.connector

def lambda_handler(event, context):
    secrets = dict()
    with open("secrets.json") as input_fp:
        secrets = json.load(input_fp)
    
    database = mysql.connector.connect(
        host=secrets["host"],
        database=secrets["database"],
        user=secrets["user"],
        password=secrets["password"]
    )

    query = """ SELECT * FROM cr_booking WHERE id = %s """
    cursor = database.cursor()
    cursor.execute(query, (json.loads(event['body'])["booking_id"],))
    
    column_names = [col[0] for col in cursor.description]
    bookings = [dict(zip(column_names, row)) for row in cursor.fetchall()]
    
    return {"book_details": bookings}

Step 2: Package Your Code for AWS Lambda

You'll need to package your code, your secrets.json file, and any required Python libraries into a zip file.

1. Install the MySQL connector package:

   pip3 install --target ./packages mysql-connector

2. Create the deployment package:

   cd ./packages
   zip -r ../deployment_package.zip .
   cd ..
   zip deployment_package.zip lambda_function.py
   zip deployment_package.zip secrets.json

Step 3: Create Your AWS Lambda Function

1. Go to the AWS Lambda Console.

2. Create a new Lambda function.

3. For simplicity, enable Function URL and set Auth Type to None (or use AWS API Gateway for extra security if needed).

4. Upload your deployment_package.zip created in Step 2.

5. After upload, your Lambda function will have a public URL — this will act as your new RESTful API.

✅ Now your lightweight, secure API is ready!

Step 4: Connect Lambda to Aissist

Finally, connect your new API to Aissist:

• Follow the usual steps for Restful API integration create integration first then the action
• Use the Function URL from Lambda as the API endpoint

---

📌 Why Use AWS Lambda for Integration?

• 🔒 Secure Access Control — Only expose the necessary data.

• ⚡ Fast and Scalable — Lambda scales automatically with no server setup.

• 💰 Cost-Effective — Pay only for the compute time you use.

• 🔧 Flexible — Customize your output for exactly what Aissist needs.

---

After setting up the Shopify integration and actions, you can use the Action Debugger to test and verify that everything is working correctly.