SubscriptionFlow API Reference (1.0.0)

Download OpenAPI specification:Download

E-mail: [email protected] License: Apache 2.0

Developer reference for SubscriptionFlow API

Getting Started

SubscriptionFlow provides an HTTP-based API that follows the principles of REST. The HTTP rules followed allow simple HTTP clients like cURL to be used as well. The URLs are resource-oriented, the request format is form-encoded, and the responses are in JSON.

Depending on the type of operation, the endpoints use one of the following HTTP methods:

  • GET: Used for all read-only operations such as retrieving a resource or listing a group of resources.
  • POST: Used for all create operations. Such operations creates a resource.
  • PUT: Used for all update operations. Such operations modify the state of a resource.
  • DELETE: Used for all remove operations. Such as removing of a resource.

Using Postman for API Testing

We recommend using Postman for seamless testing and interaction with our APIs. To make your testing process even smoother, we have prepared a comprehensive collection of API requests in Postman.

Open In Postman

Click the link above to import our collection into your Postman workspace. This collection includes pre-configured requests for various API endpoints, allowing you to easily explore and test the functionalities of our API.

Authentication

SubscriptionFlow uses authentication tokens for authorization of API requests. Follow these steps to obtain an authentication token:

  1. Client Credentials: To get started, follow our [Client Credentials Guide] (https://support.subscriptionflow.com/hc/en-us/articles/900004667566-How-To-Use-OAuth-Client) to obtain your unique client_id and client_secret from your SubscriptionFlow (SF) instance.

  2. Obtain an Auth Token: Once you have your client_id and client_secret, make a POST request to the OAuth endpoint with these credentials to obtain a bearer token. Your request should include the following:

    • client_id: Your client ID.
    • client_secret: Your client secret.
    • Grant type: Use the "client_credentials" grant type to request an access token.

Example Request

curl --location --request POST 'http://{site}.subscriptionflow.com/oauth/token' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--data-urlencode 'client_id=your_client_id' \
--data-urlencode 'client_secret=your_client_secret' \
--data-urlencode 'grant_type=client_credentials'

Error Handling

SubscriptionFlow API provides error handling capabilities by using standard HTTP error codes and additional helpful parameters in its error responses. This page provides recommendations on effective error handling and a reference for all custom and standard error codes used by the API.

HTTP status codes are used to indicate success or failure of an API call. The body of the response contains the details of the error in JSON format.

The standard http status codes used are

  • 2XX: The response code in this range implies the API call has succeeded.
  • 3XX: This range is not used currently.
  • 4XX: response codes indicate failure due to wrong input (i.e, client) side. As the usable list of http codes in the 4xx range is limited we predominantly use the 400 ( BAD REQUEST ) error code for client-side errors.
  • 5XX: response codes indicate API request was valid but failed due to issues on the SubscriptionFlow server. The 500 ( INTERNAL SERVER ERROR ) error code is used for server-side errors.

Customers

Represents a customer, which can be an individual or organization that subscribes to your products or services. The customer resource associates with subscriptions, card information, and billing addresses. The customer details include their ID, name, contact information, and any custom attributes you'd like to associate with them

Get list of Customers

Retrieves a list of customers added to your SubscriptionFlow instance. The list contains the necessary customer details such as Name, Balance, and the Customer ID. You can use the Customer ID to retrieve the customer details.

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{
}

Store a new Customer

Creates a customer. You can create a customer and then create subscriptions for the customer when required. When creating a customer, you can pass along the billing address and shipping address of the customer. You can also select the auto charge option to automatically charge the customer for the subscription.

Responses

Response samples

Content type
application/json
{}

Retrieve a Customer

Retrieves the details of an existing customer. You need to pass the unique customer ID that was returned upon successful customer creation.

path Parameters
customer_id
required
string

The unique identifier for the customer.

Responses

Response Schema: application/json
object

Response samples

Content type
application/json
{}

Update existing Customer

Updates the specified customer by setting the values of the parameters passed. Any parameters not provided will be left unchanged. For example, if you pass the customer's billing address but not the shipping address, the customer's shipping address will be unaltered.

path Parameters
customer_id
required
string

The unique identifier for the customer.

Request Body schema: application/json
id
any <char> (Id)

The unique identifier for the customer.

parent_id
any <char> (Parent Customer)

The identifier of the parent customer if applicable.

name
any <varchar> (Name)

The name of the customer.

phone_number
any <varchar> (Phone Number)

The customer's contact number.

po_number
any <varchar> (PO Number)

The customer's purchase order number.

legal_entity
any <varchar> (Legal Entity)

The legal entity associated with the customer.

billing_cycle_day
any <varchar> (Billing Cycle Day)

The day of the month when the customer's billing cycle starts.

notes
any <text> (Notes)

Additional information about the customer.

image
any <varchar> (Image)

The URL of an image for the customer.

customer_number
any <varchar> (Customer Number)

The customer's number or ID.

terms
any <varchar> (Terms)

The terms of payment for the customer.

created_at
any <timestamp> (Created At)

The date and time when the customer was created.

updated_at
any <timestamp> (Updated At)

The date and time when the customer was last updated.

deleted_at
any <timestamp> (Deleted At)

The date and time when the customer was deleted.

portal_pass
any <varchar> (Portal Pass)

The customer's portal password.

portal_email
any <varchar> (Portal Email)

The customer's portal email address.

portal_is_enabled
any <tinyint> (Portal Is Enabled)

Indicates whether the customer's portal is enabled.

last_successful_login
any <datetime> (Last Successful Login)

The date and time when the customer last logged in to the portal.

last_failed_login
any <datetime> (Last Failed Login)

The date and time when the customer last failed to log in to the portal.

tax_exempt
any <tinyint> (Tax Exempt)

Indicates whether the customer is exempt from tax.

certificate_id
any <varchar> (Certificate ID)

The customer's tax exemption certificate ID.

certificate_type
any <varchar> (Certificate Type)

The customer's tax exemption certificate type.

issuing_jurisdiction
any <varchar> (Issuing Jurisdiction)

The jurisdiction that issued the customer's tax exemption certificate.

entity_use_code
any <varchar> (Entity Use Code)

The customer's entity use code.

description
any <text> (Description)

The customer's description.

tax_company
any <char> (Tax Company)

The customer's tax company.

vat_id
any <varchar> (VAT ID)

The customer's VAT ID.

last_activity
any <varchar> (Last Activity)

The date and time when the customer was last active.

created_by
any <char> (Created By)

The user who created the customer.

updated_by
any <char> (Updated By)

The user who last updated the customer.

assigned_to
any <char> (Assigned To)

The user who is assigned to the customer.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the customer.

auto_charge
any <tinyint> (Auto Charge)

Indicates whether the customer is automatically charged.

balance
any <number> (Outstanding Balance)

The customer's outstanding balance.

unapplied_amount
any <number> (Unapplied Amount)

The customer's unapplied amount.

billing_address_1
any <text> (Billing Address 1)

The customer's billing address line 1.

billing_address_2
any <text> (Billing Address 2)

The customer's billing address line 2.

billing_city
any <varchar> (Billing City)

The customer's billing address city.

billing_state
any <varchar> (Billing State)

The customer's billing address state.

billing_county
any <varchar> (Billing County)

The customer's billing address county.

billing_postal_code
any <varchar> (Billing Postal Code)

The customer's billing address postal code.

billing_country
any <varchar> (Billing Country)

The customer's billing address country.

shipping_address_1
any <text> (Shipping Address 1)

The customer's shipping address line 1.

shipping_address_2
any <text> (Shipping Address 2)

The customer's shipping address line 2.

shipping_city
any <varchar> (Shipping City)

The customer's shipping address city.

shipping_state
any <varchar> (Shipping State)

The customer's shipping address state.

shipping_county
any <varchar> (Shipping County)

The customer's shipping address county.

shipping_postal_code
any <varchar> (Shipping Postal Code)

The customer's shipping address postal code.

shipping_country
any <varchar> (Shipping Country)

The customer's shipping address country.

data_source
any <char> (Data Source)

The data source of the customer.

Responses

Response Schema: application/json
object

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{}

Delete existing Customer

Remove a specific customer from the database. This operation requires the customer ID to identify and delete the customer.

path Parameters
customer_id
required
string

The unique identifier for the customer.

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Customers

Returns list of Customers with all foreign keys

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the customer.

parent_id
any <char> (Parent Customer)

The identifier of the parent customer if applicable.

name
any <varchar> (Name)

The name of the customer.

phone_number
any <varchar> (Phone Number)

The customer's contact number.

po_number
any <varchar> (PO Number)

The customer's purchase order number.

legal_entity
any <varchar> (Legal Entity)

The legal entity associated with the customer.

billing_cycle_day
any <varchar> (Billing Cycle Day)

The day of the month when the customer's billing cycle starts.

notes
any <text> (Notes)

Additional information about the customer.

image
any <varchar> (Image)

The URL of an image for the customer.

customer_number
any <varchar> (Customer Number)

The customer's number or ID.

terms
any <varchar> (Terms)

The terms of payment for the customer.

created_at
any <timestamp> (Created At)

The date and time when the customer was created.

updated_at
any <timestamp> (Updated At)

The date and time when the customer was last updated.

deleted_at
any <timestamp> (Deleted At)

The date and time when the customer was deleted.

portal_pass
any <varchar> (Portal Pass)

The customer's portal password.

portal_email
any <varchar> (Portal Email)

The customer's portal email address.

portal_is_enabled
any <tinyint> (Portal Is Enabled)

Indicates whether the customer's portal is enabled.

last_successful_login
any <datetime> (Last Successful Login)

The date and time when the customer last logged in to the portal.

last_failed_login
any <datetime> (Last Failed Login)

The date and time when the customer last failed to log in to the portal.

tax_exempt
any <tinyint> (Tax Exempt)

Indicates whether the customer is exempt from tax.

certificate_id
any <varchar> (Certificate ID)

The customer's tax exemption certificate ID.

certificate_type
any <varchar> (Certificate Type)

The customer's tax exemption certificate type.

issuing_jurisdiction
any <varchar> (Issuing Jurisdiction)

The jurisdiction that issued the customer's tax exemption certificate.

entity_use_code
any <varchar> (Entity Use Code)

The customer's entity use code.

description
any <text> (Description)

The customer's description.

tax_company
any <char> (Tax Company)

The customer's tax company.

vat_id
any <varchar> (VAT ID)

The customer's VAT ID.

last_activity
any <varchar> (Last Activity)

The date and time when the customer was last active.

created_by
any <char> (Created By)

The user who created the customer.

updated_by
any <char> (Updated By)

The user who last updated the customer.

assigned_to
any <char> (Assigned To)

The user who is assigned to the customer.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the customer.

auto_charge
any <tinyint> (Auto Charge)

Indicates whether the customer is automatically charged.

balance
any <number> (Outstanding Balance)

The customer's outstanding balance.

unapplied_amount
any <number> (Unapplied Amount)

The customer's unapplied amount.

billing_address_1
any <text> (Billing Address 1)

The customer's billing address line 1.

billing_address_2
any <text> (Billing Address 2)

The customer's billing address line 2.

billing_city
any <varchar> (Billing City)

The customer's billing address city.

billing_state
any <varchar> (Billing State)

The customer's billing address state.

billing_county
any <varchar> (Billing County)

The customer's billing address county.

billing_postal_code
any <varchar> (Billing Postal Code)

The customer's billing address postal code.

billing_country
any <varchar> (Billing Country)

The customer's billing address country.

shipping_address_1
any <text> (Shipping Address 1)

The customer's shipping address line 1.

shipping_address_2
any <text> (Shipping Address 2)

The customer's shipping address line 2.

shipping_city
any <varchar> (Shipping City)

The customer's shipping address city.

shipping_state
any <varchar> (Shipping State)

The customer's shipping address state.

shipping_county
any <varchar> (Shipping County)

The customer's shipping address county.

shipping_postal_code
any <varchar> (Shipping Postal Code)

The customer's shipping address postal code.

shipping_country
any <varchar> (Shipping Country)

The customer's shipping address country.

data_source
any <char> (Data Source)

The data source of the customer.

Response samples

Content type
application/json
{
}

Get related list of Customers

Returns one-to-many list of Customers with related Module

path Parameters
customer_id
required
string

The unique identifier for the customer.

related
required
varchar

The name of the relation you want to link with customers query. hasMany relation name

Responses

Response Schema: application/json
Array of objects

Response samples

Content type
application/json
{
}

Get filtered list of Customers

Returns list of Customers with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the customer.

parent_id
any <char> (Parent Customer)

The identifier of the parent customer if applicable.

name
any <varchar> (Name)

The name of the customer.

phone_number
any <varchar> (Phone Number)

The customer's contact number.

po_number
any <varchar> (PO Number)

The customer's purchase order number.

legal_entity
any <varchar> (Legal Entity)

The legal entity associated with the customer.

billing_cycle_day
any <varchar> (Billing Cycle Day)

The day of the month when the customer's billing cycle starts.

notes
any <text> (Notes)

Additional information about the customer.

image
any <varchar> (Image)

The URL of an image for the customer.

customer_number
any <varchar> (Customer Number)

The customer's number or ID.

terms
any <varchar> (Terms)

The terms of payment for the customer.

created_at
any <timestamp> (Created At)

The date and time when the customer was created.

updated_at
any <timestamp> (Updated At)

The date and time when the customer was last updated.

deleted_at
any <timestamp> (Deleted At)

The date and time when the customer was deleted.

portal_pass
any <varchar> (Portal Pass)

The customer's portal password.

portal_email
any <varchar> (Portal Email)

The customer's portal email address.

portal_is_enabled
any <tinyint> (Portal Is Enabled)

Indicates whether the customer's portal is enabled.

last_successful_login
any <datetime> (Last Successful Login)

The date and time when the customer last logged in to the portal.

last_failed_login
any <datetime> (Last Failed Login)

The date and time when the customer last failed to log in to the portal.

tax_exempt
any <tinyint> (Tax Exempt)

Indicates whether the customer is exempt from tax.

certificate_id
any <varchar> (Certificate ID)

The customer's tax exemption certificate ID.

certificate_type
any <varchar> (Certificate Type)

The customer's tax exemption certificate type.

issuing_jurisdiction
any <varchar> (Issuing Jurisdiction)

The jurisdiction that issued the customer's tax exemption certificate.

entity_use_code
any <varchar> (Entity Use Code)

The customer's entity use code.

description
any <text> (Description)

The customer's description.

tax_company
any <char> (Tax Company)

The customer's tax company.

vat_id
any <varchar> (VAT ID)

The customer's VAT ID.

last_activity
any <varchar> (Last Activity)

The date and time when the customer was last active.

created_by
any <char> (Created By)

The user who created the customer.

updated_by
any <char> (Updated By)

The user who last updated the customer.

assigned_to
any <char> (Assigned To)

The user who is assigned to the customer.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the customer.

auto_charge
any <tinyint> (Auto Charge)

Indicates whether the customer is automatically charged.

balance
any <number> (Outstanding Balance)

The customer's outstanding balance.

unapplied_amount
any <number> (Unapplied Amount)

The customer's unapplied amount.

billing_address_1
any <text> (Billing Address 1)

The customer's billing address line 1.

billing_address_2
any <text> (Billing Address 2)

The customer's billing address line 2.

billing_city
any <varchar> (Billing City)

The customer's billing address city.

billing_state
any <varchar> (Billing State)

The customer's billing address state.

billing_county
any <varchar> (Billing County)

The customer's billing address county.

billing_postal_code
any <varchar> (Billing Postal Code)

The customer's billing address postal code.

billing_country
any <varchar> (Billing Country)

The customer's billing address country.

shipping_address_1
any <text> (Shipping Address 1)

The customer's shipping address line 1.

shipping_address_2
any <text> (Shipping Address 2)

The customer's shipping address line 2.

shipping_city
any <varchar> (Shipping City)

The customer's shipping address city.

shipping_state
any <varchar> (Shipping State)

The customer's shipping address state.

shipping_county
any <varchar> (Shipping County)

The customer's shipping address county.

shipping_postal_code
any <varchar> (Shipping Postal Code)

The customer's shipping address postal code.

shipping_country
any <varchar> (Shipping Country)

The customer's shipping address country.

data_source
any <char> (Data Source)

The data source of the customer.

Response samples

Content type
application/json
{
}

Filter Customer with nested conditions

Returns filtered Customer data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Customers

Returns deleted Customers data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Get list of Email Addresses

Retrieve a list of all email addresses stored in the system. This endpoint returns an overview of each email address, including associated details.

Responses

Response Schema: application/json
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Response samples

Content type
application/json
{
}

Store a new EmailAddress

Create and save a new email address in the system. Provide necessary details in the request body to successfully register the new email address.

Request Body schema: application/json
required
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get EmailAddress information

Retrieve detailed information about a specific email address. This operation requires the email address ID to fetch and display the relevant data.

path Parameters
email-address
required
char

EmailAddress id

Responses

Response Schema: application/json
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Response samples

Content type
application/json
{
}

Update existing EmailAddress

Modify the details of an existing email address. Provide the email address ID and updated information in the request body to apply changes.

path Parameters
email-address
required
char

EmailAddress id

Request Body schema: application/json
required
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Responses

Response Schema: application/json
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing EmailAddress

Permanently remove a specific email address from the system. This operation requires the email address ID to identify and delete the record.

path Parameters
email-address
required
char

EmailAddress id

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Customers

Returns list of Customers with all foreign keys

Responses

Response Schema: application/json
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Response samples

Content type
application/json
{
}

Get related list of Customers

Returns one-to-many list of Customers with related Module

path Parameters
id
required
char

EmailAddress id

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Response samples

Content type
application/json
{
}

Get filtered list of Customers

Returns list of Customers with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
email
any <varchar> (Email)

email

primary
any <tinyint> (Primary)

primary

invalid
any <tinyint> (Invalid)

invalid

opt_out
any <tinyint> (Opt Out)

opt_out

Response samples

Content type
application/json
{
}

Filter EmailAddress with nested conditions

Returns filtered EmailAddress data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Customers

Returns deleted Customers data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Contacts

A contact is a person associated with a customer. The contact details include the contact ID, name, email, phone, and status.

Get list of Contacts

Retrieves a list of contacts added to your SubscriptionFlow instance. The list contains the necessary contact details such as Name, Balance, and the Contact ID. You can use the Contact ID to retrieve the contact details.

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Response samples

Content type
application/json
{
}

Store a new Contact

Creates a contact. You can create a contact and then create subscriptions for the contact when required. When creating a contact, you can pass along the billing address and shipping address of the contact.

Request Body schema: application/json
required
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Contact information

Retrieves the details of an existing contact. You need to pass the unique contact ID that was returned upon successful contact creation.

path Parameters
contact
required
char

Contact id

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Response samples

Content type
application/json
{
}

Update existing Contact

Updates the specified contact by setting the values of the parameters passed. Any parameters not provided will be left unchanged. For example, if you pass the contact's billing address but not the shipping address, the contact's shipping address will be unaltered.

path Parameters
contact
required
char

Contact id

Request Body schema: application/json
required
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Contact

Deletes a record and returns deleted record

path Parameters
contact
required
char

Contact id

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Contacts

Returns list of Contacts with all foreign keys

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Response samples

Content type
application/json
{
}

Get related list of Contacts

Returns one-to-many list of Contacts with related Module

path Parameters
id
required
char

Contact id

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Response samples

Content type
application/json
{
}

Get filtered list of Contacts

Returns list of Contacts with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the contact.

customer_id
any <char> (Customer)

The identifier of the customer.

salutation
any <varchar> (Salutation)

The salutation of the contact.

first_name
any <varchar> (First Name)

The first name of the contact.

last_name
any <varchar> (Last Name)

The last name of the contact.

name
any <varchar> (Name)

The name of the contact.

email
any <varchar> (Email)

The email address of the contact.

work_phone
any <varchar> (Work Phone)

The work phone number of the contact.

personal_phone
any <varchar> (Personal Phone)

The personal phone number of the contact.

home_phone
any <varchar> (Home Phone)

The home phone number of the contact.

other_phone
any <varchar> (Other Phone)

The other phone number of the contact.

fax
any <varchar> (Fax)

The fax number of the contact.

description
any <text> (Description)

The description of the contact.

is_primary
any <tinyint> (Is Primary)

The primary contact of the customer.

created_at
any <timestamp> (Created At)

The date and time when the contact was created.

updated_at
any <timestamp> (Updated At)

The date and time when the contact was last updated.

created_by
any <char> (Created By)

The user who created the contact.

updated_by
any <char> (Updated By)

The user who last updated the contact.

assigned_to
any <char> (Assigned To)

The user who the contact is assigned to.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group who the contact is assigned to.

billing_address_1
any <text> (Billing Address 1)

The billing address of the contact.

billing_address_2
any <text> (Billing Address 2)

The billing address of the contact.

billing_city
any <varchar> (Billing City)

The billing city of the contact.

billing_state
any <varchar> (Billing State)

The billing state of the contact.

billing_county
any <varchar> (Billing County)

The billing county of the contact.

billing_postal_code
any <varchar> (Billing Postal Code)

The billing postal code of the contact.

billing_country
any <varchar> (Billing Country)

The billing country of the contact.

shipping_address_1
any <text> (Shipping Address 1)

The shipping address of the contact.

shipping_address_2
any <text> (Shipping Address 2)

The shipping address of the contact.

shipping_city
any <contacts> (Shipping City)

The shipping city of the contact.

shipping_state
any <varchar> (Shipping State)

The shipping state of the contact.

shipping_county
any <varchar> (Shipping County)

The shipping county of the contact.

shipping_postal_code
any <contacts> (Shipping Postal Code)

The shipping postal code of the contact.

shipping_country
any <varchar> (Shipping Country)

The shipping country of the contact.

data_source
any <char> (Data Source)

The data source of the contact.

Response samples

Content type
application/json
{
}

Filter Contact with nested conditions

Returns filtered Contact data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Contacts

Returns deleted Contacts data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Subscriptions

A SubscriptionFlow subscription connects a customer record to products/services. It describes what the customer has signed up for and how often they're charged for it. The essential components of a subscription are:

  • Any product selected
  • Any plan-item for a product
  • Any coupons applied

Get list of Subscriptions

Retrieve a comprehensive list of all active subscriptions. This endpoint returns detailed information about each subscription.

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{
}

Create a new Subscription

Create and store a new subscription in the database for an existing customer in SubscriptionFlow. Provide necessary subscription details in the request body.

Request Body schema: application/json

This is a sample request body for you to understand what else can be sent in the request body.

id
any <varchar> (Id)

A unique and immutable identifier for the subscription.

customer_id
any <char> (Customer)

Identifier of the customer with whom this subscription is associated.

items
any <array> (Items)

Identifier of the plan and product with whom this subscription is associated.

name
any <varchar> (Name)

The name associated with this subscription.

type
any <varchar> (Type)

The type or category of the subscription.

Possible values are

  • Termed
  • Evergreen
termed_start_date
any <date> (Term Start Date)

The date when the subscription's term starts.

termed_initial_period
any <int> (Term Initial Period)

The initial period of the subscription term.

termed_initial_period_type
any <varchar> (Term Initial Period Type)

The type or unit of the initial period.

Possible values are

  • month
  • week
  • year
  • day
renewal_type
any <varchar> (Renewal Type)

The type of renewal for the subscription.

renewal_period
any <int> (Renewal Period)

The renewal period duration.

renewal_period_type
any <varchar> (Renewal Period Type)

The type or unit of the renewal period.

Possible values are

  • month
  • week
  • year
  • day
is_auto_renew
any <tinyint> (Is Auto Renew)

Indicates whether the subscription auto-renews (1 for yes, 0 for no).

trigger_dates
any <date> (Trigger Dates)

Dates or events that trigger actions related to the subscription.

invoice_separate
any <date> (Invoice the Subscription Separately)

Indicates if the subscription is separately invoiced (1 for yes, 0 for no).

total_amount
any <double> (Total Amount)

The total amount associated with the subscription's plan-items.

Note: The total_amount value would be 0 (zero) if subscription "type" is evergreen

status
any <varchar> (Status)

The current state of the subscription (e.g., active, suspended).

Possible values are

  1. active

    The subscription is active and in service.

  2. pending

    The subscription is pending activation.

  3. draft

    The subscription is in draft mode.

  4. trial

    The subscription is in trial mode.

  5. suspended

    The subscription is suspended. The subscription will not renew while in this state.

  6. cancelled

    The subscription has been canceled and is no longer in service.

  7. expired

    The subscription has expired and is no longer in service.

payment_status
any <varchar> (Payment Status)

The payment status of the subscription (e.g., pending, paid).

created_at
any <timestamp> (Created At)

The date and time when the subscription was created.

suspended_at
any <timestamp> (Suspended At)

The date and time when the subscription was suspended.

cancelled_at
any <timestamp> (Cancelled At)

The date and time when the subscription was cancelled.

billing_end_date
any <date> (Billing End Date)

The date when billing for the subscription ends.

updated_at
any <timestamp> (Updated At)

The date and time when the subscription was last updated.

created_by
any <char> (Created By)

The identifier of the user who created the subscription.

updated_by
any <char> (Updated By)

The identifier of the user who last updated the subscription.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the subscription is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the subscription is assigned.

data_source
any <char> (Data Source)

The source of data for the subscription.

trial_period
any <int> (Trial Period)

The duration of the trial period.

trial_period_unit
any <varchar> (Trial Period Unit)

The unit of the trial period duration.

Possible values are

  • days
  • months
is_gift
any <tinyint> (Gift Subscription)

Indicates if the subscription is a gift (1 for yes, 0 for no).

recipient_id
any <char> (Gift Recipient)

The identifier of the recipient of the gift subscription.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Subscription information

Retrieve detailed information about a specific subscription. This endpoint requires the subscription ID to fetch the relevant data.

path Parameters
subscription_id
required
string

The unique identifier of subscription

Responses

Response Schema: application/json
object
object
object

Response samples

Content type
application/json
{
}

Update existing Subscription

Modify the details of an existing subscription. Provide the subscription ID and updated information in the request body.

path Parameters
subscription_id
required
string

The unique identifier of subscription

Request Body schema: application/json
required
id
any <varchar> (Id)

A unique and immutable identifier for the subscription.

customer_id
any <char> (Customer)

Identifier of the customer with whom this subscription is associated.

items
any <array> (Items)

Identifier of the plan and product with whom this subscription is associated.

name
any <varchar> (Name)

The name associated with this subscription.

type
any <varchar> (Type)

The type or category of the subscription.

Possible values are

  • Termed
  • Evergreen
termed_start_date
any <date> (Term Start Date)

The date when the subscription's term starts.

termed_initial_period
any <int> (Term Initial Period)

The initial period of the subscription term.

termed_initial_period_type
any <varchar> (Term Initial Period Type)

The type or unit of the initial period.

Possible values are

  • month
  • week
  • year
  • day
renewal_type
any <varchar> (Renewal Type)

The type of renewal for the subscription.

renewal_period
any <int> (Renewal Period)

The renewal period duration.

renewal_period_type
any <varchar> (Renewal Period Type)

The type or unit of the renewal period.

Possible values are

  • month
  • week
  • year
  • day
is_auto_renew
any <tinyint> (Is Auto Renew)

Indicates whether the subscription auto-renews (1 for yes, 0 for no).

trigger_dates
any <date> (Trigger Dates)

Dates or events that trigger actions related to the subscription.

invoice_separate
any <date> (Invoice the Subscription Separately)

Indicates if the subscription is separately invoiced (1 for yes, 0 for no).

total_amount
any <double> (Total Amount)

The total amount associated with the subscription's plan-items.

Note: The total_amount value would be 0 (zero) if subscription "type" is evergreen

status
any <varchar> (Status)

The current state of the subscription (e.g., active, suspended).

Possible values are

  1. active

    The subscription is active and in service.

  2. pending

    The subscription is pending activation.

  3. draft

    The subscription is in draft mode.

  4. trial

    The subscription is in trial mode.

  5. suspended

    The subscription is suspended. The subscription will not renew while in this state.

  6. cancelled

    The subscription has been canceled and is no longer in service.

  7. expired

    The subscription has expired and is no longer in service.

payment_status
any <varchar> (Payment Status)

The payment status of the subscription (e.g., pending, paid).

created_at
any <timestamp> (Created At)

The date and time when the subscription was created.

suspended_at
any <timestamp> (Suspended At)

The date and time when the subscription was suspended.

cancelled_at
any <timestamp> (Cancelled At)

The date and time when the subscription was cancelled.

billing_end_date
any <date> (Billing End Date)

The date when billing for the subscription ends.

updated_at
any <timestamp> (Updated At)

The date and time when the subscription was last updated.

created_by
any <char> (Created By)

The identifier of the user who created the subscription.

updated_by
any <char> (Updated By)

The identifier of the user who last updated the subscription.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the subscription is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the subscription is assigned.

data_source
any <char> (Data Source)

The source of data for the subscription.

trial_period
any <int> (Trial Period)

The duration of the trial period.

trial_period_unit
any <varchar> (Trial Period Unit)

The unit of the trial period duration.

Possible values are

  • days
  • months
is_gift
any <tinyint> (Gift Subscription)

Indicates if the subscription is a gift (1 for yes, 0 for no).

recipient_id
any <char> (Gift Recipient)

The identifier of the recipient of the gift subscription.

Responses

Response Schema: application/json
object
object
object

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Subscription

Remove a specific subscription from the database. This operation requires the subscription ID to identify and delete the subscription.

path Parameters
subscription_id
required
string

The unique identifier of subscription

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Subscriptions

Returns list of Subscriptions with all foreign keys

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the subscription.

customer_id
any <char> (Customer)

Identifier of the customer with whom this subscription is associated.

items
any <array> (Items)

Identifier of the plan and product with whom this subscription is associated.

name
any <varchar> (Name)

The name associated with this subscription.

type
any <varchar> (Type)

The type or category of the subscription.

Possible values are

  • Termed
  • Evergreen
termed_start_date
any <date> (Term Start Date)

The date when the subscription's term starts.

termed_initial_period
any <int> (Term Initial Period)

The initial period of the subscription term.

termed_initial_period_type
any <varchar> (Term Initial Period Type)

The type or unit of the initial period.

Possible values are

  • month
  • week
  • year
  • day
renewal_type
any <varchar> (Renewal Type)

The type of renewal for the subscription.

renewal_period
any <int> (Renewal Period)

The renewal period duration.

renewal_period_type
any <varchar> (Renewal Period Type)

The type or unit of the renewal period.

Possible values are

  • month
  • week
  • year
  • day
is_auto_renew
any <tinyint> (Is Auto Renew)

Indicates whether the subscription auto-renews (1 for yes, 0 for no).

trigger_dates
any <date> (Trigger Dates)

Dates or events that trigger actions related to the subscription.

invoice_separate
any <date> (Invoice the Subscription Separately)

Indicates if the subscription is separately invoiced (1 for yes, 0 for no).

total_amount
any <double> (Total Amount)

The total amount associated with the subscription's plan-items.

Note: The total_amount value would be 0 (zero) if subscription "type" is evergreen

status
any <varchar> (Status)

The current state of the subscription (e.g., active, suspended).

Possible values are

  1. active

    The subscription is active and in service.

  2. pending

    The subscription is pending activation.

  3. draft

    The subscription is in draft mode.

  4. trial

    The subscription is in trial mode.

  5. suspended

    The subscription is suspended. The subscription will not renew while in this state.

  6. cancelled

    The subscription has been canceled and is no longer in service.

  7. expired

    The subscription has expired and is no longer in service.

payment_status
any <varchar> (Payment Status)

The payment status of the subscription (e.g., pending, paid).

created_at
any <timestamp> (Created At)

The date and time when the subscription was created.

suspended_at
any <timestamp> (Suspended At)

The date and time when the subscription was suspended.

cancelled_at
any <timestamp> (Cancelled At)

The date and time when the subscription was cancelled.

billing_end_date
any <date> (Billing End Date)

The date when billing for the subscription ends.

updated_at
any <timestamp> (Updated At)

The date and time when the subscription was last updated.

created_by
any <char> (Created By)

The identifier of the user who created the subscription.

updated_by
any <char> (Updated By)

The identifier of the user who last updated the subscription.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the subscription is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the subscription is assigned.

data_source
any <char> (Data Source)

The source of data for the subscription.

trial_period
any <int> (Trial Period)

The duration of the trial period.

trial_period_unit
any <varchar> (Trial Period Unit)

The unit of the trial period duration.

Possible values are

  • days
  • months
is_gift
any <tinyint> (Gift Subscription)

Indicates if the subscription is a gift (1 for yes, 0 for no).

recipient_id
any <char> (Gift Recipient)

The identifier of the recipient of the gift subscription.

Response samples

Content type
application/json
{
}

Get related list of Subscriptions

Returns one-to-many list of Subscriptions with related Module

path Parameters
subscription_id
required
string

The unique identifier of subscription

related
required
varchar

The name of the relation you want to link with subscription query. hasMany relation name

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the subscription.

customer_id
any <char> (Customer)

Identifier of the customer with whom this subscription is associated.

items
any <array> (Items)

Identifier of the plan and product with whom this subscription is associated.

name
any <varchar> (Name)

The name associated with this subscription.

type
any <varchar> (Type)

The type or category of the subscription.

Possible values are

  • Termed
  • Evergreen
termed_start_date
any <date> (Term Start Date)

The date when the subscription's term starts.

termed_initial_period
any <int> (Term Initial Period)

The initial period of the subscription term.

termed_initial_period_type
any <varchar> (Term Initial Period Type)

The type or unit of the initial period.

Possible values are

  • month
  • week
  • year
  • day
renewal_type
any <varchar> (Renewal Type)

The type of renewal for the subscription.

renewal_period
any <int> (Renewal Period)

The renewal period duration.

renewal_period_type
any <varchar> (Renewal Period Type)

The type or unit of the renewal period.

Possible values are

  • month
  • week
  • year
  • day
is_auto_renew
any <tinyint> (Is Auto Renew)

Indicates whether the subscription auto-renews (1 for yes, 0 for no).

trigger_dates
any <date> (Trigger Dates)

Dates or events that trigger actions related to the subscription.

invoice_separate
any <date> (Invoice the Subscription Separately)

Indicates if the subscription is separately invoiced (1 for yes, 0 for no).

total_amount
any <double> (Total Amount)

The total amount associated with the subscription's plan-items.

Note: The total_amount value would be 0 (zero) if subscription "type" is evergreen

status
any <varchar> (Status)

The current state of the subscription (e.g., active, suspended).

Possible values are

  1. active

    The subscription is active and in service.

  2. pending

    The subscription is pending activation.

  3. draft

    The subscription is in draft mode.

  4. trial

    The subscription is in trial mode.

  5. suspended

    The subscription is suspended. The subscription will not renew while in this state.

  6. cancelled

    The subscription has been canceled and is no longer in service.

  7. expired

    The subscription has expired and is no longer in service.

payment_status
any <varchar> (Payment Status)

The payment status of the subscription (e.g., pending, paid).

created_at
any <timestamp> (Created At)

The date and time when the subscription was created.

suspended_at
any <timestamp> (Suspended At)

The date and time when the subscription was suspended.

cancelled_at
any <timestamp> (Cancelled At)

The date and time when the subscription was cancelled.

billing_end_date
any <date> (Billing End Date)

The date when billing for the subscription ends.

updated_at
any <timestamp> (Updated At)

The date and time when the subscription was last updated.

created_by
any <char> (Created By)

The identifier of the user who created the subscription.

updated_by
any <char> (Updated By)

The identifier of the user who last updated the subscription.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the subscription is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the subscription is assigned.

data_source
any <char> (Data Source)

The source of data for the subscription.

trial_period
any <int> (Trial Period)

The duration of the trial period.

trial_period_unit
any <varchar> (Trial Period Unit)

The unit of the trial period duration.

Possible values are

  • days
  • months
is_gift
any <tinyint> (Gift Subscription)

Indicates if the subscription is a gift (1 for yes, 0 for no).

recipient_id
any <char> (Gift Recipient)

The identifier of the recipient of the gift subscription.

Response samples

Content type
application/json
{
}

Get filtered list of Subscriptions

Returns list of Subscriptions with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the subscription.

customer_id
any <char> (Customer)

Identifier of the customer with whom this subscription is associated.

items
any <array> (Items)

Identifier of the plan and product with whom this subscription is associated.

name
any <varchar> (Name)

The name associated with this subscription.

type
any <varchar> (Type)

The type or category of the subscription.

Possible values are

  • Termed
  • Evergreen
termed_start_date
any <date> (Term Start Date)

The date when the subscription's term starts.

termed_initial_period
any <int> (Term Initial Period)

The initial period of the subscription term.

termed_initial_period_type
any <varchar> (Term Initial Period Type)

The type or unit of the initial period.

Possible values are

  • month
  • week
  • year
  • day
renewal_type
any <varchar> (Renewal Type)

The type of renewal for the subscription.

renewal_period
any <int> (Renewal Period)

The renewal period duration.

renewal_period_type
any <varchar> (Renewal Period Type)

The type or unit of the renewal period.

Possible values are

  • month
  • week
  • year
  • day
is_auto_renew
any <tinyint> (Is Auto Renew)

Indicates whether the subscription auto-renews (1 for yes, 0 for no).

trigger_dates
any <date> (Trigger Dates)

Dates or events that trigger actions related to the subscription.

invoice_separate
any <date> (Invoice the Subscription Separately)

Indicates if the subscription is separately invoiced (1 for yes, 0 for no).

total_amount
any <double> (Total Amount)

The total amount associated with the subscription's plan-items.

Note: The total_amount value would be 0 (zero) if subscription "type" is evergreen

status
any <varchar> (Status)

The current state of the subscription (e.g., active, suspended).

Possible values are

  1. active

    The subscription is active and in service.

  2. pending

    The subscription is pending activation.

  3. draft

    The subscription is in draft mode.

  4. trial

    The subscription is in trial mode.

  5. suspended

    The subscription is suspended. The subscription will not renew while in this state.

  6. cancelled

    The subscription has been canceled and is no longer in service.

  7. expired

    The subscription has expired and is no longer in service.

payment_status
any <varchar> (Payment Status)

The payment status of the subscription (e.g., pending, paid).

created_at
any <timestamp> (Created At)

The date and time when the subscription was created.

suspended_at
any <timestamp> (Suspended At)

The date and time when the subscription was suspended.

cancelled_at
any <timestamp> (Cancelled At)

The date and time when the subscription was cancelled.

billing_end_date
any <date> (Billing End Date)

The date when billing for the subscription ends.

updated_at
any <timestamp> (Updated At)

The date and time when the subscription was last updated.

created_by
any <char> (Created By)

The identifier of the user who created the subscription.

updated_by
any <char> (Updated By)

The identifier of the user who last updated the subscription.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the subscription is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the subscription is assigned.

data_source
any <char> (Data Source)

The source of data for the subscription.

trial_period
any <int> (Trial Period)

The duration of the trial period.

trial_period_unit
any <varchar> (Trial Period Unit)

The unit of the trial period duration.

Possible values are

  • days
  • months
is_gift
any <tinyint> (Gift Subscription)

Indicates if the subscription is a gift (1 for yes, 0 for no).

recipient_id
any <char> (Gift Recipient)

The identifier of the recipient of the gift subscription.

Response samples

Content type
application/json
{
}

Filter Subscription with nested conditions

Returns filtered Subscription data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Subscriptions

Returns deleted Subscriptions data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Suspend Subscription

Temporarily suspend a specific subscription. This operation requires the subscription ID to identify and suspend the subscription.

path Parameters
subscription_id
required
string

The unique identifier of subscription

Request Body schema: application/x-www-form-urlencoded
required
suspension_option
required
string

The suspension option to use.

Possible values are:

  • Today
  • End of Last Invoice Period
  • Specific Date
  • End of Current Term
date
string <y-m-d>

Date of suspension.

Note: This field is required if suspension_option is set to Specific Date.

Responses

Response samples

Content type
application/json
{
}

Resume Subscription

Reactivate a previously suspended subscription. Provide the subscription ID to resume the subscription.

path Parameters
subscription_id
required
string

The unique identifier of subscription

Request Body schema: application/x-www-form-urlencoded
required
resume_option
required
string

The resume option to use.

Possible values are:

  • Today
  • End of Last Invoice Period
  • Specific Date
  • End of Current Term
date
string <y-m-d>

Date of resume.

Note: This field is required if resume_option is set to Specific Date.

Responses

Response samples

Content type
application/json
{
}

Cancel Subscription

Permanently cancel a specific subscription. This operation requires the subscription ID to identify and cancel the subscription.

path Parameters
subscription_id
required
string

The unique identifier of subscription

Request Body schema: application/x-www-form-urlencoded
required
cancellation_option
required
string

The cancellation option to use.

Possible values are:

  • Today
  • End of Last Invoice Period
  • Specific Date
  • End of Current Term
date
string <y-m-d>

Date of cancellation.

Note: This field is required if cancellation_option is set to Specific Date.

Responses

Response samples

Content type
application/json
{
}

Usages

A usage is a record of a customer's usage of a product or service. The usage details include the usage ID, name, customer ID, subscription ID, charge ID, status, quantity, start date, end date, and description.

Get list of Usages

Retrieve a comprehensive list of all recorded usages. This endpoint returns an overview of each usage entry, including key details and metrics.

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{}

Store a new Usage

Create and record a new usage entry in the system. Provide the necessary details in the request body to successfully log the new usage.

path Parameters
title
string

The title of your note.

description
string

The description of your notes.

noteable_id
string

The noteable_id specifies the ID of the associated object.

noteable_type
string

The noteable_type denotes the type of the associated object (e.g., customers, subscriptions, invoices).

Request Body schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the usage.

name
any <varchar> (Name)

The name associated with this usage. This is the name of the usage item. For example, "Data Usage".

customer_id
any <varchar> (Customer)

Identifier of the customer with whom this usage is associated.

subscription_id
any <varchar> (Subscription)

Identifier of the subscription with which this usage is associated.

charge_id
any <varchar> (Charge)

Identifier of the charge with which this usage is associated.

status
any <varchar> (Status)

The current state of the usage (e.g., processed)

quantity
any <double> (Quantity)

The quantity of the usage.

start_date
any <date> (Start Date)

The date when the usage starts.

end_date
any <date> (End Date)

The date when the usage ends.

description
any <text> (Description)

The description of the usage.

created_at
any <datetime> (Created At)

The date and time when the usage was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the usage is assigned.

data_source
any <char> (Data Source)

The source of data for the usage.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Usage information

Retrieve detailed information about a specific usage entry. This operation requires the usage ID to fetch and display the relevant usage data.

path Parameters
usage_id
required
string

The unique identifier of usage

Responses

Response Schema: application/json
object

Response samples

Content type
application/json
{}

Update existing Usage

Modify the details of an existing usage entry. Provide the usage ID and updated information in the request body to apply the changes.

path Parameters
usage_id
required
string

The unique identifier of usage

Request Body schema: application/json
required
id
any <varchar> (Id)

A unique and immutable identifier for the usage.

name
any <varchar> (Name)

The name associated with this usage. This is the name of the usage item. For example, "Data Usage".

customer_id
any <varchar> (Customer)

Identifier of the customer with whom this usage is associated.

subscription_id
any <varchar> (Subscription)

Identifier of the subscription with which this usage is associated.

charge_id
any <varchar> (Charge)

Identifier of the charge with which this usage is associated.

status
any <varchar> (Status)

The current state of the usage (e.g., processed)

quantity
any <double> (Quantity)

The quantity of the usage.

start_date
any <date> (Start Date)

The date when the usage starts.

end_date
any <date> (End Date)

The date when the usage ends.

description
any <text> (Description)

The description of the usage.

created_at
any <datetime> (Created At)

The date and time when the usage was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the usage is assigned.

data_source
any <char> (Data Source)

The source of data for the usage.

Responses

Response Schema: application/json
object

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{}

Delete existing Usage

Permanently remove a specific usage entry from the system. This operation requires the usage ID to identify and delete the usage record.

path Parameters
usage_id
required
string

The unique identifier of usage

Responses

Response samples

Content type
application/json
{}

Get with-relations list of Usages

Returns list of Usages with all foreign keys

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the usage.

name
any <varchar> (Name)

The name associated with this usage. This is the name of the usage item. For example, "Data Usage".

customer_id
any <varchar> (Customer)

Identifier of the customer with whom this usage is associated.

subscription_id
any <varchar> (Subscription)

Identifier of the subscription with which this usage is associated.

charge_id
any <varchar> (Charge)

Identifier of the charge with which this usage is associated.

status
any <varchar> (Status)

The current state of the usage (e.g., processed)

quantity
any <double> (Quantity)

The quantity of the usage.

start_date
any <date> (Start Date)

The date when the usage starts.

end_date
any <date> (End Date)

The date when the usage ends.

description
any <text> (Description)

The description of the usage.

created_at
any <datetime> (Created At)

The date and time when the usage was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the usage is assigned.

data_source
any <char> (Data Source)

The source of data for the usage.

Response samples

Content type
application/json
{
}

Get related list of Usages

Returns one-to-many list of Usages with related Module

path Parameters
usage_id
required
string

The unique identifier of usage

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the usage.

name
any <varchar> (Name)

The name associated with this usage. This is the name of the usage item. For example, "Data Usage".

customer_id
any <varchar> (Customer)

Identifier of the customer with whom this usage is associated.

subscription_id
any <varchar> (Subscription)

Identifier of the subscription with which this usage is associated.

charge_id
any <varchar> (Charge)

Identifier of the charge with which this usage is associated.

status
any <varchar> (Status)

The current state of the usage (e.g., processed)

quantity
any <double> (Quantity)

The quantity of the usage.

start_date
any <date> (Start Date)

The date when the usage starts.

end_date
any <date> (End Date)

The date when the usage ends.

description
any <text> (Description)

The description of the usage.

created_at
any <datetime> (Created At)

The date and time when the usage was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the usage is assigned.

data_source
any <char> (Data Source)

The source of data for the usage.

Response samples

Content type
application/json
{
}

Get filtered list of Usages

Search for usage records based on specific criteria or filters. Use this endpoint to find usages that match given parameters, such as date range or type.

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the usage.

name
any <varchar> (Name)

The name associated with this usage. This is the name of the usage item. For example, "Data Usage".

customer_id
any <varchar> (Customer)

Identifier of the customer with whom this usage is associated.

subscription_id
any <varchar> (Subscription)

Identifier of the subscription with which this usage is associated.

charge_id
any <varchar> (Charge)

Identifier of the charge with which this usage is associated.

status
any <varchar> (Status)

The current state of the usage (e.g., processed)

quantity
any <double> (Quantity)

The quantity of the usage.

start_date
any <date> (Start Date)

The date when the usage starts.

end_date
any <date> (End Date)

The date when the usage ends.

description
any <text> (Description)

The description of the usage.

created_at
any <datetime> (Created At)

The date and time when the usage was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the usage is assigned.

data_source
any <char> (Data Source)

The source of data for the usage.

Response samples

Content type
application/json
{
}

Filter Usage with nested conditions

Returns filtered Usage data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Usages

Returns deleted Usages data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Invoices

An invoice is a document that itemizes a customer's charges for products and services. It is generated at the end of a billing cycle, which can be monthly, quarterly, or yearly. The invoice details include the invoice ID, name, customer ID, invoice date, due date, and total amount.

Get list of Invoices

Retrieve a comprehensive list of all invoices. This endpoint returns a summary of each invoice, including key details and statuses.

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{
}

Store a new Invoice

Create and save a new invoice in the system. Provide the necessary invoice details in the request body to successfully generate and store the invoice.

While creating subscriotion you can add as many LineItems as you want by adding their product and plan id as show in parameters.

Request Body schema: application/json
id
any <char> (Id)

The unique identifier for the invoice.

name
any <varchar> (Invoice Number)

The invoice number.

customer_id
any <char> (Customer)

The identifier of the customer associated with the invoice.

invoice_date
any <datetime> (Invoice Date)

The date when the invoice was issued.

due_date
any <datetime> (Due Date)

The date when the invoice is due.

terms
any <varchar> (Terms)

The terms of payment for the invoice.

status
any <varchar> (Status)

The status of the invoice.

Possible values:

  • draft - The invoice is a draft.
  • due - The invoice is due.
discount_value
any <double> (Discount Value)

The discount value of the invoice.

tax_amount
any <double> (Total Tax)

The total tax amount of the invoice.

total_amount
any <double> (Total Amount)

The total amount of the invoice.

received_payment
any <double> (Received Payment)

The total amount of payments received for the invoice.

sum_of_credit_notes
any <double> (Credit Notes)

The total amount of credit notes applied to the invoice.

reversed_reference
any <varchar> (Reference of Reverse)

The reference of the reverse invoice.

created_at
any <timestamp> (Created At)

The date and time when the invoice was created.

updated_at
any <timestamp> (Updated At)

The date and time when the invoice was last updated.

opening_balance
any <decimal> (Opening Balance)

The opening balance of the invoice.

closing_balance
any <decimal> (Closing Balance)

The closing balance of the invoice.

created_by
any <char> (Created By)

The user who created the invoice.

updated_by
any <char> (Updated By)

The user who last updated the invoice.

assigned_to
any <char> (Assigned To)

The user who is assigned to the invoice.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the invoice.

data_source
any <char> (Data Source)

The data source of the invoice.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Invoice information

Retrieve detailed information about a specific invoice. This operation requires the invoice ID to fetch and display the invoice's data.

path Parameters
invoice_id
required
string

The unique identifier for the invoice.

Responses

Response Schema: application/json
object
object
object

Response samples

Content type
application/json
{
}

Update existing Invoice

Modify the details of an existing invoice. Provide the invoice ID and updated information in the request body to apply changes.

path Parameters
invoice_id
required
string

The unique identifier for the invoice.

Request Body schema: application/json
id
any <char> (Id)

The unique identifier for the invoice.

name
any <varchar> (Invoice Number)

The invoice number.

customer_id
any <char> (Customer)

The identifier of the customer associated with the invoice.

invoice_date
any <datetime> (Invoice Date)

The date when the invoice was issued.

due_date
any <datetime> (Due Date)

The date when the invoice is due.

terms
any <varchar> (Terms)

The terms of payment for the invoice.

status
any <varchar> (Status)

The status of the invoice.

Possible values:

  • draft - The invoice is a draft.
  • due - The invoice is due.
discount_value
any <double> (Discount Value)

The discount value of the invoice.

tax_amount
any <double> (Total Tax)

The total tax amount of the invoice.

total_amount
any <double> (Total Amount)

The total amount of the invoice.

received_payment
any <double> (Received Payment)

The total amount of payments received for the invoice.

sum_of_credit_notes
any <double> (Credit Notes)

The total amount of credit notes applied to the invoice.

reversed_reference
any <varchar> (Reference of Reverse)

The reference of the reverse invoice.

created_at
any <timestamp> (Created At)

The date and time when the invoice was created.

updated_at
any <timestamp> (Updated At)

The date and time when the invoice was last updated.

opening_balance
any <decimal> (Opening Balance)

The opening balance of the invoice.

closing_balance
any <decimal> (Closing Balance)

The closing balance of the invoice.

created_by
any <char> (Created By)

The user who created the invoice.

updated_by
any <char> (Updated By)

The user who last updated the invoice.

assigned_to
any <char> (Assigned To)

The user who is assigned to the invoice.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the invoice.

data_source
any <char> (Data Source)

The data source of the invoice.

Responses

Response Schema: application/json
object
object
object

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Invoice

Permanently remove a specific invoice from the system. This operation requires the invoice ID to identify and delete the invoice.

path Parameters
invoice_id
required
string

The unique identifier for the invoice.

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Invoices

Returns list of Invoices with all foreign keys

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the invoice.

name
any <varchar> (Invoice Number)

The invoice number.

customer_id
any <char> (Customer)

The identifier of the customer associated with the invoice.

invoice_date
any <datetime> (Invoice Date)

The date when the invoice was issued.

due_date
any <datetime> (Due Date)

The date when the invoice is due.

terms
any <varchar> (Terms)

The terms of payment for the invoice.

status
any <varchar> (Status)

The status of the invoice.

Possible values:

  • draft - The invoice is a draft.
  • due - The invoice is due.
discount_value
any <double> (Discount Value)

The discount value of the invoice.

tax_amount
any <double> (Total Tax)

The total tax amount of the invoice.

total_amount
any <double> (Total Amount)

The total amount of the invoice.

received_payment
any <double> (Received Payment)

The total amount of payments received for the invoice.

sum_of_credit_notes
any <double> (Credit Notes)

The total amount of credit notes applied to the invoice.

reversed_reference
any <varchar> (Reference of Reverse)

The reference of the reverse invoice.

created_at
any <timestamp> (Created At)

The date and time when the invoice was created.

updated_at
any <timestamp> (Updated At)

The date and time when the invoice was last updated.

opening_balance
any <decimal> (Opening Balance)

The opening balance of the invoice.

closing_balance
any <decimal> (Closing Balance)

The closing balance of the invoice.

created_by
any <char> (Created By)

The user who created the invoice.

updated_by
any <char> (Updated By)

The user who last updated the invoice.

assigned_to
any <char> (Assigned To)

The user who is assigned to the invoice.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the invoice.

data_source
any <char> (Data Source)

The data source of the invoice.

Response samples

Content type
application/json
{
}

Get related list of Invoices

Returns one-to-many list of Invoices with related Module

path Parameters
invoice_id
required
string

The unique identifier for the invoice.

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
Array of objects

Response samples

Content type
application/json
{
}

Get filtered list of Invoices

Search for invoices based on specific criteria or filters. Use this endpoint to locate invoices that match given parameters, such as date range or status.

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the invoice.

name
any <varchar> (Invoice Number)

The invoice number.

customer_id
any <char> (Customer)

The identifier of the customer associated with the invoice.

invoice_date
any <datetime> (Invoice Date)

The date when the invoice was issued.

due_date
any <datetime> (Due Date)

The date when the invoice is due.

terms
any <varchar> (Terms)

The terms of payment for the invoice.

status
any <varchar> (Status)

The status of the invoice.

Possible values:

  • draft - The invoice is a draft.
  • due - The invoice is due.
discount_value
any <double> (Discount Value)

The discount value of the invoice.

tax_amount
any <double> (Total Tax)

The total tax amount of the invoice.

total_amount
any <double> (Total Amount)

The total amount of the invoice.

received_payment
any <double> (Received Payment)

The total amount of payments received for the invoice.

sum_of_credit_notes
any <double> (Credit Notes)

The total amount of credit notes applied to the invoice.

reversed_reference
any <varchar> (Reference of Reverse)

The reference of the reverse invoice.

created_at
any <timestamp> (Created At)

The date and time when the invoice was created.

updated_at
any <timestamp> (Updated At)

The date and time when the invoice was last updated.

opening_balance
any <decimal> (Opening Balance)

The opening balance of the invoice.

closing_balance
any <decimal> (Closing Balance)

The closing balance of the invoice.

created_by
any <char> (Created By)

The user who created the invoice.

updated_by
any <char> (Updated By)

The user who last updated the invoice.

assigned_to
any <char> (Assigned To)

The user who is assigned to the invoice.

assigned_group_id
any <char> (Assigned Group)

The group that is assigned to the invoice.

data_source
any <char> (Data Source)

The data source of the invoice.

Response samples

Content type
application/json
{
}

Filter Invoice with nested conditions

Returns filtered Invoice data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Invoices

Returns deleted Invoices data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Transactions

A transaction is a record of a payment that has been processed for a customer. The transaction details include the transaction ID, name, customer ID, transaction date, status, amount, and payment method.

The transaction status can be one of the following:

  • Paid: The transaction is paid.
  • Failed: The transaction failed.
  • Pending: The transaction is pending.
  • Declined: The transaction is declined.
  • Processing: The transaction is processing.

Get list of Transactions

Retrieve a comprehensive list of all transactions. This endpoint returns a summary of each transaction, including key details and statuses.

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Response samples

Content type
application/json
{
}

Store a new Transaction

Create and record a new transaction in the system. Provide the necessary details in the request body to successfully log the new transaction.

Request Body schema: application/json
required
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Transaction information

Retrieve detailed information about a specific transaction. This operation requires the transaction ID to fetch and display the relevant data.

path Parameters
transaction
required
char

Transaction id

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Response samples

Content type
application/json
{
}

Update existing Transaction

Modify the details of an existing transaction. Provide the transaction ID and updated information in the request body to apply changes.

path Parameters
transaction
required
char

Transaction id

Request Body schema: application/json
required
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Transaction

Permanently remove a specific transaction from the system. This operation requires the transaction ID to identify and delete the transaction record.

path Parameters
transaction
required
char

Transaction id

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Transactions

Returns list of Transactions with all foreign keys

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Response samples

Content type
application/json
{
}

Get related list of Transactions

Returns one-to-many list of Transactions with related Module

path Parameters
id
required
char

Transaction id

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Response samples

Content type
application/json
{
}

Get filtered list of Transactions

Returns list of Transactions with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the transaction.

name
any <varchar> (Name)

The name associated with this transaction.

date
any <date> (Date)

The date when the transaction was created.

status
any <varchar> (Status)

The status of the transaction.

Possible values are

  • success - The transaction was successful.
  • pending - The transaction is pending.
  • failed - The transaction failed.
amount
any <double> (Amount)

The amount of the transaction.

unapplied_amount
any <double> (Unapplied Amount)

The unapplied amount of the transaction.

balance
any <double> (Balance)

The balance of the transaction.

number
any <varchar> (Transaction ID)

The unique identifier of the transaction.

api_response
any <varchar> (API Response)

The API response of the transaction.

payment_type_id
any <varchar> (Payment Method)

The identifier of the payment method associated with the transaction.

payment_method_id
any <varchar> (Payment Method ID)

The identifier of the payment method associated with the transaction.

cash_or_card
any <varchar> (Payment Source)

The payment source of the transaction.

Possible values are

  • cash - The transaction was paid in cash.
  • card - The transaction was paid by card.
customer_id
any <varchar> (Customer)

The identifier of the customer associated with the transaction.

type
any <varchar> (Type)

The type of the transaction.

transaction_category
any <varchar> (Transaction Category)

The category of the transaction.

reference
any <varchar> (Reference)

The reference of the transaction.

description
any <text> (Description)

The description of the transaction.

transaction_id
any <varchar> (Unique Transaction Number)

The unique transaction number of the transaction.

reference_transaction_id
any <varchar> (Reference Transaction Id)

The identifier of the reference transaction.

decline_reason
any <text> (Declined Reason)

The reason for the transaction decline.

accounting_account_code
any <varchar> (Account Code)

The accounting account code of the transaction.

created_at
any <timestamp> (Created At)

The date and time when the transaction was created.

assigned_to
any <char> (Assigned To)

The identifier of the user to whom the transaction is assigned.

assigned_group_id
any <char> (Assigned Group)

The identifier of the group to which the transaction is assigned.

data_source
any <char> (Data Source)

The source of data for the transaction.

Response samples

Content type
application/json
{
}

Filter Transaction with nested conditions

Returns filtered Transaction data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Transactions

Returns deleted Transactions data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Products

A product is a good or service that you sell to your customers. The product details include the product ID, name, type, description, SKU, effective start date, effective end date, and status. Product have line items called plan-items that define the billing details for the product.

Possible values for product type are

  • Base Product: A product that is sold as a standalone item.
  • Addon Service: A product that is sold as an add-on to a base product.
  • Miscellaneous Product: A product that is sold as a one-time item.

Possible values for product status are

  • Active: The product is active.
  • Inactive: The product is inactive.

Get list of Products

Retrieve a comprehensive list of all available products. This endpoint returns detailed information about each product.

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{
}

Store a new Product

Create and store a new product in the database. Provide necessary product details in the request body.

Request Body schema: application/json
id
string
name
string
description
string
sku
string
effective_start_date
string <date-time>
effective_end_date
string <date-time>
type
string
manager_id
string
status
string
image
string <uri>
created_at
string <date-time>
updated_at
string <date-time>
created_by
string
updated_by
string
assigned_to
string
data_source
string

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Product information

Retrieve detailed information about a specific product. This endpoint requires the product ID to fetch the relevant data.

path Parameters
product_id
required
string

Identifier of the product.

Responses

Response Schema: application/json
object

Response samples

Content type
application/json
{
}

Update existing Product

Modify the details of an existing product. Provide the product ID and updated information in the request body.

path Parameters
product_id
required
string

Identifier of the product.

Request Body schema: application/json
required
Array of objects
object
object

Responses

Response Schema: application/json
object

Request samples

Content type
application/json
{}

Response samples

Content type
application/json
{
}

Delete existing Product

Remove a specific product from the database. This operation requires the product ID to identify and delete the product.

path Parameters
product_id
required
string

Identifier of the product.

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Products

Returns list of Products with all foreign keys

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{}

Get related list of Products

Returns one-to-many list of Products with related Module

path Parameters
product_id
required
string

Identifier of the product.

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{}

Get filtered list of Products

Returns list of Products with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{}

Filter Product with nested conditions

Returns filtered Product data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Products

Returns deleted Products data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{}

Plans

A plan is a set of billing details for a product. The plan details include the plan ID, name, description, effective start date, effective end date, and status. Plans have line items called plan-items that define the billing details for the plan.

Possible values for plan status are

  • Active: The plan is active.
  • Inactive: The plan is inactive.

Note: A plan can be associated with multiple products.

Get list of Plans

Retrieve a list of all available plans. This endpoint returns a summary of each plan, including key details and statuses.

Responses

Response Schema: application/json
Array of objects
object
object

Response samples

Content type
application/json
{
}

Store a new Plan

Create and save a new plan in the system. Provide all required plan details in the request body to successfully register the new plan.

Request Body schema: application/json
id
any <char> (Id)

The unique identifier for the plan.

name
any <varchar> (Name)

The name of the plan.

description
any <text> (Description)

The description of the plan.

effective_start_date
any <datetime> (Effective Start Date)

The date when the plan becomes effective. The plan is available for purchase starting from this date.

effective_end_date
any <datetime> (Effective End Date)

The date when the plan expires. The plan is no longer available for purchase starting from this date.

status
any <varchar> (Status)

The status of the plan.

Possible values:

  • active - The plan is active.
  • inactive - The plan is inactive.
created_at
any <timestamp> (Created At)

The date and time when the plan was created.

updated_at
any <timestamp> (Updated At)

The date and time when the plan was last updated.

created_by
any <char> (Created By)

The user who created the plan.

updated_by
any <char> (Updated By)

The user who last updated the plan.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan.

data_source
any <char> (Data Source)

The data source of the plan.

is_gift
any <tinyint> (Is Gift Plan)

Indicates whether the plan is a gift plan.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Plan information

Retrieve detailed information about a specific plan. This operation requires the plan ID to fetch and display the plan's data.

path Parameters
plan_id
required
string

The unique identifier of plan

Responses

Response Schema: application/json
object
object
object

Response samples

Content type
application/json
{
}

Update existing Plan

Modify the details of an existing plan. Provide the plan ID and updated information in the request body to apply changes.

path Parameters
plan_id
required
string

The unique identifier of plan

Request Body schema: application/json
required
id
any <char> (Id)

The unique identifier for the plan.

name
any <varchar> (Name)

The name of the plan.

description
any <text> (Description)

The description of the plan.

effective_start_date
any <datetime> (Effective Start Date)

The date when the plan becomes effective. The plan is available for purchase starting from this date.

effective_end_date
any <datetime> (Effective End Date)

The date when the plan expires. The plan is no longer available for purchase starting from this date.

status
any <varchar> (Status)

The status of the plan.

Possible values:

  • active - The plan is active.
  • inactive - The plan is inactive.
created_at
any <timestamp> (Created At)

The date and time when the plan was created.

updated_at
any <timestamp> (Updated At)

The date and time when the plan was last updated.

created_by
any <char> (Created By)

The user who created the plan.

updated_by
any <char> (Updated By)

The user who last updated the plan.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan.

data_source
any <char> (Data Source)

The data source of the plan.

is_gift
any <tinyint> (Is Gift Plan)

Indicates whether the plan is a gift plan.

Responses

Response Schema: application/json
object
object
object

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Plan

Permanently remove a specific plan from the system. This operation requires the plan ID to identify and delete the plan.

path Parameters
plan_id
required
string

The unique identifier of plan

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Plans

Returns list of Plans with all foreign keys

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the plan.

name
any <varchar> (Name)

The name of the plan.

description
any <text> (Description)

The description of the plan.

effective_start_date
any <datetime> (Effective Start Date)

The date when the plan becomes effective. The plan is available for purchase starting from this date.

effective_end_date
any <datetime> (Effective End Date)

The date when the plan expires. The plan is no longer available for purchase starting from this date.

status
any <varchar> (Status)

The status of the plan.

Possible values:

  • active - The plan is active.
  • inactive - The plan is inactive.
created_at
any <timestamp> (Created At)

The date and time when the plan was created.

updated_at
any <timestamp> (Updated At)

The date and time when the plan was last updated.

created_by
any <char> (Created By)

The user who created the plan.

updated_by
any <char> (Updated By)

The user who last updated the plan.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan.

data_source
any <char> (Data Source)

The data source of the plan.

is_gift
any <tinyint> (Is Gift Plan)

Indicates whether the plan is a gift plan.

Response samples

Content type
application/json
{
}

Get related list of Plans

Returns one-to-many list of Plans with related Module

path Parameters
plan_id
required
string

The unique identifier of plan

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
Array of objects

Response samples

Content type
application/json
{
}

Get filtered list of Plans

Search for plans based on specific criteria. Use this endpoint to find plans that match given parameters or filters.

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the plan.

name
any <varchar> (Name)

The name of the plan.

description
any <text> (Description)

The description of the plan.

effective_start_date
any <datetime> (Effective Start Date)

The date when the plan becomes effective. The plan is available for purchase starting from this date.

effective_end_date
any <datetime> (Effective End Date)

The date when the plan expires. The plan is no longer available for purchase starting from this date.

status
any <varchar> (Status)

The status of the plan.

Possible values:

  • active - The plan is active.
  • inactive - The plan is inactive.
created_at
any <timestamp> (Created At)

The date and time when the plan was created.

updated_at
any <timestamp> (Updated At)

The date and time when the plan was last updated.

created_by
any <char> (Created By)

The user who created the plan.

updated_by
any <char> (Updated By)

The user who last updated the plan.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan.

data_source
any <char> (Data Source)

The data source of the plan.

is_gift
any <tinyint> (Is Gift Plan)

Indicates whether the plan is a gift plan.

Response samples

Content type
application/json
{
}

Filter Plan with nested conditions

Returns filtered Plan data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Plans

Returns deleted Plans data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

PlanPrice

A plan-item is a line item that defines the billing details for a product or plan. The plan-item details include the plan-item ID, name, description, category, charge model, accounting account code, list price, list price base, UOM, included units, default quantity, trigger condition, end date, billing timing, billing period alignment, usage records rating option, billing period, billing period months weeks, billing month, billing day type, billing week day, and status.

Get list of PlanPrice

Returns list of PlanPrice

Responses

Response Schema: application/json
id
any <varchar> (Id)

The unique identifier for the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <array> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Response samples

Content type
application/json
{
}

Store a new PlanPrice

Returns PlanPrice data

Request Body schema: application/json
required
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get PlanPrice information

Returns PlanPrice data

path Parameters
plan-price
required
char

PlanPrice id

Responses

Response Schema: application/json
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Response samples

Content type
application/json
{
}

Update existing PlanPrice

Returns updated PlanPrice data

path Parameters
plan-price
required
char

PlanPrice id

Request Body schema: application/json
required
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Responses

Response Schema: application/json
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing PlanPrice

Deletes a record and returns deleted record

path Parameters
plan-price
required
char

PlanPrice id

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of PlanPrice

Returns list of PlanPrice with all foreign keys

Responses

Response Schema: application/json
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Response samples

Content type
application/json
{
}

Get related list of PlanPrice

Returns one-to-many list of PlanPrice with related Module

path Parameters
id
required
char

PlanPrice id

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Response samples

Content type
application/json
{
}

Get filtered list of PlanPrice

Returns list of PlanPrice with quick filters

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <varchar> (Id)

The unique identifier for the plan price.

plan_id
any <int> (Plan Id)

The identifier of the plan associated with the plan price.

product_id
any <int> (Product Id)

The identifier of the product associated with the plan price.

name
any <int> (Name)

The name of the plan price.

description
any <varchar> (Description)

The description of the plan price.

category
any <date> (Category)

The category of the plan price.

charge_model
any <varchar> (Charge Model)

The charge model of the plan price.

Possible values:

  • flat_fee - The plan price is a flat fee.
  • per_unit - The plan price is a per unit fee.
  • tiered - The plan price is a tiered fee.
  • volume - The plan price is a volume fee.
accounting_account_code
any <varchar> (Account)

The accounting account code of the plan price.

list_price
any <double> (List Price)

The list price of the plan price.

list_price_base
any <varchar> (List Price Base)

The list price base of the plan price.

uom
any <varchar> (UOM)

The unit of measure (UOM) of the plan price.

included_units
any <varchar> (Included Units)

The included units of the plan price.

default_quantity
any <varchar> (Default Quantity)

The default quantity of the plan price.

trigger_condition
any <varchar> (Trigger Condition)

The trigger condition of the plan price.

end_date
any <varchar> (End Date)

The end date of the plan price.

billing_timming
any <varchar> (Billing Timming)

The billing timming of the plan price.

Possible values:

  • in_advance - The plan price is billed in advance.
  • in_arrears - The plan price is billed in arrears.
billing_period_alignment
any <varchar> (Billing Period Alignment)

The billing period alignment of the plan price.

usage_records_rating_option
any <varchar> (Usage Records Rating Option)

The usage records rating option of the plan price.

billing_period_id
any <int> (Billing Period)

The identifier of the billing period associated with the plan price.

billing_period_months_weeks
any <int> (Billing Period Months Weeks)

The billing period months weeks of the plan price.

billing_month_id
any <int> (Billing Month)

The identifier of the billing month associated with the plan price.

billing_day_type_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

billing_week_day_id
any <int> (Billing Day)

The identifier of the billing day associated with the plan price.

created_at
any <timestamp> (Created At)

The date and time when the plan price was created.

assigned_to
any <char> (Assigned To)

The user who is assigned to the plan price.

data_source
any <char> (Data Source)

The data source of the plan price.

Response samples

Content type
application/json
{
}

Filter PlanPrice with nested conditions

Returns filtered PlanPrice data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy PlanPrice

Returns deleted PlanPrice data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

Users

A user is a person who can access your SubscriptionFlow instance. The user details include the user ID, email, first name, last name, role, status, address information, and locale.

Get list of Users

Retrieve a comprehensive list of all registered users. This endpoint returns a summary of each user, including basic details and statuses.

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Response samples

Content type
application/json
{
}

Store a new User

Create and save a new user in the system. Provide the necessary user details in the request body to successfully register the new user.

Request Body schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get User information

Retrieve detailed information about a specific user. This operation requires the user ID to fetch and display the user's data.

path Parameters
user_id
required
string

The unique identifier of user

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Response samples

Content type
application/json
{
}

Update existing User

Modify the details of an existing user. Provide the user ID and updated information in the request body to apply changes.

path Parameters
user_id
required
string

The unique identifier of user

Request Body schema: application/json
required
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing User

Permanently remove a specific user from the system. This operation requires the user ID to identify and delete the user record.

path Parameters
user_id
required
string

The unique identifier of user

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of Users

Returns list of Users with all foreign keys

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Response samples

Content type
application/json
{
}

Get related list of Users

Returns one-to-many list of Users with related Module

path Parameters
user_id
required
string

The unique identifier of user

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Response samples

Content type
application/json
{
}

Get filtered list of Users

Search for users based on specific criteria or keywords. Use this endpoint to locate users that match given parameters or search terms.

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <varchar> (Id)

A unique and immutable identifier for the user.

email
any <varchar> (Email)

The email address of the user.

user_type
any <varchar> (User Type)

The type of the user.

Possible values are

  • 1 - The user is an admin.
  • 2 - The user is a regular user.
first_name
any <varchar> (First Name)

The first name of the user.

last_name
any <varchar> (Last Name)

The last name of the user.

nationality
any <varchar> (Nationality)

The nationality of the user.

username
any <varchar> (Username)

The username of the user.

status
any <varchar> (Status)

The status of the user.

Possible values are

  • 1 - The user is active.
  • 0 - The user is inactive.
designation_id
any <varchar> (Designation Id)

The identifier of the designation associated with the user.

alias
any <varchar> (Alias)

The alias of the user.

phone
any <varchar> (Phone)

The phone number of the user.

mobile
any <varchar> (Mobile)

The mobile number of the user.

website
any <varchar> (Website)

The website of the user.

fax
any <varchar> (Fax)

The fax number of the user.

date_of_birth
any <varchar> (Date Of Birth)

The date of birth of the user.

street
any <varchar> (Street)

The street address of the user.

city
any <varchar> (City)

The city of the user.

state
any <varchar> (State)

The state of the user.

zip_code
any <varchar> (Zip Code)

The zip code of the user.

country
any <varchar> (Country)

The country of the user.

time_format
any <varchar> (Time Format)

The time format of the user.

timezone
any <varchar> (Timezone)

The timezone of the user.

signature
any <varchar> (Signature)

The signature of the user.

data_source
any <char> (Data Source)

The source of data for the user.

Response samples

Content type
application/json
{
}

Filter User with nested conditions

Apply filters to narrow down the list of users based on various attributes. Use this endpoint to refine user searches by criteria such as role, status, or other parameters.

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy Users

Returns deleted Users data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}

