MngGetPropPurchasesByFilter

Returns prop purchases in the standard BackOffice table format.

Access

SESSION_MANAGER, SESSION_ADMIN, SESSION_DEALER, SESSION_CRM_MANAGER, SESSION_CRM_ADMIN.

Request Parameters

Name	Type	Required	Description
limit	int	Yes	Maximum number of rows
offset	int	Yes	Pagination offset
where	array	No	AND filters, for example [["status", "=", 3]]
whereNot	array	No	Negative filters
whereIn	array	No	IN filters
whereNotIn	array	No	NOT IN filters
whereBetween	array	No	Range filters
whereNotBetween	array	No	Negative range filters
orderBy	array	No	Sort expression, for example [["id", "desc"]]

Supported Filter Fields

Field	Type
id	int
program_id	int
customer_id	int
payer_login	int
account_login	int
status	int
amount	double
currency	string
conversion_rate	double
amount_account_currency	double
comment	string
idempotency_key	string
payment_status	string
activation_status	string
failure_reason	string
created_time	int64
updated_time	int64

Response Structure

Rows follow this structure order:

[
  "id",
  "program_id",
  "program_name",
  "customer_id",
  "payer_login",
  "account_login",
  "status",
  "status_name",
  "amount",
  "currency",
  "payment_status",
  "activation_status",
  "failure_reason",
  "created_time",
  "updated_time"
]

Request

{
  "command": "MngGetPropPurchasesByFilter",
  "extID": "1",
  "data": {
    "limit": 50,
    "offset": 0,
    "where": [
      ["status", "=", 3]
    ],
    "orderBy": [
      ["id", "desc"]
    ]
  }
}