Tencent/APIJSON

Features

• API Generators - Automatically creates REST endpoints based on existing database schemas and structural constraints.
• Database API Generators - Automatically generates CRUD HTTP endpoints and technical documentation based on relational database schemas.
• Schema-Driven API Generators - Automatically transforms relational database schemas into functional HTTP endpoints for CRUD operations and data retrieval.
• No-Code Database Interfaces - Provides a no-code environment to create functional HTTP endpoints for relational database operations.
• Database ORMs - Provides a universal object-relational mapping layer to decouple client requests from the underlying SQL implementation.
• CRUD Interfaces - Offers automated interfaces for performing create, read, update, and delete operations on database records.
• Dot-Notation Join Paths - Supports fetching data from multiple related tables using dot-notation join paths based on foreign key relationships.
• No-Code ORMs - Implements a no-code ORM layer allowing frontend clients to define custom JSON response structures and complex queries.
• Query Filters - Implements conditional logic and range-based constraints to filter and refine database query results.
• Query Translators - Converts structured JSON request parameters into optimized native SQL for filtering, sorting, and pagination.
• Record Deletion - Enables the removal of individual or bulk database records by translating request identifiers into delete commands.
• Record Insertion - Provides standardized interfaces for inserting new data records into relational database tables.
• Record Updating - Modifies specific fields of existing database records by translating request data into update commands.
• Relational Join Engines - Combines data from multiple tables based on shared column values through a unified API request.
• Structured Record Querying - Offers interfaces for retrieving specific records from a database based on structured JSON criteria.
• Subquery Execution - Supports advanced data retrieval by using the result of one select statement as a source for another.
• Endpoint Controls - Allows administrators to control access and enable or disable specific generated API endpoints.
• Database Injection Prevention - Automatically sanitizes and parameterizes inputs to prevent SQL injection attacks on the database layer.
• Database Access Controls - Provides granular permission and role management to secure API endpoints and restrict database access.
• Row Level Security - Implements granular access control by filtering database records based on the authenticated user's assigned permissions.
• Role-Based Access Controls - Enforces granular security policies at both the table and row level based on assigned user roles.
• Dynamic Response Shaping - Allows the requesting client to specify the exact JSON structure and field aliases returned by the server.
• Client-Side Response Shaping - Allows clients to define the exact data structure and fields required in a single request.
• Client-Defined Response Shaping - Allows clients to define custom JSON response structures and field aliases directly within the request to reduce payload size.
• Database Query Interfaces - Provides a web-based interface for executing relational queries, joins, and data aggregations without manual coding.
• Schema-Driven Specification Generation - Generates living API specifications and client code snippets by analyzing the current database schema.
• Query Aggregates - Provides utilities for performing mathematical calculations like count and sum on database query results.
• Pagination Controls - Provides logic for limiting returned records and offsetting starting points to browse large datasets.
• Server-Side Functions - Enables the invocation of custom server-side functions and stored procedures to handle complex business rules.
• API Testing Tools - Includes a development environment for validating database endpoints with custom test data and regression tests.
• Custom Logic Extensions - Provides mechanisms to execute custom server-side scripts to extend core system behavior and process retrieved data.
• Request Validation Middleware - Includes middleware that validates user permissions and sanitizes input for every incoming request.
• Automated API Documentation - Generates technical specifications and living documentation directly from the database schema.
• Remote Function Invocation - Triggers remote functions or stored procedures to handle complex business rules and data transformations.
• API Endpoint Testing - Provides tools for sending live HTTP requests to verify server responses against specifications.
• API Regression Testing - Provides automated regression testing by saving request history to verify endpoint behavior.
• Test Case Organizers - Organizes and manages interface use cases with built-in validation and result summarization.
• Type-Safe Client Generators - Produces type-safe client code from API specifications to ensure consistency between frontend and backend.
• Request Snippet Generators - Generates ready-to-use request snippets for frontend clients and scripts based on defined API queries.
• API Parameter Validation - Enforces advanced input rules and parameter dependencies to ensure data integrity before processing.

Star history