CreditNotes

A credit note is a document that itemizes a customer's credit for products and services. It is generated at the end of a billing cycle, which can be monthly, quarterly, or yearly. The credit note details include the credit note ID, name, customer ID, credit note date, due date, total amount, and status.

Possible values for credit note status are

  • Allocated: The credit note is allocated.
  • Unallocated: The credit note is unallocated.
  • Partially Allocated: The credit note is partially allocated.
  • Cancelled: The credit note is cancelled.

Get list of CreditNotes

Retrieve a comprehensive list of all credit notes. This endpoint returns an overview of each credit note, including key details and statuses.

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Response samples

Content type
application/json
{
}

Store a new CreditNote

Create and save a new credit note in the system. Provide necessary credit note details in the request body to successfully record the new credit note.

Request Body schema: application/json
required
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get CreditNote information

Retrieve detailed information about a specific credit note. This operation requires the credit note ID to fetch and display the relevant data.

path Parameters
credit-note
required
char

CreditNote id

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Response samples

Content type
application/json
{
}

Update existing CreditNote

Modify the details of an existing credit note. Provide the credit note ID and updated information in the request body to apply changes.

path Parameters
credit-note
required
char

CreditNote id

Request Body schema: application/json
required
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing CreditNote

Permanently remove a specific credit note from the system. This operation requires the credit note ID to identify and delete the credit note.

