功能说明:根据表单id,工单ids查询数据,(其他参数将在请求数据格式定义中详细说明)获取表单填写情况的详细数据接口。
2022年10月起将停止维护此接口,请换用新接口替代
请求方式:POST(HTTPS)
请求地址:https://qwif.do1.com.cn/qwcgi/api/apiForm/getFormData.do?token=token&corpId=corpId&id=id&ids=ids
参数名 |
释义 |
类型 |
是否必须 |
备注 |
---|---|---|---|---|
corpId |
公司唯一标识 |
String |
是 |
|
id |
表单id |
String |
是 |
|
ids |
表单数据id |
Array |
是 |
推送数据返回的id 格式:ids=id1&ids=id2 |
token |
用于验证 |
String |
是 |
FormApi api = QwSdkUtil.getInter(FormApi.class); // 调用接口 GetFormDataResultVO formData = api.getFormData(QwSdkUtil.getCacheToken(), //表单id "表单id" // 工单id数组 ,new String[]{"work工单id"}); System.out.println(JSONUtil.objectToString(formData));
{ "code":"0", "data": { "currPage":1, "maxPage":1, "pageData": [ { "approvers":"xxx", "auditLogVOList": [ { "auditStatus":"1", "auditTime":"2019-01-17 14:51:16", "foreignId":"work45856a558a354df1913d4e3c35d859ce", "id":"8967", "personName":"double" }, { "auditStatus":"5", "auditTime":"2019-01-17 20:59:21", "foreignId":"work45856a558a354df1913d4e3c35d859ce", "id":"8968", "personName":"一指流沙", "remark":"同意。" } ], "closePerson":"一指流沙", "closeTime":"2019-01-17 20:59:21", "createaTime":"2019-01-17 14:51:16", "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "departmentName":"事业二部;一级部门->二级部门->三级部门", "formItemDefinitionsVO": [ { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foed82c09f38da43f7a93cfcfcf4899750", "itemName":"单行文字", "itemType":"TextField", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"单行文字", "type":"TextField", "unique":false }, "valueStrs": [ { "valueStr":"qqq" } ] }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"fo7cfe21693ba1424b99e6275ff773eec0", "itemName":"单项选择", "itemType":"RadioButton", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"单项选择", "type":"RadioButton", "unique":false } }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"fo7622316f246543bc9f56828ec46ca8c7", "itemName":"图片", "itemType":"ImageField", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"图片", "type":"ImageField", "unique":false }, "valueStrs": [ { "sort":1, "valueStr":"http://localhost:8080/wxqyh/file/download.action?path=/upload/img/b17efb43292e4cc9ac5d0b46bce059c4/20190117/d11fa7e31b40401f8e4b5f738899202f.jpeg" } ] }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"fo522236582b7541c8816c951ad715ea60", "itemName":"附件", "itemType":"AccessoryField", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"附件", "type":"AccessoryField", "unique":false }, "valueStrs": [ { "otherValue":"文件名.xlsx", "sort":1, "valueStr":"http://localhost:8080/wxqyh/file/download.action?fileId=29ac3e5be1e441f8b43797fea4e62262" } ] }, { "childItemDefinitions": [ { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foc7cf5e5544354501a57eedb356736967", "itemName":"单行文字", "itemType":"TextField", "parentKey":"foa9d47885d7fc46a68a5005114d0bbc55", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"单行文字", "type":"TextField", "unique":false }, "valueStrs": [ { "sort":1, "valueStr":"qwe" } ] }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foa470f7e4eb3a48b883a19753b348a09e", "itemName":"图片", "itemType":"ImageField", "parentKey":"foa9d47885d7fc46a68a5005114d0bbc55", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"图片", "type":"ImageField", "unique":false }, "valueStrs": [ { "sort":1, "valueStr":"http://localhost:8080/wxqyh/file/download.action?path=/upload/img/b17efb43292e4cc9ac5d0b46bce059c4/20190117/b3139cfc0f0841cd8703b352a41d20e4.jpeg" } ] } ], "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foa9d47885d7fc46a68a5005114d0bbc55", "itemName":"子表单", "itemType":"ChildField", "valid": { "accurateNum":0, "capital":false, "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "tip":"子表单", "type":"ChildField", "unique":false } }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foc7cf5e5544354501a57eedb356736967", "itemName":"单行文字", "itemType":"TextField", "parentKey":"foa9d47885d7fc46a68a5005114d0bbc55", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"单行文字", "type":"TextField", "unique":false }, "valueStrs": [ { "sort":1, "valueStr":"qwe" } ] }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foa470f7e4eb3a48b883a19753b348a09e", "itemName":"图片", "itemType":"ImageField", "parentKey":"foa9d47885d7fc46a68a5005114d0bbc55", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"图片", "type":"ImageField", "unique":false }, "valueStrs": [ { "sort":1, "valueStr":"http://localhost:8080/wxqyh/file/download.action?path=/upload/img/b17efb43292e4cc9ac5d0b46bce059c4/20190117/b3139cfc0f0841cd8703b352a41d20e4.jpeg" } ] }, { "childItemDefinitions": [ { "childSort":0, "itemKey":"fob4c8b76859c34068876e4c6c91742a35", "itemName":"单行文字", "itemType":"TextField", "parentKey":"foac1d9bb2211645438b7cc430c8b2ac4f", "sort":1, "tip":"请输入", "valid": { "capital":false, "must":false, "ref":true, "unique":false } } ], "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"foac1d9bb2211645438b7cc430c8b2ac4f", "itemName":"表单关联", "itemType":"FORMREFCustomerField", "showFields":"fob4c8b76859c34068876e4c6c91742a35", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"表单关联", "type":"FORMREFCustomerField", "unique":false }, "valueStrs": [ { "sort":1, "valueStr":"work7ab1838a8afd4cc99b7dfec788347103_测试" } ] }, { "childSort":0, "itemKey":"fob4c8b76859c34068876e4c6c91742a35", "itemName":"单行文字", "itemType":"TextField", "parentKey":"foac1d9bb2211645438b7cc430c8b2ac4f", "sort":1, "tip":"请输入", "valid": { "capital":false, "must":false, "ref":true, "unique":false } }, { "definitionId":"defn0cb4874a0c8a44d0814e1b609030044d", "itemKey":"fo31c5fbe251714d4f87fe47b703c93a6e", "itemName":"评分", "itemType":"RatingField", "valid": { "accurateNum":0, "capital":false, "fieldType":"pattern", "lineRow":1, "maxLength":0, "minLength":0, "must":false, "ref":false, "regex":"^.*$", "tip":"评分", "type":"RatingField", "unique":false }, "valueStrs": [ { "valueStr":"3" } ] } ], "id":"work45856a558a354df1913d4e3c35d859ce", "instanceTitle":"API自由流程", "isover":"2", "personName":"double", "versions":"1" } ], "totalRows":1 }, "desc":"成功" }
参数名 |
释义 |
类型 |
是否必须 |
备注 |
---|---|---|---|---|
totalRows |
数据总条数 |
Int |
||
currentPage |
当前所在页数 |
Int |
||
maxPage |
最大页数 |
Int |
||
definitionId |
版本号(uuid) |
String |
||
personName |
提单人 |
String |
||
departmentName |
部门 |
String |
||
instanceTitle |
标题 |
String |
||
createaTime |
提单时间 |
String |
||
isover |
状态 |
Integer |
0:退审;1:已审批;2:审批中;-1:已关闭 |
|
approvers |
当前处理人 |
String |
||
closePerson |
最后处理人 |
String |
||
closeTime |
最后处理时间 |
String |
||
versions |
对应版本(数字) |
String |
||
picPaths(集合,值为图片(常用字段图片)地址的集合,包含于pageData) |
||||
filesPath(集合,值为附件(常用字段图片)地址的集合,包含于pageData) |
||||
formItemDefinitionsVO |
客户自定义字段数据 |
Array |
|
|
FormCommentVOList |
评论列表 |
Array |
FormCommentVO:{ "commentId":.., "workOrderId":.., "content":.., "userIds":.., "creator":.., "createaTime":.., "type":.., "time":.., "ext1":.., "status":.., "userId":.., "personName":.., "headPic":.. }
|
|
auditLogVOList
|
审批列表 |
Array |
分支流程: { "id":.., "versionsId":.., "refId":.., "handNodeId":.., "nextNodeId":.., "handleAccounts":.., "nodeName":.., "status":.., "auditStatus":.., "nodeType":.., "createTime":.., "updateTime":.., "creator":.., "orgId":.., "departmentId":.., "option":.., "auditUserId":.., "auditUserName":.., "auditTime":.. } 固定流程:{ "id":.., "auditId":.., "refId":.., "flowName":.., "auditStatus":.., "creator":.., "opinion":.., "nodeSoft":.., "nodeStatus":.., "personName":.., "headPic":.., "nodeName":.., "nodeType":.., "isSign":.., "nodeId":.., "handleAccounts":.., "createTime":.. } 自由流程:{ "id":.., "personName":.., "remark":.., "auditTime":.., "foreignId":.. } 有三种可能。 |
|
formItemDefinitionsVO参数说明 |
||||
itemKey |
字段键 |
String |
||
itemName |
字段名称 |
String |
||
itemType |
字段类型 |
String |
ChildField表示该字段下有子字段 |
|
parentKey |
父字段键 |
String |
可通过父字段键找到子字段的父类 |
|
childItemDefinitions |
子字段集合 |
Array |
||
childItemDefinitions(子字段集合,其属性和formItemDefinitionsVO一样) |
||||
valueStrs |
客户自定义字段值的相关情况 |
Array |
||
valueStrs参数说明 |
||||
valueStr |
字段值 |
String |
||
sort |
排序号 |
Integer |
用于区分该值对应第几个表单 |
|
otherValue |
其他字段值 |
String |
|
|