Skip to main content

API Creator Concept

DB-2-API

Creating APIs from databasesCreating endpoints from SQL queries, calling stored procedures, and batch operations.

Script-2-API

Creating APIs from scriptsExposing JavaScript or Groovy code as APIs.

Mock API Creator

Creating mock APIsInstantly creating mock APIs without any server or code writing needs.

Instant Creation

On-the-fly API creationInstantly creating and publishing APIs without requiring additional server setup.

DB-2-API

DB-2-API Features

  • Creating endpoints from SQL queries
  • SELECT, INSERT, UPDATE, DELETE support
  • Calling stored procedures
  • Returning cursor results
  • MySQL
  • PostgreSQL
  • Oracle
  • MSSQL
  • DB2
  • Other JDBC-supported databases
  • Bulk data processing
  • Transaction support
  • Error handling

DB-2-API Usage Scenarios

Rapid Prototyping

Rapid API creation from databaseInstantly creating API prototypes without writing code.

Legacy System Integration

Converting legacy databases to APIsConverting existing databases to modern APIs.

Microservice Creation

Exposing database operations as servicesPublishing database operations as microservices.

Script-2-API

Script-2-API Features

JavaScript Support

  • Running JavaScript code
  • Node.js-like environment

Groovy Support

  • Groovy script support
  • Java integration

Message Access

  • Request/Response access
  • Header access
  • Body manipulation

External API Calls

  • HTTP client
  • Database connection
  • Other API calls

Script-2-API Usage Scenarios

Custom Logic

APIs containing custom business logicAPIs with custom logic using JavaScript/Groovy.

Data Transformation

Data transformation APIsData format conversion and processing APIs.

Business Logic

Business logic APIsAPIs containing business rules and logic.

Mock API Creator

Mock API Creator Features

  • Sample responses
  • Schema-based response
  • Custom responses
  • Different responses for different scenarios
  • Error scenarios
  • Success scenarios
  • Variable responses
  • Random data generation
  • Conditional response

Mock API Creator Usage Scenarios

Frontend Development

Frontend development without backend readyStarting frontend development before backend development is completed.

API Design

Testing API designTesting and validating API design with mock API.

Integration Testing

Integration testsUsing mock API in integration tests.

API Creator Advantages

Rapid Development

  • Rapid API creation without writing code
  • APIs ready for instant use

Easy to Use

  • Form-based interface
  • Minimal configuration

Flexibility

  • Creating APIs from various sources
  • Customizable endpoints

Integration

  • Integration with existing systems
  • Integration with API Gateway

API Creator and API Gateway Relationship

APIs created with API Creator are automatically published through API Gateway. Workflow:
API Creator

   │ API Creation
   │ (DB-2-API / Script-2-API / Mock API)


API Gateway

   │ Automatic Publishing
   │ Traffic Management


Client Requests

1. API Creation

Creating API with API CreatorCreating DB-2-API, Script-2-API, or Mock API.

2. Automatic Publishing

Automatic publishing through API GatewayCreated APIs are automatically added to gateway.

3. Traffic Management

API Gateway traffic managementSecurity, rate limiting, and routing are applied.
APIs created with API Creator automatically benefit from all API Gateway features (security, rate limiting, monitoring, analytics).

Next Steps