Todo API Implementation

A MuleSoft API implementation that demonstrates MySQL database integration using Docker containers. This project shows how to build a Todo API with database connectivity in Anypoint Code Builder (ACB).

Important: API Specification Setup

⚠️ Before using this project, you'll need to implement the API specification in your own Anypoint Platform organization.

The complete OpenAPI 3.0 specification is available in todo-task-api.yaml. This project currently references an API specification from a specific organization. To use this project:

1. Import the specification - Upload todo-task-api.yaml to your Anypoint Exchange
2. Update the reference - Modify the API reference in src/main/mule/global.xml and pom.xml to point to your organization's API
3. Configure the project - Update the api attribute in the apikit:config element with your organization's API details

The API specification defines:

• All available endpoints and their operations
• Request/response schemas for Task objects
• Query parameters for filtering tasks
• Error responses and status codes

Features

• ✅ MySQL database running in Docker
• ✅ MuleSoft flows with database operations
• ✅ DataWeave transformations for SQL and JSON
• ✅ RESTful API endpoints
• ✅ VS Code integration with Container Tools and Database Client
• ✅ OpenAPI 3.0 specification

API Endpoints

Method	Endpoint	Status	Description
GET	/api/tasks	✅ Implemented	Get all tasks
GET	/api/tasks/{taskId}	🔄 Placeholder	Get specific task
POST	/api/tasks	🔄 Placeholder	Create new task
PUT	/api/tasks/{taskId}	🔄 Placeholder	Update task
DELETE	/api/tasks/{taskId}	🔄 Placeholder	Delete task

Prerequisites

• VS Code with extensions:
  • Anypoint Extension Pack
  • Container Tools
  • Database Client
  • Postcode
• Docker Desktop

Quick Start

1. Start MySQL Database

Use the Container Tools extension in VS Code to click "Run All Services" on the docker-compose.yml file.

version: '3'
services:
  db:
    image: mysql:latest
    environment:
      MYSQL_ROOT_PASSWORD: admin
      MYSQL_DATABASE: mysqldb
      MYSQL_USER: user
      MYSQL_PASSWORD: password
    ports:
      - 3306:3306
    volumes:
      - db_data:/var/lib/mysql
volumes:
  db_data:

2. Set Up Database

Connect to MySQL using the Database Client extension:

• Host: 127.0.0.1
• Port: 3306
• User: user
• Password: password
• Database: mysqldb

Run the SQL script to create the tasks table:

CREATE TABLE tasks(  
    id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    description VARCHAR(255),
    dueDate VARCHAR(255),
    completed BOOLEAN NOT NULL
);

3. Run the Application

Start the Mule application in Anypoint Code Builder.

4. Test the API

Use Postcode or any REST client:

GET http://localhost:8081/api/tasks