MngExportCustomersByFilter¶
Exports customers by filter to CSV or Excel.
Contact fields can be exported in masked or full form. Filtering always works against full stored values.
Statuses and types are exported as human-readable values:
type:Individual,Businessstatus:Active,Blocked,Archived,Prospect- dictionary statuses such as
kyc_status,sales_status,risk_status,finance_status: status name fromcustomer_statuses - compliance statuses such as
aml_status,risk_level,pep_status,sanctions_status: readable enum text
Request Parameters¶
| Name | Type | Required | Description |
|---|---|---|---|
format |
string | Yes | csv or excel |
contacts |
string | No | masked or full, default masked |
mask_contacts |
int | No | Alternative flag: 1 masked, 0 full |
select |
array | No | Export columns. Empty or missing means default columns |
limit |
int | No | Maximum rows, default 50000 |
offset |
int | No | Pagination offset, default 0 |
where, whereNot, whereIn, whereNotIn, whereBetween, whereNotBetween |
array | No | Same filter format as list methods |
orderBy |
array | No | Sort definition |
Request¶
{
"command": "MngExportCustomersByFilter",
"extID": "1",
"data": {
"format": "csv",
"contacts": "full",
"select": ["customer_id", "full_name", "email", "phone", "type", "status", "kyc_status"],
"where": [
["email", "like", "example.com"]
]
}
}
Response Data¶
{
"file_name": "b1a4d4c8-7a99-4f64-aef0-0d8d1f9db1b9.csv"
}