Skip to content

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, Business
  • status: Active, Blocked, Archived, Prospect
  • dictionary statuses such as kyc_status, sales_status, risk_status, finance_status: status name from customer_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"
}