接口列表
- 说明:需要在header中传递Authorization,Authorization是主动获取的id_token或者access_token
公共header说明
| header key | 是否必填 | 默认值 | 说明 |
|---|---|---|---|
| Content-Type | 是 | 固定值:application/json | |
| Authorization | 是 | token值(id_token/或者access_token) | |
| Ignore-Warn | 否 | false | 用于忽略警告。新增或提交时等操作时会有警告导致接口失败,比如客户查重不通过、凭证余额出现赤字,Ignore-Warn=true时,会忽略相关警告,继续执行接口 |
| Save-As-Draft | 否 | false | 如果为true,新增单据时保存为草稿态,否则自动提交 |
对象标准接口
- 请求body结构说明 ,字段列表见数据字典
add接口 (beta)
-
写入单个对象数据接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/add
-
请求方式:POST
-
header参数
- 见公共header
-
参数说明:字段externalSystemCode/externalObjectType/externalObjectId 必填,externalObjectType+externalObjectId不能重复
-
参数示例(字段注释请以数据字典显示为准)
body:
{
"json":"{\n \"objectType\":\"RevenueConfirmation\",\n \"data\":{\n \"billType.name\":\"收入确认单\",\n \"businessType.name\":\"收入确认单立账\",\n \"businessDate\":\"2020-01-01\",\n \"customer.name\":\"李雷\",\n \"invoiceType.name\":\"增值税专用发票\",\n \"currency.name\":\"人民币\",\n \"exchangeRate\":1,\n \"settleCustomer.name\":\"李雷\",\n \"revenueConfirmationItems\":[\n {\n \"project.name\":\"应收项目1\",\n \"product.name\":\"B商品\",\n \"quantity\":5,\n \"price\":1000,\n \"priceWithoutTax\":917.43,\n \"taxRate\":0.09,\n \"originAmount\":5000,\n \"amount\":5000,\n \"originAmountWithoutTax\":4587.16,\n \"amountWithoutTax\":4587.16,\n \"originTaxAmount\":412.84,\n \"taxAmount\":412.84,\n \"originPriceWithoutTax\":917.43,\n \"unit.name\":\"箱\"\n },\n {\n \"project.name\":\"应收项目1\",\n \"product.name\":\"B商品\",\n \"quantity\":5,\n \"price\":1000,\n \"priceWithoutTax\":917.43,\n \"taxRate\":0.09,\n \"originAmount\":5000,\n \"amount\":5000,\n \"originAmountWithoutTax\":4587.16,\n \"amountWithoutTax\":4587.16,\n \"originTaxAmount\":412.84,\n \"taxAmount\":412.84,\n \"originPriceWithoutTax\":917.43,\n \"unit.name\":\"箱\"\n }\n ],\n \"externalObjectId\":1582709110221112331,\n \"externalObjectType\":\"RevenueConfirmation\",\n \"externalSystemCode\":\"110212001\"\n }\n}"
}
// json的value值:
{
"objectType": "RevenueConfirmation", // 目标对象名称:收入确认单
"data": { // 数据项
"billType.name": "收入确认单", // 单据类型
"businessType.name": "收入确认单立账", // 业务类型
"businessDate": "2020-01-01", // 业务日期
"customer.name": "李雷", // 客户名称
"invoiceType.name": "增值税专用发票", // 发票类型
"currency.name": "人民币", // 币种
"exchangeRate": 1, // 汇率
"settleCustomer.name": "李雷", // 结算单位
"revenueConfirmationItems": [ // 收入确认单明细
{
"project.name": "应收项目1", // 项目名称
"product.name": "B商品", // 存货名称
"quantity": 5, // 数量
"price": 1000.000, // 单价
"priceWithoutTax": 917.430, // 本币无税单价
"taxRate": 0.09, // 税率
"originAmount": 5000.000, // 金额
"amount": 5000.000, // 金额
"originAmountWithoutTax": 4587.16, // 原币无税金额
"amountWithoutTax": 4587.16, // 本币无税金额
"originTaxAmount": 412.84, // 原币税额
"taxAmount": 412.84, // 本币税额
"originPriceWithoutTax": 917.430, // 原币无税单价
"unit.name": "箱" // 计量单位名称
},
{
"project.name": "应收项目1", // 项目名称
"product.name": "B商品", // 存货名称
"quantity": 5, // 数量
"price": 1000.000, // 单价
"priceWithoutTax": 917.430, // 本币无税单价
"taxRate": 0.09, // 税率
"originAmount": 5000.000, // 金额
"amount": 5000.000, // 金额
"originAmountWithoutTax": 4587.16, // 原币无税金额
"amountWithoutTax": 4587.16, // 本币无税金额
"originTaxAmount": 412.84, // 原币税额
"taxAmount": 412.84, // 本币税额
"originPriceWithoutTax": 917.430, // 原币无税单价
"unit.name": "箱" // 计量单位名称
}
],
"externalObjectId": 1582709110221112331, // 外部系统对象唯一标识
"externalObjectType": "RevenueConfirmation", // 外部系统对象类型
"externalSystemCode": "110212001" // 外部系统标识
}
}
- 接口响应
{
"json": "{\"id\":\"RMUEH160PG9000M\"}"
}
list接口
-
查询数据接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/list
-
请求方式:POST
-
header参数
- 见公共header
-
参数示例
body:
{"json":"{\"objectType\":\"Customer\",\"page\":true,\"maxResult\":10,\"firstResult\":0,\"criteriaStr\":\"id is not null\",\"fields\":[\"id\",\"name\",{\"fieldName\":\"category\",\"fields\":[\"id\",\"name\"]},{\"fieldName\":\"contacts\",\"fields\":[\"id\",\"name\"]},\"code\"]}"}
// json的value值:
{
"objectType": "Customer", // 目标对象
"page": true, // 是否返回page信息
"maxResult": 10, // 返回最大行数
"firstResult": 0, // 从那一行开始查询 开始为0
"criteriaStr": "id is not null", // 查询参数 查询字段支持lastModifiedTime(TimeStamp)
"fields": [ // 查询字段列表
"id", // 主对象字段
"name", // 主对象字段
{
"fieldName": "category", // 外键字段 ps:如果字段有参照对照,如果字段名以id结尾,去掉id为fieldName,如果字段名不是以id结尾,字段名+Object为fieldName。此fieldName对应的字段为categoryId
"fields": [ // 外键字段对应对象字段列表
"id", // 外键字段对应对象字段
"name" // 外键字段对应对象字段
]
},
{
"fieldName": "contacts", // 外键字段对应对象子表
"fields": [ // 外键字段对应对象子表字段列表
"id", // 外键字段对应对象子表字段
"name" // 外键字段对应对象子表字段
]
},
"code" // 主对象字段
]
}
- 接口响应
{
"json": "{\"data\":{\"page\":{\"count\":134},\"list\":[{\"id\":\"XLWV090002\",\"name\":\"企企1\",\"category\":{\"id\":\"FDWV8X52C\",\"name\":\"内部商户\"},\"contacts\":[],\"code\":\"00001\"},{\"id\":\"5XSE4W000K\",\"name\":\"企企2\",\"category\":{\"id\":\"TKTEK001U\",\"name\":\"成都\"},\"contacts\":[],\"code\":\"00002\"}]},\"errors\":[]}"
}
json的value
{
"data": {
"page": { // 入参page=true时返回
"count": 134
},
"list": [
{
"id": "XLWV090002",
"name": "企企1",
"category": {
"id": "FDWV8X52C",
"name": "内部商户"
},
"contacts": [],
"code": "00001"
},
{
"id": "5XSE4W000K",
"name": "企企2",
"category": {
"id": "TKTEK001U",
"name": "成都"
},
"contacts": [],
"code": "00002"
}
]
},
"errors": []
}
update接口
-
数据更新接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/update
-
请求方式:PUT
-
header参数
- 见公共header
-
参数示例
body:
{
"json": "{
\"objectType\":\"Customer\",
\"data\":{
\"id\":\"633GUN505MB0108\",
\"categoryId\":\"89B1GN505UR0002\",
\"code\":\"1002000001\",
\"contacts\":[
{
\"id\":\"A5UK0R50LNT0027\",
\"mobile\":\"18988889997\",
\"editFlag\":\"update\"
},
{
\"isPrimary\":false,
\"name\":\"张三\",
\"mobile\":\"13565678898\",
\"isCooperated\":false,
\"editFlag\":\"add\"
}
],
\"addresses\":[
{
\"address\":\"\",
\"isDefault\":true,
\"id\":\"A5UK0R50LNT0026\",
\"editFlag\":\"update\",
\"countryId\":\"\",
\"districtId\":\"\"
}
]
}
}"
}
// json的value值
{
"objectType":"Customer", // 目标对象类型
"data":{ // 目标对象数据
"id":"633GUN505MB0108", // 目标对象id:必需指定
"categoryId":"89B1GN505UR0002",
"code":"1002000001",
"contacts":[ // 子对象
{
"id":"A5UK0R50LNT0027", // 子对象id:如果是更新,则必需指定
"mobile":"18988889997",
"editFlag":"update" // 子对象操作标记:update->更新(需指定子对象id) add->新增 delete->删除, 默认为add
},
{
"isPrimary":false,
"name":"12",
"mobile":"13565678898",
"isCooperated":false,
"editFlag":"add"
}
],
"addresses":[
{
"address":"",
"isDefault":true,
"id":"A5UK0R50LNT0026",
"editFlag":"update",
"countryId":"",
"districtId":""
}
]
}
}
- 接口响应
{
"json": "{\"success\":true}"
}
审批中修改接口
- 数据更新接口
- 接口host:https://api2.77hub.com
- 接口路径:/v2/approvingUpdate
- 请求方式:PUT
- 参数:和上面/update接口完全一致
delete接口
-
数据删除接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/delete
-
请求方式:POST
-
header参数
- 见公共header
-
参数示例
body:
{
"json": "{
\"objectType\":\"Customer\",
\"objectId\":\"SDFASFF00010999\"
}"
}
//json的value值:
{
"objectType": "Customer", // 目标对象类型
"objectId": "SDFASFF00010999" // 目标数据id
}
- 接口响应
{
"json": "{\"success\":true}"
}
addAutoSubmit接口 (beta)
- 写入单个对象数据接口,自动提交
- 接口host:https://api2.77hub.com
- 接口路径:/v2/addAutoSubmit
- 说明:参数及响应和add接口保持一致,新增后自动提交,提交任务结束后接口返回,提交失败自动删除单据,单据可能删除失败
{
"openid": "openid128kjsiiyysdlq7"
}
企业信息接口
- 接口host:https://api2.77hub.com
- 接口路径:/v2/tenant
- 请求方式:GET
- header参数
- 见公共header
- 接口响应
{
"id": "1",
"name": "北京企企科技有限公司",
"error": ""
}
用户信息接口
- 接口描述:获取授权用户信息
- 接口host:https://api2.77hub.com
- 接口路径:/v2/user
- 请求方式:GET
- header参数
- 见公共header
- 接口响应
{
"id":"J32NV555ETN0023",
"name":"王小二",
"mobile":"13900000000",
"email":"",
"tenantName":"北京企企科技有限公司",
"gender":""
}
异步弃审接口
- 接口host:https://api2.77hub.com
- 接口路径:/v2/withdraw
- 请求方式:POST
- header参数
- 见公共header
- 请求参数
- objectType:弃审的目标对象
- objectId:弃审的目标id
- reason:弃审原因
{
"objectType":"RevenueConfirmation",
"objectId":"0BX0JM5015D0001",
"reason":"弃审原因"
}
- 接口响应
- runningIds:执行中的id列表
- requestId:请求id,使用此参数查询异步任务执行状态
- failIds:执行失败的id及对应失败信息
{
"json":"{\"runningIds\":[\"LQ2AK161U2H002S\"],\"successIds\":[],\"failIds\":{},\"warningIds\":{},\"userTaskActionValue\":\"manualWithdraw\",\"objectType\":\"RevenueConfirmation\",\"failedCount\":0,\"runningCount\":1,\"successCount\":0,\"warningCount\":0,\"totalCount\":1,\"taskId\":\"W9CAK161U2H002F\",\"isCompleted\":false,\"requestId\":\"time-df78f9c4-267e-4cbe-abcd-8ae2c796bbfb\"}"
}
{
"runningIds":[
"LQ2AK161U2H002S"
],
"successIds":[
],
"failIds":{
},
"warningIds":{
},
"userTaskActionValue":"manualWithdraw",
"objectType":"RevenueConfirmation",
"failedCount":0,
"runningCount":1,
"successCount":0,
"warningCount":0,
"totalCount":1,
"taskId":"W9CAK161U2H002F",
"isCompleted":false,
"requestId":"time-df78f9c4-267e-4cbe-abcd-8ae2c796bbfb"
}
异步任务状态查询接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/asynctask
-
请求方式:POST
-
header参数
- 见公共header
-
请求参数
- requestId:异步接口响应的requestId
body:
{
"requestId":"time-5969aedb-e32a-4913-8da8-5a4d7ac3ad1b"
}
-
接口响应
- isCompleted:是否完成
- asyncTaskItems:异步任务项
- asyncTaskItemStatusObject:异步任务项状态
- lastErrorMsg:错误消息
{
"requestId":"",
"isCompleted":true,
"asyncTaskItems":[
{
"id":"W9CAK161U2H002K",
"billStatusObject":{
"id":"BillStatus.effective",
"title":"已生效"
},
"objectType":"RevenueConfirmation",
"objectId":"LQ2AK161U2H002S",
"asyncTaskItemStatus":"AsyncTaskItemStatus.succeeded",
"asyncTaskItemStatusObject":{
"id":"AsyncTaskItemStatus.succeeded",
"title":"成功"
},
"lastErrorMsg":"null",
"isRead":false
}
]
}
同步任务接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/batchDo
-
请求方式:POST
-
header参数
- 见公共header
-
请求参数
- objectType:目标对象
- objectId:目标id
- action:执行动作,目前支持的动作:
| 动作 | 描述 |
|---|---|
| manualSubmit | 提交 |
| userAgree | 同意 |
| userDeny | 驳回 |
| userBack | 驳回到上一级 |
| manualOpen | 打开 |
| manualClose | 关闭 |
| manualRestart | 撤回 |
| manualWithdraw | 弃审 |
{
"objectType":"Receipt",
"objectId":"J81N8S512DM000E",
"action":"manualSubmit",
"reason":"原因"
}
- 接口响应
- successIds:执行成功的id
- failIds:执行失败的id及对应失败信息
{
"json":"{\"successIds\":[],\"failIds\":{\"9GN9K161U2H001W\":{\"type\":\"error\",\"code\":\"0000\",\"message\":\"只有待提交,已退回的单据可以提交\"}},\"warningIds\":{}}"
}
异步任务接口
-
接口host:https://api2.77hub.com
-
接口路径:/v2/asyncBatchDo
-
请求方式:POST
-
header参数
- 见公共header
-
请求参数
- objectType:目标对象
- objectId:目标id
- closedBizDate:关闭日期,单位毫秒,关闭时必填
- action:执行动作,目前支持的动作:
| 动作 | 描述 |
|---|---|
| manualSubmit | 提交 |
| userAgree | 同意 |
| userDeny | 驳回 |
| userBack | 驳回到上一级 |
| manualOpen | 打开 |
| manualClose | 关闭 |
| manualRestart | 撤回 |
| manualWithdraw | 弃审 |
{
"objectType":"Receipt",
"objectId":"J81N8S512DM000E",
"action":"manualSubmit",
"reason":"原因",
"closedBizDate": "1738944000000" // 关闭日期,单位毫秒,关闭时必填
}
- 接口响应
- runningIds :执行中的id列表
- requestId:请求id,使用此参数查询异步任务执行状态
- failIds:执行失败的id及对应失败信息
{
"json":"{\"runningIds\":[\"H5WXH161U2H000H\"],\"successIds\":[],\"failIds\":{},\"warningIds\":{},\"userTaskActionValue\":\"manualWithdraw\",\"objectType\":\"RevenueConfirmation\",\"failedCount\":0,\"runningCount\":1,\"successCount\":0,\"warningCount\":0,\"totalCount\":1,\"taskId\":\"H5WXH161U2H0024\",\"isCompleted\":false,\"requestId\":\"time-50ca75b8-feb1-4fba-9bc3-f6008e322517\"}"
}
文件签名接口
- 接口host:https://api2.77hub.com
- 接口路径:/v2/attachment/signature/signedurl
- 请求方式:GET
- header参数
- 见公共header
- 请求参数
- key:目标文件key,必填
- isHttp:true返回http协议URL,否则返回https协议URL,默认false
- expiresIn:URL过期时间,单位秒,默认7天
- 接口响应
- url:文件URL
{"url":"https://www.77hub.com/"}
文件批量签名接口
- 接口host:https://api2.77hub.com
- 接口路径:/v2/attachment/signature/batchSignedUrl
- 请求方式:POST
- header参数
- 见公共header
- 请求参数
- keys:目标文件key,必填
- isHttp:true返回http协议URL,否则返回https协议URL,默认false
- expiresIn:URL过期时间,单位秒,默认7天
{
"json": "{\"keys\":[\"1\",\"2\"],\"isHttp\":false,\"expiresIn\":3600}"
}
- 接口响应
- key为文件key,value为下载url
{
"json": "{\"1\":\"https://openapi.77hub.com/1\",\"2\":\"https://openapi.77hub.com/2\"}"
}
文件上传签名
-
接口host:https://api2.77hub.com
-
接口路径:/v2/attachment/signature/post
-
请求方式:GET
-
header参数
- 见公共header
-
请求参数
- fileName:待上传的文件名,必填
-
接口响应
{
"json": "{\n \"fields\": {\n \"x-amz-date\": \"20240606T062602Z\",\n \"x-amz-signature\": \"bf298741bbe5857cf19bda02d2060b2bfb5361d7795a3c96b50c17007a223873\",\n \"x-amz-meta-extension\": \"pdf\",\n \"Content-Disposition\": \"filename*=UTF-8''test.pdf\",\n \"x-amz-meta-name\": \"test.pdf\",\n \"acl\": \"bucket-owner-full-control\",\n \"key\": \"47l0lp505840001/2024/06/9dd4ae0e-8c4d-48f5-b0cf-5b7463240920.pdf\",\n \"x-amz-algorithm\": \"AWS4-HMAC-SHA256\",\n \"x-amz-credential\": \"AKIAYOSUOUKKR3KDSWNP/20240606/cn-northwest-1/s3/aws4_request\",\n \"Content-Type\": \"application/pdf\",\n \"policy\": \"eyAgICAgICJleHBpcmF0aW9uIjogIjIwMjQtMDYtMDZUMDc6MjY6MDIuMTA1WiIsCiAgICAgICJjb25kaXRpb25zIjogW3siYnVja2V0IjoiY24tbm9ydGh3ZXN0LTEtcTdsaW5rLXRlc3QifSx7IngtYW16LWRhdGUiOiIyMDI0MDYwNlQwNjI2MDJaIn0seyJ4LWFtei1tZXRhLWV4dGVuc2lvbiI6InBkZiJ9LHsiQ29udGVudC1EaXNwb3NpdGlvbiI6ImZpbGVuYW1lKj1VVEYtOCcndGVzdC5wZGYifSx7IngtYW16LW1ldGEtbmFtZSI6InRlc3QucGRmIn0seyJhY2wiOiJidWNrZXQtb3duZXItZnVsbC1jb250cm9sIn0seyJrZXkiOiI0N2wwbHA1MDU4NDAwMDEvMjAyNC8wNi85ZGQ0YWUwZS04YzRkLTQ4ZjUtYjBjZi01Yjc0NjMyNDA5MjAucGRmIn0seyJ4LWFtei1hbGdvcml0aG0iOiJBV1M0LUhNQUMtU0hBMjU2In0seyJ4LWFtei1jcmVkZW50aWFsIjoiQUtJQVlPU1VPVUtLUjNLRFNXTlAvMjAyNDA2MDYvY24tbm9ydGh3ZXN0LTEvczMvYXdzNF9yZXF1ZXN0In0seyJDb250ZW50LVR5cGUiOiJhcHBsaWNhdGlvbi9wZGYifV0KICAgIH0=\"\n },\n \"url\": \"https://s3.cn-northwest-1.amazonaws.com.cn/cn-northwest-1-q7link-test\"\n}"
} -
json内部结构
{
"fields": {
"x-amz-date": "20240606T062602Z",
"x-amz-signature": "bf298741bbe5857cf19bda02d2060b2bfb5361d7795a3c96b50c17007a223873",
"x-amz-meta-extension": "pdf",
"Content-Disposition": "filename*=UTF-8''test.pdf",
"x-amz-meta-name": "test.pdf",
"acl": "bucket-owner-full-control",
"key": "47l0lp505840001/2024/06/9dd4ae0e-8c4d-48f5-b0cf-5b7463240920.pdf",
"x-amz-algorithm": "AWS4-HMAC-SHA256",
"x-amz-credential": "AKIAYOSUOUKKR3KDSWNP/20240606/cn-northwest-1/s3/aws4_request",
"Content-Type": "application/pdf",
"policy": "eyAgICAgICJleHBpcmF0aW9uIjogIjIwMjQtMDYtMDZUMDc6MjY6MDIuMTA1WiIsCiAgICAgICJjb25kaXRpb25zIjogW3siYnVja2V0IjoiY24tbm9ydGh3ZXN0LTEtcTdsaW5rLXRlc3QifSx7IngtYW16LWRhdGUiOiIyMDI0MDYwNlQwNjI2MDJaIn0seyJ4LWFtei1tZXRhLWV4dGVuc2lvbiI6InBkZiJ9LHsiQ29udGVudC1EaXNwb3NpdGlvbiI6ImZpbGVuYW1lKj1VVEYtOCcndGVzdC5wZGYifSx7IngtYW16LW1ldGEtbmFtZSI6InRlc3QucGRmIn0seyJhY2wiOiJidWNrZXQtb3duZXItZnVsbC1jb250cm9sIn0seyJrZXkiOiI0N2wwbHA1MDU4NDAwMDEvMjAyNC8wNi85ZGQ0YWUwZS04YzRkLTQ4ZjUtYjBjZi01Yjc0NjMyNDA5MjAucGRmIn0seyJ4LWFtei1hbGdvcml0aG0iOiJBV1M0LUhNQUMtU0hBMjU2In0seyJ4LWFtei1jcmVkZW50aWFsIjoiQUtJQVlPU1VPVUtLUjNLRFNXTlAvMjAyNDA2MDYvY24tbm9ydGh3ZXN0LTEvczMvYXdzNF9yZXF1ZXN0In0seyJDb250ZW50LVR5cGUiOiJhcHBsaWNhdGlvbi9wZGYifV0KICAgIH0="
},
"url": "https://s3.cn-northwest-1.amazonaws.com.cn/cn-northwest-1-q7link-test"
}
文件上传说明
1. 通过接口请求文件上传签名
2. 解析响应中json的内部结构,拿到fields和url
3. 构建post请求,将fields作为请求参数,选择目标文件,将请求发送到上述url
4. fields中的key为文件唯一标识,将key保存到企企附件中或进行其他操作
查询执行进度
-
接口host:https://api2.77hub.com
-
接口路径:/v2/usertask
-
请求方式:POST
-
header参数
- 见公共header
-
请求参数
- objectId:单据对象id
body:
{"objectId":"UGG9K161U2H000J"}
-
接口响应
- 待审批
[
{
"taskName": "财务经理审批", // 任务名称
"description": "", // 审批意见
"actionDate": 0, // 执行时间
"action": "待审批", // 当前动作
"userNames": "张三,王世强", // 用户
"isActed": false // 是否已执行
},
{
"taskName": "设置已提交",
"description": "",
"actionDate": 1631520004004,
"action": "提交",
"userNames": "王世强",
"isActed": true
}
]- 已生效
[
{
"taskName": "设置已生效",
"description": "",
"actionDate": 1631517743882,
"action": "生效",
"userNames": "王世强",
"isActed": true
},
{
"taskName": "财务经理审批",
"description": "这是同意意见",
"actionDate": 1631517740929,
"action": "同意",
"userNames": "王世强",
"isActed": true
},
{
"taskName": "设置已提交",
"description": "",
"actionDate": 1631517712289,
"action": "提交",
"userNames": "王世强",
"isActed": true
}
]
查询报表
-
接口host:https://api2.77hub.com
-
接口路径:/v2/reportdefinition
-
请求方式:POST
-
header参数
- 见公共header
-
请求参数
- params:json字符串(将json对象转义)
{
"params": "{\"id\":\"F5M8PQ50FKF0002\",\"outputType\":\"json\",\"queryObject\":{\"criteria\":{\"operator\":\"and\",\"values\":[{\"operator\":\"in\",\"values\":[\"K4WUXS50JUD0011\"],\"fieldName\":\"ownerExpenceOrg\",\"properties\":{\"isDefaultQueryTreeRootOnly\":false,\"isIncludeChildren\":false,\"isOrganizationRole\":true,\"orgRoleTypeIds\":[\"FinancialOrg\"]}},{\"operator\":\"between\",\"values\":[1609430400000,1640966399999],\"fieldName\":\"reimburseReportView.businessDate\",\"type\":\"Timestamp\"},{\"operator\":\"eq\",\"values\":[\"NUE2UQ50FKF0001\"],\"fieldName\":\"cost\"}]}}}"
}{// params结构详情
"id":"F5M8PQ50FKF0002", // 方案id
"outputType":"json", // 输出类型为json, 支持的类型:json/excel/pdf
"queryObject":{
"criteria":{ // 查询条件
"operator":"and", // 多条件间关系
"values":[
{ // 此条件解释为:ownerExpenceOrg in ('K4WUXS50JUD0011')
"operator":"in", // 支持in、eq(=)、like、gt(>)、ge(>=)等
"values":[
"K4WUXS50JUD0011"
],
"fieldName":"ownerExpenceOrg",
"properties":{
"isDefaultQueryTreeRootOnly":false,
"isIncludeChildren":false,
"isOrganizationRole":true,
"orgRoleTypeIds":[
"FinancialOrg"
]
}
},
{ // 此条件解释为:reimburseReportView.businessDate between 1609430400000 and 1640966399999
"operator":"between",
"values":[
1609430400000,
1640966399999
],
"fieldName":"reimburseReportView.businessDate",
"type":"Timestamp"
},
{ // 此条件解释为:cost = 'NUE2UQ50FKF0001'
"operator":"eq",
"values":[
"NUE2UQ50FKF0001"
],
"fieldName":"cost"
}
]
}
}
} -
接口响应
- data:json数据
- error:错误信息
- 示例(outputType=json)
错误返回结果:
{
"error": "{\"type\":\"error\",\"code\":\"0008\",\"message\":\"对象没有找到\",\"description\":\"report definition not found for id: F5M8PQ50FKF0002\"}"
}
正确返回结果:
{
"data": "{ \"data\":{ \"title\":\"用户权益分配\", \"pageSettings\":{ \"titleFontSize\":16, \"titleAlign\":\"center\", \"fontSize\":10, \"subTitleFontSize\":12, \"subTitleAlign\":\"center\", \"minFontSize\":4, \"maxFontSize\":32, \"entLogoHeight\":22.677166, \"pageHeaderFontSize\":8, \"isPreview\":false, \"starPageNum\":1, \"pageRotate\":false, \"pageMargins\":[ 30, 30, 30, 30 ], \"cellPaddings\":[ 2, 2, 0, 2 ], \"adjustMinColumnSize\":30, \"isFillBlankRow\":false, \"isPageSubtotal\":false, \"isPageTotal\":false }, \"corners\":[ ], \"rows\":[ ], \"cols\":[ [ { \"startRowIndex\":0, \"startColIndex\":12, \"rowIndex\":0, \"colIndex\":12, \"rowSpan\":1, \"colSpan\":1, \"displayValue\":\"角色\", \"cellType\":\"colTitle\", \"aliasField\":\"roleName_TenantRightsAssignmentView\", \"aliasName\":\"roleName_TenantRightsAssignmentView\" } ] ], \"datas\":[ [ \"查询服务\", \"\", \"模组授权\", \"12.00\", \"50.00\", \"张三\", \"用户授权\", \"YG009\", \"在职\", \"测试四部\", \"18000595971\", \"\", \"系统用户\", \"UserStatus.incumbent\" ] ], \"metas\":{ }, \"totalRows\":[ ], \"dimSubTotalRows\":{ }, \"styleIdMap\":{ }, \"rowCondStyleIds\":{ }, \"totalCols\":[ ], \"dimSubTotalCols\":{ }, \"rowTotalDimInfo\":{ }, \"columns\":[ { \"width\":100, \"alignment\":\"left\", \"type\":\"String\" } ], \"layout\":[ \"moduleGroupId_TenantRightsAssignmentView\", \"moduleGroupAppId_TenantRightsAssignmentView\", \"authType_TenantRightsAssignmentView\", \"usedQty_TenantRightsAssignmentView\", \"acquiredQty_TenantRightsAssignmentView\", \"userName_TenantRightsAssignmentView\", \"grantType_TenantRightsAssignmentView\", \"userCode_TenantRightsAssignmentView\", \"userStatusTitle_TenantRightsAssignmentView\", \"userDepartmentName_TenantRightsAssignmentView\", \"userMobile_TenantRightsAssignmentView\", \"userEmail_TenantRightsAssignmentView\", \"roleName_TenantRightsAssignmentView\" ], \"dataIndexes\":{ \"moduleGroupId_TenantRightsAssignmentView\":0, \"moduleGroupAppId_TenantRightsAssignmentView\":1, \"authType_TenantRightsAssignmentView\":2, \"usedQty_TenantRightsAssignmentView\":3, \"acquiredQty_TenantRightsAssignmentView\":4, \"userName_TenantRightsAssignmentView\":5, \"grantType_TenantRightsAssignmentView\":6, \"userCode_TenantRightsAssignmentView\":7, \"userStatusTitle_TenantRightsAssignmentView\":8, \"userDepartmentName_TenantRightsAssignmentView\":9, \"userMobile_TenantRightsAssignmentView\":10, \"userEmail_TenantRightsAssignmentView\":11, \"roleName_TenantRightsAssignmentView\":12, \"userStatus\":13 }, \"extDatas\":[ ], \"extDataIndexes\":{ } }, \"reportMessages\":{ }}"
}
{
// data下结构详情
"data":{
"title":"用户权益分配",
"pageSettings":{
"titleFontSize":16,
"titleAlign":"center",
"fontSize":10,
"subTitleFontSize":12,
"subTitleAlign":"center",
"minFontSize":4,
"maxFontSize":32,
"entLogoHeight":22.677166,
"pageHeaderFontSize":8,
"isPreview":false,
"starPageNum":1,
"pageRotate":false,
"pageMargins":[
30,
30,
30,
30
],
"cellPaddings":[
2,
2,
0,
2
],
"adjustMinColumnSize":30,
"isFillBlankRow":false,
"isPageSubtotal":false,
"isPageTotal":false
},
"corners":[ // Corner区域数据,同cols
],
"rows":[ // // 列维度区域数据,同cols
],
"cols":[ // 列维度区域数据,二维数组,表示有m行n列的列维度数据
[
"查询服务",
"",
"模组授权",
"12.00",
"50.00",
"周小七",
"用户授权",
"1111110004",
"",
"总部",
"15386620539",
"",
"系统用户",
""
]
],
"metas":{
},
"totalRows":[ // 合计行索引
],
"dimSubTotalRows":{
},
"styleIdMap":{
},
"rowCondStyleIds":{
},
"totalCols":[ // 合计列索引
],
"dimSubTotalCols":{
},
"rowTotalDimInfo":{
},
"columns":[. // 所有列的布局信息(包括行维度列)
{
"width":100, // 列宽
"alignment":"left", // 对其方式
"type":"String". // 值类型
}
],
"layout":[
"moduleGroupId_TenantRightsAssignmentView",
"moduleGroupAppId_TenantRightsAssignmentView",
"authType_TenantRightsAssignmentView",
"usedQty_TenantRightsAssignmentView",
"acquiredQty_TenantRightsAssignmentView",
"userName_TenantRightsAssignmentView",
"grantType_TenantRightsAssignmentView",
"userCode_TenantRightsAssignmentView",
"userStatusTitle_TenantRightsAssignmentView",
"userDepartmentName_TenantRightsAssignmentView",
"userMobile_TenantRightsAssignmentView",
"userEmail_TenantRightsAssignmentView",
"roleName_TenantRightsAssignmentView"
],
"dataIndexes":{. // 值为对应的值在datas中的索引
"moduleGroupId_TenantRightsAssignmentView":0,
"moduleGroupAppId_TenantRightsAssignmentView":1,
"authType_TenantRightsAssignmentView":2,
"usedQty_TenantRightsAssignmentView":3,
"acquiredQty_TenantRightsAssignmentView":4,
"userName_TenantRightsAssignmentView":5,
"grantType_TenantRightsAssignmentView":6,
"userCode_TenantRightsAssignmentView":7,
"userStatusTitle_TenantRightsAssignmentView":8,
"userDepartmentName_TenantRightsAssignmentView":9,
"userMobile_TenantRightsAssignmentView":10,
"userEmail_TenantRightsAssignmentView":11,
"roleName_TenantRightsAssignmentView":12,
"userStatus":13
},
"extDatas":[
],
"extDataIndexes":{
}
},
"reportMessages":{
}
}
- 示例(outputType=excel)
{
"data": "\"https://openapi.77hub.com/static/images/logo_color.svg\"",
"error": ""
}
- 示例(outputType=pdf)
{
"data": "\"https://openapi.77hub.com/static/images/logo_color.svg\"",
"error": ""
}
项目变更
- 接口host:https://api2.77hub.com
- 接口路径:/v2/changeproject
- 请求方式:PUT
- header参数
- 见公共header
- 请求参数
- json:json字符串(将json对象转义)
{"json": "{\"data\":{\"id\":\"F5M8PQ50FKF0002\", \"description\": \"修改描述\"}}"}
{ // json结构
"data": { // 项目对象
"id": "F5M8PQ50FKF0002", // 项目id
"description": "修改描述" // 变更的项目字段
}
}
- 接口响应
- data:json数据
- error:错误信息
{
"json": "{\"success\":true}",
"error": ""
}
单据增量变更
- 接口host:https://api2.77hub.com
- 接口路径:/v2/changeBill
- 请求方式:POST
- header参数
- 见公共header
- 请求参数
- json:json字符串(将json对象转义)
{
"json": "{\n \"objectType\": \"ArContract\",\n \"data\": {\n \"id\": \"AX16P86402A0095\",\n \"name\": \"测试合同\"\n }\n}"
}
{
"objectType": "ArContract",// 对象类型
"data": {
"id": "AX16P86402A0095", // 对象id
"name": "测试合同" // 数据项
}
}
- 接口响应
- data:json数据
- error:错误信息
{
"json": "{\"success\":true}",
"error": ""
}
工作日类型
-
接口host:https://api2.77hub.com