Quick Start

First SQL Accounting API call
— in 5 minutes.

Use the SQL Accounting connector when the client site runs SQL Accounting on a Windows machine with COM BizObjects access. The portal flow stays the same; the API path and local connector are brand-specific.

Before you begin

✓

AcctBridge tenant account

Create an account or sign in to an existing tenant portal account

✓

SQL Accounting instance connected

Installer package run on the client Windows machine, then verified from the portal

✓

API key generated

Dashboard → API Keys → Generate New Key

30 seconds

Get your API key

In your AcctBridge dashboard, go to API Keys and click Generate New Key. Your key looks like this:

lb_live_xxxxxxxxxxxxxxxxxxxx

⚠ Keys start with lb_live_. Keep it secret — it grants access to your client's accounting data.

10 seconds

Verify your tunnel is online

In the dashboard, go to Instances. The instance status must show Connected before API calls will succeed.

Tunnel shows Offline? The client's PC is not running or the local accounting agent service has stopped. Run the installer package from the portal as Administrator, then use Check connection to verify reachability.

Any language

Make your first call

List your client's SQL Accounting customers. In the sample, replace lb_live_YOUR_API_KEY with the key you generated in Step 1.

curl -X GET "https://api.acctbridge.com/v1/sqlacc/customer" \
  -H "Authorization: Bearer lb_live_YOUR_API_KEY"

200 OKResponse

{
  "data": [
    {
      "code": "300-A001",
      "companyName": "Sunrise Trading Sdn Bhd",
      "creditLimit": 50000.00,
      "currencyCode": "MYR",
      "area": "Kuala Lumpur",
      "isActive": true
    }
  ],
  "totalRecords": 42
}

That's it. The same pattern works for every endpoint — change the path and method.

Selected SQL Accounting endpoints

All paths are prefixed with https://api.acctbridge.com. Authenticate with Authorization: Bearer <key>.

Customers

GET	/v1/sqlacc/customer?CODE={code}	Get customer by code
GET	/v1/sqlacc/customer	List all customers
POST	/v1/sqlacc/customer	Create customer
PUT	/v1/sqlacc/customer/{code}	Update customer
DELETE	/v1/sqlacc/customer/{code}	Delete customer

AR Invoices

GET	/v1/sqlacc/customer-invoice?DOCNO={docno}	Get invoice by doc no
GET	/v1/sqlacc/customer-invoice	List invoices
POST	/v1/sqlacc/customer-invoice	Create invoice
DELETE	/v1/sqlacc/customer-invoice/{docno}	Delete invoice
GET	/v1/sqlacc/customer-invoice-item	List invoice line items

AR Payments

GET	/v1/sqlacc/customer-payment	List payments
POST	/v1/sqlacc/customer-payment	Create payment
POST	/v1/sqlacc/customer-payment/knockoff	Apply payment to invoice

Credit Notes

GET	/v1/sqlacc/customer-credit-note?DOCNO={docno}	Get credit note by doc no
GET	/v1/sqlacc/customer-credit-note	List credit notes
POST	/v1/sqlacc/customer-credit-note	Create credit note
DELETE	/v1/sqlacc/customer-credit-note/{docno}	Delete credit note
POST	/v1/sqlacc/customer-credit-note/knockoff	Apply credit note to invoice

Debit Notes

GET	/v1/sqlacc/customer-debit-note?DOCNO={docno}	Get debit note by doc no
GET	/v1/sqlacc/customer-debit-note	List debit notes
POST	/v1/sqlacc/customer-debit-note	Create debit note
DELETE	/v1/sqlacc/customer-debit-note/{docno}	Delete debit note

Sales Orders

GET	/v1/sqlacc/sales-order?DOCNO={docno}	Get sales order by doc no
GET	/v1/sqlacc/sales-order	List sales orders
POST	/v1/sqlacc/sales-order	Create sales order
DELETE	/v1/sqlacc/sales-order/{docno}	Delete sales order
GET	/v1/sqlacc/sales-order-item	List order line items

Suppliers

GET	/v1/sqlacc/supplier?CODE={code}	Get supplier by code
GET	/v1/sqlacc/supplier	List suppliers
POST	/v1/sqlacc/supplier	Create supplier
PUT	/v1/sqlacc/supplier/{code}	Update supplier
DELETE	/v1/sqlacc/supplier/{code}	Delete supplier

AP Invoices

GET	/v1/sqlacc/purchase-invoice?DOCNO={docno}	Get purchase invoice by doc no
GET	/v1/sqlacc/purchase-invoice	List purchase invoices
POST	/v1/sqlacc/purchase-invoice	Create purchase invoice
DELETE	/v1/sqlacc/purchase-invoice/{docno}	Delete purchase invoice

AP Payments

GET	/v1/sqlacc/purchase-payment	List purchase payments
POST	/v1/sqlacc/purchase-payment	Create purchase payment
POST	/v1/sqlacc/purchase-payment/knockoff	Apply payment to AP invoice

Stock Items

GET

/v1/sqlacc/stock-item

Payment Methods

GET

/v1/sqlacc/payment-method

Common errors

Status	Code	Meaning	Fix
401Unauthorized	api_key_invalid	Key is wrong, expired, or deactivated	Regenerate in Dashboard → API Keys
503Service Unavailable	tunnel_offline	Client PC is offline or local agent is stopped	Run the portal installer, then check the agent connection
429Too Many Requests	rate_limited	Request rate is temporarily limited	Reduce bursts or polling frequency
502Bad Gateway	upstream_error	The local accounting agent returned an unexpected error	Check agent logs on the client machine