path Parameters
credit-note
required
char

CreditNote id

Responses

Response samples

Content type
application/json
{
}

Get with-relations list of CreditNotes

Returns list of CreditNotes with all foreign keys

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Response samples

Content type
application/json
{
}

Get related list of CreditNotes

Returns one-to-many list of CreditNotes with related Module

path Parameters
id
required
char

CreditNote id

related
required
varchar

hasMany relation name

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Response samples

Content type
application/json
{
}

Get filtered list of CreditNotes

Search for credit notes based on specific criteria or filters. Use this endpoint to find credit notes that match given parameters, such as date range or status.

path Parameters
fieldName
required
varchar

Field name to apply filter E.g. 'name' = 'John'

Responses

Response Schema: application/json
id
any <char> (Id)

The unique identifier for the credit note.

name
any <varchar> (Name)

The name of the credit note.

amount
any <double> (Amount)

The amount of the credit note.

balance
any <varchar> (Balance)

The balance of the credit note.

status
any <varchar> (Status)

The status of the credit note.

Possible values are:

  • Allocated
  • Unallocated
reference
any <varchar> (Reference)

The reference of the credit note.

created_at
any <timestamp> (Created At)

The date and time when the credit note was created.

updated_at
any <timestamp> (Updated At)

The date and time when the credit note was last updated.

