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
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
{
}

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.

Request Body schema: application/json
required
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

Request samples

Content type
application/json
{
}

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
required
char

Customer id

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
{
}

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
required
char

Customer id

Request Body schema: application/json
required
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
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.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Customer

Deletes a record and returns deleted record

path Parameters
customer
required
char

Customer 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
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
id
required
char

Customer id

related
required
varchar

hasMany relation name

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 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 Customers

Returns list of Customers

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

Returns EmailAddress data

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

Returns EmailAddress 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

Returns updated EmailAddress data

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

Deletes a record and returns deleted 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

Returns a list of subscriptions meeting all the conditions specified in the filter parameters below.

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
{
}

Create a new Subscription

Creates a new subscription for an existing customer in SubscriptionFlow.

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

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Subscription information

Retrieves a subscription.

path Parameters
subscription
required
char

Subscription id

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
{
}

Update existing Subscription

Returns updated Subscription data

path Parameters
subscription
required
char

Subscription id

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
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.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Subscription

Deletes the subscription resource.

path Parameters
subscription
required
char

Subscription id

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
id
required
char

Subscription id

related
required
varchar

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

Returns suspended Subscription data

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

Returns resumed Subscription data

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

Returns cancelled Subscription data

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

Returns list of Usages

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
{
}

Store a new Usage

Returns Usage data

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

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Usage information

Returns Usage data

path Parameters
usage
required
char

Usage id

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
{
}

Update existing Usage

Returns updated Usage data

path Parameters
usage
required
char

Usage id

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
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.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Usage

Deletes a record and returns deleted record

path Parameters
usage
required
char

Usage id

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
id
required
char

Usage id

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

Returns list of Usages 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 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

Returns list of Invoices

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
{
}

Store a new Invoice

Returns Invoice data

Request Body schema: application/json
required
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

Returns Invoice data

path Parameters
invoice
required
char

Invoice id

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
{
}

Update existing Invoice

Returns updated Invoice data

path Parameters
invoice
required
char

Invoice id

Request Body schema: application/json
required
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
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.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Invoice

Deletes a record and returns deleted record

path Parameters
invoice
required
char

Invoice id

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
id
required
char

Invoice id

related
required
varchar

hasMany relation name

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 filtered list of Invoices

Returns list of Invoices 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 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

Returns list of Transactions

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

Returns Transaction data

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

Returns Transaction 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

Returns updated Transaction data

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

Deletes a record and returns deleted 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

Returns list of Products

Responses

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

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

Response samples

Content type
application/json
{
}

Store a new Product

Returns Product data

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

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

Responses

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Product information

Returns Product data

path Parameters
product
required
char

Product id

Responses

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

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

Response samples

Content type
application/json
{
}

Update existing Product

Returns updated Product data

path Parameters
product
required
char

Product id

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

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

Responses

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

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Product

Deletes a record and returns deleted record

path Parameters
product
required
char

Product id

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
id
any <char> (Id)

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

Response samples

Content type
application/json
{
}

Get related list of Products

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

path Parameters
id
required
char

Product id

related
required
varchar

hasMany relation name

Responses

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

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

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
id
any <char> (Id)

The unique identifier for the product.

name
any <varchar> (Name)

The name of the product. This is the name that appears on the invoice.

description
any <text> (Description)

The description of the product. This is the description that appears on the invoice.

sku
any <varchar> (SKU)

The stock keeping unit (SKU) of the product.

effective_start_date
any <datetime> (Effective Start Date)

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

effective_end_date
any <datetime> (Effective End Date)

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

type
any <varchar> (Type)

The type of the product.

Possible values:

  • Base Product - The product is a base product.
  • Addon Service - The product is an add-on service.
  • Miscellaneous Products - The product is a miscellaneous product.
manager_id
any <char> (Manager)

The identifier of the manager associated with the product.

status
any <varchar> (Status)

The status of the product.

Possible values:

  • active - The product is active.
  • inactive - The product is inactive.
image
any <varchar> (Image)

The URL of an image for the product.

created_at
any <timestamp> (Created At)

The date and time when the product was created.

updated_at
any <timestamp> (Updated At)

The date and time when the product was last updated.

created_by
any <char> (Created By)

The user who created the product.

updated_by
any <char> (Updated By)

The user who last updated the product.

assigned_to
any <char> (Assigned To)

The user who is assigned to the product.

data_source
any <char> (Data Source)

The data source of the product.

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

Returns list of Plans

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
{
}

Store a new Plan

Returns Plan data

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

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get Plan information

Returns Plan data

path Parameters
plan
required
char

Plan id

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
{
}

Update existing Plan

Returns updated Plan data

path Parameters
plan
required
char

Plan id

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
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.

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Delete existing Plan

Deletes a record and returns deleted record

path Parameters
plan
required
char

Plan id

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
id
required
char

Plan id

related
required
varchar

hasMany relation name

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 filtered list of Plans

Returns list of Plans 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 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.

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
{
}

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

Returns list of Users

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

Returns User data

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

Request samples

Content type
application/json
{
}

Response samples

Content type
application/json
{
}

Get User information

Returns User data

path Parameters
user
required
char

User id

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

Returns updated User data

path Parameters
user
required
char

User id

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

Deletes a record and returns deleted record

path Parameters
user
required
char

User id

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
id
required
char

User id

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

Returns list of Users 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 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

Returns filtered User 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 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

Returns list of CreditNotes

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

Returns CreditNote data

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

Returns CreditNote 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

Returns updated CreditNote data

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

Deletes a record and returns deleted record

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

Returns list of CreditNotes 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 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
{
}