MngGetAffiliatesByFilter

{
  "command":"MngGetAffiliatesByFilter",
  "extID":"1",
  "data":{
    "brand":"default",
    "limit":50,
    "offset":0,
    "where":[["status","=",0]],
    "orderBy":[["company_name","asc"]]
  }
}

Supported fields: id, code, company_name, contact_name, email, country, parent_affiliate_id, status, created_time, and updated_time. The response is {"rows":[],"count":0}. Brand scope is applied through the affiliate-to-brand access relation before pagination.

For a resolved brand, every row additionally contains:

Field	Type	Description
brand	string	Effective brand
manager_id	integer	Assigned manager
default_campaign_id	integer	Default campaign or 0
primary_link_id	integer	Primary marketing-link ID or 0
primary_link	string	Complete server-generated URL or an empty string

The CRM affiliate table should copy primary_link directly. It must not derive the URL from frontend host or UTM configuration. For an empty link, call MngGetOrCreateAffiliateLink.