9.获取图表数据-流水明细模块

【产品代号】
getChartDataByModel
【功能描述】
根据模块名查询指定模块流水图表数据
【业务加密参数】
参数orderNo可通过支付流水文件上传解析（createPayTask）接口获取

属性名	类型	必填	说明	备注
orderNo	string	是	流失号
modelName	string	是	流水模块名	此处固定传“listPage”
pageNum	integer	否	页码	默认1
pageSize	integer	否	每页大小	默认10
balanceType	integer	否	收支类型	1-收入，2-支出

请求参数

Body 参数application/json

app_key

string

appKey

必需

由我司业务人员提供

默认值:

app_key8888888888888

示例值:

name

string

产品编号

必需

接口不同，编号不同

默认值:

data

string

加密后的业务参数

必需

加密方式见Java示例代码，产品编号不同业务参数也不同

sign

string

加密后的签名

必需

加密方式见Java示例代码

timestamp

string

访问时间

必需

东八区当前时间,误差不可高于60秒

version

string

版本

必需

需传递空字符

order_no

string

订单号

可选

<= 32 唯一值

示例

{
  "app_key": "{{app_key}}",
  "name": "{{name}}",
  "data": "{{data}}",
  "sign": "{{sign}}",
  "timestamp": "{{timestamp}}",
  "version": "{{version}}"
}

示例代码

Java

Shell

JavaScript

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

code

string

接口状态

必需

0-成功；501-后台接口服务异常；1003-产品账号信息获取失败

msg

string

错误信息

可选

出错时显示

data

object

业务数据

可选

total

integer

数据总条数

可选

pages

integer

总页数

可选

list

array [object {18}]

数据集合

可选

示例

{
  "code": "0",
  "data": {
    "total": 1747,
    "pages": 175,
    "list": [
      {
        "balanceType": 0,
        "borrow": "10",
        "categoryType": "2",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "/",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "0",
        "merchantOrder": "",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "退款",
        "remark": "微信红包-退款",
        "tradeDate": "2021-11-18 08:22:25",
        "tradeOrder": "1000039901202111176055263709099",
        "tradeWay": "工商银行(5197)",
        "type": 2,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "远颜",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "15",
        "merchantOrder": "10001071012021111801957137133585",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "采购支出",
        "remark": "扫二维码付款",
        "tradeDate": "2021-11-18 12:07:25",
        "tradeOrder": "100010710121111800060321669411826641",
        "tradeWay": "工商银行(5197)",
        "type": 1,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "拼多多平台商户",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "10.5",
        "merchantOrder": "XP1521111821200860156185000135",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "消费支出",
        "remark": "商户消费",
        "tradeDate": "2021-11-18 21:58:22",
        "tradeOrder": "4200001207202111186428773534",
        "tradeWay": "工商银行(5197)",
        "type": 0,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "拼多多平台商户",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "7.3",
        "merchantOrder": "XP2321111821500404196370005142",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "消费支出",
        "remark": "商户消费",
        "tradeDate": "2021-11-18 21:59:22",
        "tradeOrder": "4200001214202111181925573162",
        "tradeWay": "工商银行(5197)",
        "type": 0,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "拼多多平台商户",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "5.9",
        "merchantOrder": "XP1021111822500404236590002334",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "消费支出",
        "remark": "商户消费",
        "tradeDate": "2021-11-18 22:00:50",
        "tradeOrder": "4200001128202111180867236386",
        "tradeWay": "零钱",
        "type": 0,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "拼多多平台商户",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "7.9",
        "merchantOrder": "XP1121111822200861823106001757",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "消费支出",
        "remark": "商户消费",
        "tradeDate": "2021-11-18 22:02:03",
        "tradeOrder": "4200001188202111181883208525",
        "tradeWay": "工商银行(5197)",
        "type": 0,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "发给桂",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "15",
        "merchantOrder": "1000039801202111196030607078139",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "红包支出",
        "remark": "微信红包（单发）",
        "tradeDate": "2021-11-19 08:49:23",
        "tradeOrder": "100003980121111900054321658985321641",
        "tradeWay": "工商银行(5197)",
        "type": 1,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "3",
        "categoryType": "2",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "快手极速版提现",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "0",
        "merchantOrder": "10100873627502111197667259185330",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "消费返现",
        "remark": "商户消费",
        "tradeDate": "2021-11-19 20:59:45",
        "tradeOrder": "149623772221111910109004232632903885132641485",
        "tradeWay": "/",
        "type": 0,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "妈妈",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "2000",
        "merchantOrder": "1000050001202111191803800916217",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "转账支出",
        "remark": "转账",
        "tradeDate": "2021-11-19 21:49:13",
        "tradeOrder": "100005000121111900054321584756140641",
        "tradeWay": "工商银行(5197)",
        "type": 1,
        "updateTime": 1677562801000
      },
      {
        "balanceType": 0,
        "borrow": "0",
        "categoryType": "4",
        "createTime": 1677562801000,
        "currency": "CNY",
        "dealAccountName": "发给桂",
        "excelNum": "EX827940232547667969",
        "flowType": "微信",
        "lend": "15",
        "merchantOrder": "1000039801202111206044975791036",
        "orderNumber": "VM827940232547667968",
        "purposeCategory": "红包支出",
        "remark": "微信红包（单发）",
        "tradeDate": "2021-11-20 08:49:49",
        "tradeOrder": "100003980121112000054321977898679641",
        "tradeWay": "工商银行(5197)",
        "type": 1,
        "updateTime": 1677562801000
      }
    ]
  }
}