MngGetCashierProviderEventsByFilter

Returns payment provider event records using the standard BackOffice table filter format.

Provider events are used for audit, replay, webhook debugging, and provider status investigation.

Access

SESSION_MANAGER, SESSION_ADMIN, SESSION_DEALER, SESSION_CRM_MANAGER, SESSION_CRM_ADMIN.

Requires see_finance. Events linked to a transaction are limited by that transaction scope. Events without a linked transaction are visible only to admin or unscoped managers.

Request Parameters

Name	Type	Required	Description
limit	int	No	Page size, 1..50000
offset	int	No	Pagination offset
where	array	No	AND filters
orWhere	array	No	OR comparison group in [[field, operator, value], ...] format; at least one condition must match
whereNot	array	No	Negative filters
whereIn	array	No	Include-by-list filters
whereNotIn	array	No	Exclude-by-list filters
whereBetween	array	No	Range filters
whereNotBetween	array	No	Negative range filters
orderBy	array	No	Sort expression

Supported Filter Fields

Field	Type
id	int
transaction_id	int
processing_status	int
provider	string
event_id	string
provider_payment_id	string

Response Fields

Name	Type	Description
rows	array	Provider event records
count	int	Total number of matching records

Each event record contains:

Name	Type	Description
id	int	Event record id
provider	string	Provider code
event_id	string	Provider event id
transaction_id	int	Linked Cashier transaction id
provider_payment_id	string	External payment id
payload_json	string	Raw or normalized provider payload JSON string
headers_json	string	Request headers JSON string
signature_status	int	Provider signature validation status
processing_status	int	Cashier processing status
failure_reason	string	Failure reason
created_time	int64	Event creation timestamp
processed_time	int64	Processing timestamp

Processing Statuses

Value	Name	Description
0	pending	Event is waiting for processing
1	processed	Event was processed
2	failed	Event processing failed
3	ignored	Event was intentionally ignored

Request Example

{
  "command": "MngGetCashierProviderEventsByFilter",
  "extID": "1",
  "data": {
    "limit": 50,
    "offset": 0,
    "where": [
      ["provider", "=", "stripe"],
      ["transaction_id", "=", 15]
    ],
    "orderBy": [
      ["created_time", "desc"]
    ]
  }
}

Response Example

{
  "rows": [
    {
      "id": 8,
      "provider": "stripe",
      "event_id": "evt_123",
      "transaction_id": 15,
      "provider_payment_id": "pi_123",
      "payload_json": "{}",
      "headers_json": "{}",
      "signature_status": 1,
      "processing_status": 1,
      "failure_reason": "",
      "created_time": 1779270300,
      "processed_time": 1779270301
    }
  ],
  "count": 1
}