Bank Balance Reconciliation

GEThttps://b-api.longbridge.xyz/v1/datasets/clearing_bank_balance_checks

This Dataset query is read-only. Use GET by default. If the encoded query parameters are too large, send the same parameters as a JSON body with POST to the same path.

Authorization

AuthorizationstringheaderRequired

Send the Broker ACCESS_TOKEN as Authorization: Bearer <token>.

Query parameters

filtersobject

Combines business filters. Omit a filter field to disable that filter.

Child attributes

dtstring

Filters results by Reconciliation Date.

lb_account_nostring

Filters results by Bank Account.

statestring

Filters results by State.

Allowed values:

1 - Reconciliation Failed
2 - Reconciliation Successful

1 · Reconciliation Failed2 · Reconciliation Successful

pageinteger

Page number to retrieve, starting from 1.

page_sizeinteger

Number of records to return per page.

Responses

HTTP 200On success, returns paginated Bank Balance Reconciliation records together with pagination metadata such as the page number, page size, and total record count.

Standard response envelopecodemessagedata

dataobjectdata structure

listarray<object>required

Returned value: List of list.

Child attributes

idstring

Returned value: Unique identifier of the current record.

dtstring

Returned value: Reconciliation Date.

bank_finance_dtstring

Returned value: Accounting Date.

lb_account_nostring

Returned value: Bank Account.

lb_account_namestring

Returned value: Bank Name.

currencystring

Returned value: Currency.

last_bank_amountstring

Returned value: Previous Day Bank Balance.

daily_amountstring

Returned value: Consolidated Bill Amount.

local_amountstring

Returned value: Account System Balance.

bank_amountstring

Returned value: Bank Balance.

statestring

Returned value: State.

state_valstring

Raw value of state. The state field contains the display value resolved through a dictionary or related record; this field contains the underlying code or ID.

updated_atstring

Returned value: Updated Time. The date or time format follows the value returned by the API.

totalintegerrequired

Returned value: Total number of matching records, used for pagination.

HTTP 400Bad request. Check the business error code in code and the error details in message.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

HTTP 401The user is not authenticated, or the login session has expired.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

HTTP 403The current account is not authorized to use this feature. Grant the required permission to the account in User Permission.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

HTTP 408The request timed out. Check the business error code in code and the error details in message.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

Request

curl --get \
  --url 'https://b-api.longbridge.xyz/v1/datasets/clearing_bank_balance_checks' \
  --header 'Authorization: Bearer <token>' \
  --data-urlencode 'filters={}' \
  --data-urlencode 'page=1' \
  --data-urlencode 'page_size=20'

Response

{
  "code": 0,
  "message": "success",
  "data": {
    "list": [
      {
        "id": "128819",
        "dt": "2026-07-15",
        "bank_finance_dt": "2026-07-15",
        "lb_account_no": "****0000",
        "lb_account_name": "072-072 ICBC (Asia) Ltd",
        "currency": "HKD",
        "last_bank_amount": "0",
        "daily_amount": "352,000",
        "local_amount": "0",
        "bank_amount": "0",
        "state": "Reconciliation Successful",
        "state_val": "2",
        "updated_at": "1784152804"
      }
    ],
    "total": 8256
  }
}

Export

The export endpoint uses the same filters as this Dataset query.

POSThttps://b-api.longbridge.xyz/v1/datasets/clearing_bank_balance_checks/download

Export options Export records Download result