created_by
any <char> (Created By)

The user who created the credit note.

updated_by
any <char> (Updated By)

The user who last updated the credit note.

assigned_to
any <char> (Assigned To)

The user who the credit note is assigned to.

data_source
any <char> (Data Source)

The data source of the credit note.

Response samples

Content type
application/json
{
}

Filter CreditNote with nested conditions

Returns filtered CreditNote data

query Parameters
$equals
varchar

Equals field-value. E.g. filter[column_name][$equals] = 'some_value'

$not_equals
varchar

Unequals field-value. E.g. filter[column_name][$not_equals] = 'some_value'

$starts
varchar

Match value starts with. E.g. filter[column_name][$starts] = 'some_value'

$ends
varchar

Match value ends with. E.g. filter[column_name][$ends] = 'some_value'

$contains
varchar

Match if field contains value. E.g. filter[column_name][$contains] = 'some_value'

$in
varchar

Match if field match any value in array. E.g. filter[column_name][$in] = ['first','second']

$is_null
varchar

Match if field have null value. E.g. filter[column_name][$is_null] = true

$not_null
varchar

Match if field is not null. E.g. filter[column_name][$not_null] = true

$not_in
varchar

Match if field does not match any value in array. E.g. filter[column_name][$not_in] = ['first','second']

$lt
varchar

Match if field value is lesser than given value E.g. filter[column_name][$lt] = 'some_value'

$lte
varchar

Match if field value is lesser than or equals to given value E.g. filter[column_name][$lte] = 'some_value'

$gt
varchar

Match if field value is greater than given value E.g. filter[column_name][$gt] = 'some_value'

$gte
varchar

Match if field value is greater than or equals to given value E.g. filter[column_name][$gte] = 'some_value'

$sortorder
varchar

Sort results asc/desc E.g. filter[$sortorder] = 'asc|desc'

$limit
varchar

Limit results E.g. filter[$limit] = '50' | For offset: filter[$offset] = '20'

$paginate
varchar

Paginate results E.g. filter[$paginate] = '50

Responses

Response samples

Content type
application/json
{
}

Bulk destroy CreditNotes

Returns deleted CreditNotes data

query Parameters
ids
required
varchar

Array of ids to be deleted.

Responses

Response samples

Content type
application/json
{
}