API docs by Redocly

Fincept API (1.0.0)

Download OpenAPI specification:Download

Fincept Team: support@fincept.in

This is the documentation for the Fincept API, which provides secure and public endpoints for user management, data subscriptions, and database querying.

  • Private Endpoints: Require API keys and subscription verification.
  • Public Endpoints: Freely accessible without API keys or rate limits.

Authentication

User authentication and email verification.

Register a new user

Request Body schema: application/json
username
string
email
string <email>
password
string <password>

Responses

Request samples

Content type
application/json
{
  • "username": "johndoe",
  • "email": "johndoe@example.com",
  • "password": "mypassword123"
}

Response samples

Content type
application/json
{
  • "message": "User registered successfully.",
  • "api_key": "7b186f32-d353-4754-a30f-d382e4188684"
}

Verify user email with OTP

Request Body schema: application/json
email
string <email>
otp
integer

Responses

Request samples

Content type
application/json
{
  • "email": "johndoe@example.com",
  • "otp": 123456
}

Response samples

Content type
application/json
{
  • "message": "Email verified successfully!"
}

Subscription

Managing database subscriptions.

Public Endpoints

Publicly accessible data endpoints.

Filter rows in a table by column value

path Parameters
dbname
required
string
Example: FinanceDB

The name of the database.

table
required
string
Example: equities

The name of the table.

column
required
string
Example: sector

The column to filter by.

query Parameters
value
required
string
Example: value=Technology

The value to filter the column by.

Responses

Response samples

Content type
application/json
[
  • { }
]

Private Endpoints

Endpoints requiring API keys and subscriptions.

Get a list of available databases

Responses

Response samples

Content type
application/json
{
  • "databases": [
    ]
}

Get tables from a database

path Parameters
database_name
required
string
Example: FinanceDB

The name of the database.

Responses

Response samples

Content type
application/json
{
  • "tables": [
    ]
}