API
/
SQL Account
/
SQL Account Stock Item Template

Beehexa Customization SQL Account Rest API (1.0)

SQL Account is an accounting software from Malaysia that is suitable for all businesses, from small businesses to large organizations. It is crucial to find a business solution that suits the nature of your business. The right accounting software will broaden the horizons and expand business opportunities for you.

This is a comprehensive REST API for managing SQL accounts. It provides endpoints for user authentication, customer data management, sales transactions, and stock control. Use this API to integrate your applications with the SQL Account software.

Metadata

KeyValue
releaseDate10 Mar 2025
keywordSQL Account Rest API
Download OpenAPI description
docs.json
docs.yaml
Languages
Servers
Mock server
https://docs.beehexa.com/_mock/api/sql-account/docs/
https://sqlaccountrestapi.beehexa.com/

SQL Account App

Provides authentication, system module retrieval, user actions, and application updates.

Operations

SQL Account BizObject

Manages business objects, including querying, creating, updating, and transferring entities.

Operations

SQL Account Customer

Handles customer data retrieval based on email, code, and date filters.

Operations

SQL Account Customer Invoice

Retrieves customer invoices based on document numbers, date filters, and transaction history.

Operations

SQL Account Customer Payment

Manages customer payments, including retrieval by document number and payment history tracking.

Operations

SQL Account History

Provides access to system logs, log details, and historical transaction downloads.

Operations

SQL Account Sales Invoice

Retrieves sales invoices by document number and filters based on transaction dates.

Operations

SQL Account Sales Order

Handles sales orders, including retrieval by document number and transaction history.

Operations

SQL Account Stock Adjustment

Manages stock adjustments, including retrieval by document number and date-based filters.

Operations

SQL Account Stock Item

Retrieves stock item details based on code and historical transaction data.

Operations

SQL Account Stock Item Template

Provides access to predefined stock item templates for inventory standardization.

Operations

Retrieves stock item templates by code

Request

This API fetches stock item templates that match the provided code.

Path
codestringrequired

The code to search.

Default ""
Example: S-0001
Query
limitinteger(int32)

Maximum number of results to return (example: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/stock-item-templates/code/S-0001?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ATTACHMENTSnumber or string
Example: ""
One of:
number
cdsItemTplDtlArray of objects(ItemTemplateDetail)
CODEnumber or string
Example: "S-0001"
One of:
number
DESCRIPTIONnumber or string
Example: ""
One of:
number
DESCRIPTION2number or string
Example: ""
One of:
number
DESCRIPTION3number or string
Example: ""
One of:
number
ISACTIVEnumber or string
Example: "T"
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1741233335
REFPRICEnumber or string
Example: 0
One of:
number
]
Response
application/json
[
  {
    "CODE": "S-0001",
    "DESCRIPTION": "",
    "DESCRIPTION2": "",
    "DESCRIPTION3": "",
    "REFPRICE": "",
    "ISACTIVE": "T",
    "ATTACHMENTS": "",
    "LASTMODIFIED": 1741233335,
    "cdsItemTplDtl": [ … ]
  }
]

Retrieves stock item templates from a certain number of days ago

Request

Fetches stock item templates based on the number of days before the current date.

Path
daysinteger(int32)required

The number of days ago to search.

Default 0
Example: 1000
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/stock-item-templates/days-ago/1000?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ATTACHMENTSnumber or string
Example: ""
One of:
number
cdsItemTplDtlArray of objects(ItemTemplateDetail)
CODEnumber or string
Example: "S-0001"
One of:
number
DESCRIPTIONnumber or string
Example: ""
One of:
number
DESCRIPTION2number or string
Example: ""
One of:
number
DESCRIPTION3number or string
Example: ""
One of:
number
ISACTIVEnumber or string
Example: "T"
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1741233335
REFPRICEnumber or string
Example: 0
One of:
number
]
Response
application/json
[
  {
    "CODE": "S-0001",
    "DESCRIPTION": "",
    "DESCRIPTION2": "",
    "DESCRIPTION3": "",
    "REFPRICE": "",
    "ISACTIVE": "T",
    "ATTACHMENTS": "",
    "LASTMODIFIED": 1741233335,
    "cdsItemTplDtl": [ … ]
  }
]

Retrieves stock item templates from a specific date

Request

Fetches stock item templates recorded from a given date onward.

Path
datestringrequired

The date in YYYY-MM-DD format.

Default ""
Example: 2020-01-01
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/stock-item-templates/from-date/2020-01-01?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ATTACHMENTSnumber or string
Example: ""
One of:
number
cdsItemTplDtlArray of objects(ItemTemplateDetail)
CODEnumber or string
Example: "S-0001"
One of:
number
DESCRIPTIONnumber or string
Example: ""
One of:
number
DESCRIPTION2number or string
Example: ""
One of:
number
DESCRIPTION3number or string
Example: ""
One of:
number
ISACTIVEnumber or string
Example: "T"
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1741233335
REFPRICEnumber or string
Example: 0
One of:
number
]
Response
application/json
[
  {
    "CODE": "S-0001",
    "DESCRIPTION": "",
    "DESCRIPTION2": "",
    "DESCRIPTION3": "",
    "REFPRICE": "",
    "ISACTIVE": "T",
    "ATTACHMENTS": "",
    "LASTMODIFIED": 1741233335,
    "cdsItemTplDtl": [ … ]
  }
]