开放平台

获取会员列表

请求地址(POST)

https://openapi.1card1.cn/OpenApi/Get_MembersPagedV2?openId=[OpenId]&signature=[Signature]&timestamp=[TimeStamp]

字段 说明
OpenId 登陆开放平台生成的OpenId
Signature 签名=md5(OpenId+Secret+Timestamp+data),格式:32位md5大写加密
TimeStamp 发起请求的时间戳,查看标准timestamp

请求说明

data={"userAccount":"10003","where":" 1=1 and cardId='13632651195' ", "pageIndex":0,"pageSize":10,"orderBy":" cardId desc"}

字段 是否必须 说明
userAccount 工号
where 查询条件
pageIndex 页码
pageSize 页大小
orderBy 排序规则

返回说明

成功时返回:

{ "status":0, "total":2, "data":[ { "Guid": "a13ea1b4-3fe6-e311-8b81-90b11c47b4da", "CardId": "q32", "MemberGroupName": "默认级别", "TrueName": "", "Sex": 1, "Mobile": "", "IdCard": "", "Tel": "", "Email": "", "ChainStoreName": "总店", "ChainStoreGuid": "AE3166F5-DEEF-4FCD-B984-0683329BAB63", "UserAccount": "10001", "RegisterTime": "2014-05-28 16:11:45", "DurationTime": "2015-05-28 15:38:28", "TotalPoint": 10, "AvailablePoint": 10, "TotalValue": 10, "AvailableValue": 10, "ProvinceName":"广东", "CityName":"深圳", "CountyName":"龙华新区", "ImagePath":"", "Meno":"", "RecommendCardId":"q", "IsDeleted":"False", "IsLocked":"False", "FreezedValue":100, "IsLunar":"False", "RealBirthDay":"1992-04-18", "BirthDayCurrentYear":"2019-04-18", "ModifiedTime":"2016-07-08 15:38:28", "ModifiedUser":"10000" }, { "Guid": "714cc209-3be6-e311-8b81-90b11c47b4da", "CardId": "q3", "MemberGroupName": "金卡", "TrueName": "121212", "Sex": 1, "Mobile": "", "IdCard": "", "Tel": "", "Email": "", "ChainStoreName": "总店", "ChainStoreGuid": "AE3166F5-DEEF-4FCD-B984-0683329BAB63", "UserAccount": "10001", "RegisterTime": "2014-05-28 15:38:28", "DurationTime": "2015-05-28 15:38:28", "TotalPoint": 0, "AvailablePoint": 0, "TotalValue": 0, "AvailableValue": 0, "ProvinceName":"北京", "CityName":"北京", "CountyName":"东城区", "ImagePath":"", "Meno":"老客户", "RecommendCardId":"q", "IsDeleted":"True", "IsLocked":"True", "FreezedValue":0, "IsLunar":"True", "RealBirthDay":"壬申年(1992)三月十六", "BirthDayCurrentYear":"2019-04-18", "ModifiedTime":"2016-07-08 15:38:28", "ModifiedUser":"10000" } ] }

字段 是否必须 说明
Guid 会员唯一标识
CardId 会员卡号
MemberGroupName 会员级别
TrueName 姓名
Sex 性别(1:先生,2:女士)
Mobile 手机号码
IdCard 身份证号码
Tel 电话
Email Email
ImagePath 头像图片路径
ChainStoreName 注册所在店面
ChainStoreGuid 注册所在店面唯一标识
UserAccount 注册当事工号
RegisterTime 注册时间
DurationTime 有效期
TotalPoint 历史积分
AvailablePoint 可用积分
TotalValue 历史储值
AvailableValue 可用储值
Meno 备注
RecommendCardId 推荐人卡号
IsLocked 是否锁定
IsDeleted 是否删除到回收站(无法筛选已经彻底删除的会员)
FreezedValue 冻结储值
IsLunar 生日是否是阴历
RealBirthDay 生日(如果是阴历,则格式为“壬申年(1992)三月十六”,否则格式为“2015-05-28”)
Birthday 生日(如果是阴历,此字段已经转换为阳历)
BirthDayCurrentYear 不论是哪一年生日,不论阴历或阳历,此字段表示今年过生日的阳历日期
ModifiedTime 最近编辑时间
ModifiedUser 最近编辑者

失败时返回:

{"status":-1,"message":"查询失败及原因"}

字段 是否必须 说明
status 状态(0,成功;-1,失败)
message 查询失败及原因

获取会员列表 调试