代码拉取完成,页面将自动刷新
管理员登陆云之家报表秀秀Web端后台,左下角点击“API信息”获取。
{
"data": “AES加密后参数信息""
}
示例:
{
"data": "aQeU3beqnhk6gP7V3fXELrk9a/9vHHfXXNSTGlOOq/eu4/0p3rkaEyKw/L2214sVPEbFNQSucs1ke6E9WBu0uw=="
}
{
"data": "AES加密后结果",
"success": 是否成功 //true,false,
"error": "错误信息, //成功时为空",
"errorCode": 错误码, //成功时为0
}
示例:
{
"data": "Ajl2Iobg0+OGjRMnSEzWGQ5RwhfHUMCMQWCU31d6F9s=",
"success": true,
"error": "鉴权信息数据获取失败!",
"errorCode": 401
}
使用sha1将参数使用ASCII 码从小到大排序(字典序)后生成签名
Object[] list = new Object[]{"param1","param2","param3"};
Arrays.sort(list);
String sign = DigestUtils.shaHex(StringUtils.join(list));
例如接口请求参数为:{appId:xxxx,nonceStr:xxxx,signature:xxxx,timestamp:xxxx}
String appId = "xxxx",secret = "xxxxx",nonceStr ="xxxx",timestamp = "xxxxx";
Object[] list = new Object[]{appId,secret,nonceStr,timestamp};
Arrays.sort(list);
String sign = DigestUtils.shaHex(StringUtils.join(list));
最终signature的值为例子中的sign 备注:接口中提到需要sha1签名的,除了signature参数不参与签名,其他参数都需要参与外,另外还需要加上应用的secret,签名结果即为signature参数的值
postMan签名方式: 在Pre-request Scripts中添加如下代码即可:
var appId = "xxxxx",secret = "xxxx";
var data = {"appId":appId,"nonceStr":Math.random().toString(36).substr(2),"timestamp":Date.now()};
var list = [];
for(var k in data){
list.push(data[k]);
}
list.push(secret);
list.sort();
data["signature"] = CryptoJS.SHA1(list.join("")).toString();
postman.setEnvironmentVariable("shenpidata",JSON.stringify(data));
在request body raw中加入以下内容,并将内容设置为application/json:
{{shenpidata}}
{appId:xxxx,nonceStr:xxxx,signature:xxxx,timestamp:xxxx}
备注:signature由sha1签名算法得到,该接口为企业自建应用获取团队accessToken
{
"data": {
accessToken:accessToken,
expireIn:有效时间(秒),
refreshToken:token刷新令牌
},
"errorCode": 0,
"success": true
}
示例:
{
"data": {
"accessToken": "kuIpBlqyskChznZyJZq4A2ulCPVm2QPt",
"expireIn": 7200,
"refreshToken": "goaUXEEKYqzPzoSlXWTY03wrkx6FM9mQ"
},
"errorCode": 0,
"success": true
}
{appId:xxxx,refreshToken:xxx,nonceStr:xxxx,signature:xxxx,timestamp:xxxx}
备注:signature由sha1签名算法得到
{
"data": {
accessToken:accessToken,
expireIn:有效时间(秒),
refreshToken:token刷新令牌
},
"errorCode": 0,
"success": true
}
示例:
{
"data": {
"accessToken": "kuIpBlqyskChznZyJZq4A2ulCPVm2QPt",
"expireIn": 7200,
"refreshToken": "goaUXEEKYqzPzoSlXWTY03wrkx6FM9mQ"
},
"errorCode": 0,
"success": true
}
{"eid":"企业工作圈信息" }
示例:
{"eid":"6826231"}
[
{
"id": "报表分类ID",
"name": "报表分类名称",
"tableInfos": [
{
"dataUpdateTime": 数据最后更新时间
"id": "数据表ID",
"name": "数据表名称"
}
]
}
]
示例:
[
{
"id": "59ce14c8d026670fe482b534",
"name": "财务(示例)",
"tableInfos": [
{
"dataUpdateTime": 1506678722531,
"id": "59ce1599d02667072b08b9c1",
"name": "自定义api导入测试"
}
]
},
{
"id": "59ce14c8d026670fe482b532",
"name": "销售(示例)",
"tableInfos": [
{
"dataUpdateTime": 1506678722531,
"id": "59ce1599d02667072b08b9c2",
"name": "自定义api导入测试1"
}
]
}
]
备注:1.本接口获取的数据为所有应用管理员报表分类数据,请确保当前账号有查看报表分类权限,否则创建的数据表将无法被当前账号查看到 2.数据表tableInfos内容为通过API接口方式创建,非API接口创建的数据表不在查询之列
{
"eid": "企业工作圈信息",
"name": "数据表名称",
"reportCategoryId": "报表分类ID",
"headerItems": [
{
"name": "表头栏位名称",
"dataType": "表头栏位类型" // 目前支持string(字符串),number(数字),timestamp(时间)
}
]
}
示例:
{
"eid": "6826231",
"name": "自定义API导入测试",
"reportCategoryId": "59cdae43d5ad7912a47b968a",
"headerItems": [
{ "name":"recordId",
"dataType":"string"
},
{
"name": "表头1",
"dataType": "string"
},
{
"name": "表头2",
"dataType": "number"
},
{
"name": "表头3",
"dataType": "timestamp"
}
]
}
{"tableInfoId":"新建数据表ID" }
示例:
{"tableInfoId":"59cdbbf4d5ad790605e1ba4f"}
{
"eid": "企业工作圈信息",
"actionId":"操作ID", //一个数据表上传的所有数据为一个操作,一个操作对应多个批次
"batchId": "批次ID", //每个批次不同的唯一ID,用于数据上传状态查询
"reportCategoryId": "报表分类ID",
"tableInfoId": "数据表ID",
"data": [
{
"表头栏位名称": "数据",//表头数据必须与表头栏位名称一一对应,
且与定义的数据类型相符
}
]
}
示例:
{
"eid": "6826231",
"actionId": "5af42aa98704765e0a265d28",
"batchId": "5934b509570f227420998d3b",
"reportCategoryId": "59cdae43d5ad7912a47b968a",
"tableInfoId": "59cdbbf4d5ad790605e1ba4f",
"data": [
{
"recordId":"XSDD0000001",
"表头1": "中国",
"表头2": "100",
"表头3": "2008-08-08 20:00:00"
},
{
"recordId":"XSDD0000002",
"表头1": "美国",
"表头2": "80"",
"表头3": "2009-08-07 20:00:00"
},
{
"recordId":"XSDD0000003",
"表头1": "法国",
"表头2": "60"",
"表头3": "2011-07-08 20:00:00"
}
]
}
{
"errorCode": 错误码,
"success": 接口调用结果 //true,false
}
示例:
{
"errorCode": 0,
"success": true
}
{
"eid": "企业工作圈信息",
"batchIds": "批次ID,多个ID逗号分隔"
}
示例:
{
"eid": "6826231",
"batchIds": "5934b509570f227420998d3c,5934b509570f227420998d3b"
}
[
{
"batchId": "批次ID"
"status": 执行状态 //0:执行中,1:执行成功,2:执行异常,
"error": "错误信息"
}
]
示例:
[
{
"batchIds": "5934b509570f227420998d3c",
"status": 1,
"error": ""
},
{
"batchIds": "5934b509570f227420998d3b",
"status": 2,
"error": "数据上传失败!"
}
]
{
"eid": "企业工作圈信息",
"tableInfoId": "数据表ID",
"actionId":"操作ID", //与上传数据操作ID相同
}
示例:
{
"eid": "6824227",
"tableInfoId": "59fb0af3b65a1864e1b6105a",
"actionId": "5af42aa98704765e0a265d28"
}
{
"errorCode": 错误码,
"success": 接口调用结果 //true,false
}
示例:
{
"errorCode": 0,
"success": true
}
{
"eid": "企业工作圈信息",
"tableInfoId": "数据表ID"
}
示例:
{
"eid": "6824227",
"tableInfoId": "59fb0af3b65a1864e1b6105a"
}
{
"errorCode": 错误码,
"success": 接口调用结果 //true,false
}
示例:
{
"errorCode": 0,
"success": true
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。