Enterprise Transaction Analytics API

Transform your transaction data into actionable insights with our powerful, scalable API. Built for modern applications with TypeScript, PostgreSQL, and comprehensive testing.

Why Choose CitySpender?

Built with enterprise-grade technologies and best practices for scalability, security, and developer experience.

Real-time Analytics

Get instant insights into spending patterns across cities and individual users with powerful aggregation capabilities.

Easy Data Import

Upload transaction data via CSV files with automatic validation and processing for seamless integration.

Type-Safe API

Built with TypeScript and Prisma for robust type safety, validation, and excellent developer experience.

Complete Documentation

Interactive Swagger documentation with examples, making API integration straightforward and efficient.

PostgreSQL Powered

Enterprise-grade database with Docker support for reliable, scalable data storage and retrieval.

Comprehensive Testing

Full test coverage with Jest and Supertest ensuring reliability and maintainability of the API.

API Endpoints

Clean, RESTful API design with comprehensive documentation and examples.

GET
/health

Health check endpoint to verify API status and system metrics

GET
/report/city

Get city-wide transaction summary with optional date filters and aggregation

GET
/report/user/:user_id

Get user-specific transaction report with merchant and category breakdowns

POST
/upload

Upload transaction CSV file for data import with validation and error handling

Modern Tech Stack

Built with cutting-edge technologies for performance, scalability, and developer experience.

Node.js

Runtime Environment

TypeScript

Type Safety

Express.js

Web Framework

PostgreSQL

Database

Prisma

ORM

Docker

Containerization

99.9%

Uptime

< 100ms

Response Time

100%

Test Coverage

24/7

Support