开放接口API说明-超级表单接口

参数名称 参数值
应用编码 userDefined
应用版本 v1
接口名称 新增表单
接口编码 addUserDefined
接口URL https://openapi.waiqin365.com/api/userDefined/v1/addUserDefined/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
config.form_id VARCHAR(32) 外勤365系统中该流程的id
data.pt 该流程主记录
data.sts 该流程明细(子表)记录
data.pt.source_code VARCHAR(200) 第三方系统数据KEY
data.pt.creator_id VARCHAR(36) 创建人id
data.pt.slfdf_* 主记录数据(字段编码详见页面接口数据)
data.sts.id CHAR(32) 明细数据的表格id
data.sts.rows. source_code CHAR(200) 明细数据第三方系统数据KEY
data.sts.rows.slfdf_* 明细数据(字段编码详见页面接口数据)
响应信息 参数 类型 说明
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明
response_data String 参照响应信息示例,response_data为当前保存的主记录数据

// 请求消息体示例:
{
    "config": {
        "form_id": "4803305597478179107"
    },
    "data": {
        "pt": {
            "source_code": "code15597478179102",
            "creator_id": "3258191447353251895",
            "slfdf_1701180002": "订单编码001",
            "slfdf_1701180004": "2017-01-19 15:27",
            "slfdf_1701180005": "买家编码001",
            "slfdf_1701180006": "8037753159935166023",
            "slfdf_1701180007": "卖家编码001",
            "slfdf_1701180008": "卖家名称001",
            "slfdf_1701180009": "订单状态完成",
            "slfdf_1701180010": "1000",
            "slfdf_1701180011": "订单类型1",
            "slfdf_1701180012": "江浙沪",
            "slfdf_1701180013": "现金",
            "slfdf_1701180014": "1000",
            "slfdf_1701180015": "2017-01-19 15:28",
            "slfdf_1701180016": "收货人名称",
            "slfdf_1701180017": "15152621000",
            "slfdf_1701180018": "江苏",
            "slfdf_1701180019": "南京",
            "slfdf_1701180020": "建邺区",
            "slfdf_1701180021": "嘉陵江东街",
            "slfdf_1701180022": "9点-15点",
            "slfdf_1701180023": "9点",
            "slfdf_1701180024": "15点",
            "slfdf_1701190001": "备注1",
            "slfdf_1701190002": "备注2",
            "slfdf_1701190003": "备注3",
            "slfdf_1701190004": "备注4",
            "slfdf_1701190005": "备注5",
            "slfdf_1701190006": "备注6"
        },
        "sts": [
            {
                "id": "7144770493868875242",
                "rows": [
                    {
                        "source_code": "code155974781791021",
                        "slfdf_1701180025": "产品编码002",
                        "slfdf_1701180026": "产品名称002",
                        "slfdf_1701180027": "4",
                        "slfdf_1701180028": "100"
                    },
                    {
                        "source_code": " code155974781791022",
                        "slfdf_1701180025": "产品编码001",
                        "slfdf_1701180026": "产品名称001",
                        "slfdf_1701180027": "6",
                        "slfdf_1701180028": "100"
                    }
                ]
            }
        ]
    }
}

// 响应信息示例:
{
    "msg_id": "X000001",
    "response_data": {
        "slfdf_1701180002": "订单编码001",
        "slfdf_1701180004": "2017-01-19 15:27",
        "slfdf_1701180005": "买家编码001",
        "slfdf_1701180006": "8037753159935166023",
        "slfdf_1701180007": "卖家编码001",
        "slfdf_1701180008": "卖家名称001",
        "slfdf_1701180009": "订单状态完成",
        "slfdf_1701180010": "1000",
        "slfdf_1701180011": "订单类型1",
        "slfdf_1701180012": "江浙沪",
        "slfdf_1701180013": "现金",
        "slfdf_1701180014": "1000",
        "slfdf_1701180015": "2017-01-19 15:28",
        "slfdf_1701180016": "收货人名称",
        "slfdf_1701180017": "15152621000",
        "slfdf_1701180018": "江苏",
        "slfdf_1701180019": "南京",
        "slfdf_1701180020": "建邺区",
        "slfdf_1701180021": "嘉陵江东街",
        "slfdf_1701180022": "9点-15点",
        "slfdf_1701180023": "9点",
        "slfdf_1701180024": "15点",
        "slfdf_1701190001": "备注1",
        "slfdf_1701190002": "备注2",
        "slfdf_1701190003": "备注3",
        "slfdf_1701190004": "备注4",
        "slfdf_1701190005": "备注5",
        "slfdf_1701190006": "备注6",
        "id": "6425258429832019"
    },
    "return_code": 0,
    "return_msg": ""
}
                  
参数名称 参数值
应用编码 userDefined
应用版本 v1
接口名称 修改表单
接口编码 modifyUserDefined
接口URL https://openapi.waiqin365.com/api/userDefined/v1/modifyUserDefined/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
config.form_id VARCHAR(32) 外勤365系统中该流程的id
data.pt 该流程主记录
data.sts 该流程明细(子表)记录
data.pt.id VARCHAR(32) 主记录id,与第三方系统数据KEY必填一个
data.pt.source_code VARCHAR(200) 第三方系统数据KEY,与主记录id必填一个
data.pt.creator_id VARCHAR(36) 创建人id
data.pt.slfdf_* 主记录数据(字段编码详见页面接口数据)
data.sts.id VARCHAR(32) 明细数据的表格id
data.sts.rows.id VARCHAR(32) 明细数据记录id
data.sts.rows.source_code VARCHAR(200) 明细数据第三方系统数据KEY,
id或者source_code必须填写一个
data.sts.rows.slfdf_* 明细数据(字段编码详见页面接口数据)
响应信息 参数 类型 说明
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明

// 请求消息体示例:
{
    "config": {
        "form_id": "4622631669645698414"
    },
    "data": {
        "pt": {
            "id": "2064770493868875201",
            "source_code": "code155974781791021",
            "creator_id": "3258191447353251895",
            "slfdf_1701180002": "订单编码001",
            "slfdf_1701180004": "2017-01-19 15:27",
            "slfdf_1701180005": "卖家编码001",
            "slfdf_1701180006": "8037753159935166023",
            "slfdf_1701180007": "卖家编码001",
            "slfdf_1701180008": "卖家名称001",
            "slfdf_1701180009": "订单状态完成",
            "slfdf_1701180010": "1000",
            "slfdf_1701180011": "订单类型1",
            "slfdf_1701180012": "江浙沪",
            "slfdf_1701180013": "现金",
            "slfdf_1701180014": "1000",
            "slfdf_1701180015": "2017-01-19 15:28",
            "slfdf_1701180016": "收货人名称",
            "slfdf_1701180017": "15152621000",
            "slfdf_1701180018": "江苏",
            "slfdf_1701180019": "南京",
            "slfdf_1701180020": "建邺区",
            "slfdf_1701180021": "嘉陵江东街",
            "slfdf_1701180022": "9点-15点",
            "slfdf_1701180023": "9点",
            "slfdf_1701180024": "15点",
            "slfdf_1701190001": "备注1",
            "slfdf_1701190002": "备注2",
            "slfdf_1701190003": "备注3",
            "slfdf_1701190004": "备注4",
            "slfdf_1701190005": "备注5",
            "slfdf_1701190006": "备注6"
        },
        "sts": [
            {
                "id": "7144770493868875242",
                "rows": [
                    {
                        "id": "2064770493868875201",
                        "source_code": "code770493868875201",
                        "slfdf_1701180025": "产品编码002",
                        "slfdf_1701180026": "产品名称002",
                        "slfdf_1701180027": "4",
                        "slfdf_1701180028": "100"
                    },
                    {
                        "id": "2064770493868875201",
                        "source_code": "code770493868875202",
                        "slfdf_1701180025": "产品编码001",
                        "slfdf_1701180026": "产品名称001",
                        "slfdf_1701180027": "6",
                        "slfdf_1701180028": "100"
                    }
                ]
            }
        ]
    }
}

// 响应信息示例:
{
    "msg_id": "X000001",
    "return_code": 0,
    "return_msg": ""
}
                  
参数名称 参数值
应用编码 userDefined
应用版本 v1
接口名称 删除表单
接口编码 delUserDefined
接口URL https://openapi.waiqin365.com/api/userDefined/v1/delUserDefined/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
form_id VARCHAR(32) 外勤365系统中该流程id
codes VARCHAR(4000) 主记录source_code,逗号分隔多条记录
响应信息 参数 类型 说明
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明

// 请求消息体示例:
{
    "form_id": "4622631669645698414",
    "codes": "8767607948140064370, 8767607948140064371"
}

// 响应信息示例:
{
   	"msg_id":"X000001",
	"return_code":0,
	"return_msg":""
}
                  
参数名称 参数值
应用编码 userDefined
应用版本 v1
接口名称 查询表单
接口编码 queryUserDefined
接口URL https://openapi.waiqin365.com/api/userDefined/v1/queryUserDefined/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
form_id VARCHAR(32) 外勤365系统中该流程的编码
source_code VARCHAR(200) 主记录code
date_start VARCHAR(10) 上报日期起,格式:“yyyy-MM-dd”
date_end VARCHAR(10) 上报日期止,格式:“yyyy-MM-dd”
creator_id VARCHAR (36) 上报人id
page VARCHAR (10) 数据页数
rows VARCHAR (10) 每页数据显示条数(最大1000)
响应信息 参照表响应信息格式

// 请求消息体示例:
{
    "form_id": "4622631669645698414",
    "source_code": "8767607948140064370",
    "date_start": "2017-01-10",
    "date_end": "2017-01-20",
    "creator_id": "3322631669645699527",
    "page": "1",
    "rows": "1000"
}

// 响应信息示例:
{
    "msg_id": "YY698688888",
    "response_data": [
        {
            "pt": {
                "id": "2064770493868875201",
                "source_code": "code15597478179102",
                "creator_id": "3258191447353251895",
                "creator_time": "2017-01-20 12:12:03",
                "modifyier_id": "",
                "modifyier_ time ": "",
                "slfdf_1701180002": "订单编码001",
                "slfdf_1701180004": "2017-01-19 15:27",
                "slfdf_1701180005": "买家编码001",
                "slfdf_1701180006": "8037753159935166023",
                "slfdf_1701180007": "卖家编码001",
                "slfdf_1701180008": "卖家名称001",
                "slfdf_1701180009": "订单状态完成",
                "slfdf_1701180010": "1000",
                "slfdf_1701180011": "订单类型1",
                "slfdf_1701180012": "江浙沪",
                "slfdf_1701180013": "现金",
                "slfdf_1701180014": "1000",
                "slfdf_1701180015": "2017-01-19 15:28",
                "slfdf_1701180016": "收货人名称",
                "slfdf_1701180017": "15152621000",
                "slfdf_1701180018": "江苏",
                "slfdf_1701180019": "南京",
                "slfdf_1701180020": "建邺区",
                "slfdf_1701180021": "嘉陵江东街",
                "slfdf_1701180022": "9点-15点",
                "slfdf_1701180023": "9点",
                "slfdf_1701180024": "15点",
                "slfdf_1701190001": "备注1",
                "slfdf_1701190002": "备注2",
                "slfdf_1701190003": "备注3",
                "slfdf_1701190004": "备注4",
                "slfdf_1701190005": "备注5",
                "slfdf_1701190006": "备注6"
            },
            "sts": [
                {
                    "id": "7144770493868875242",
                    "rows": [
                        {
                            "id": "2217888117059747333",
                            "source_code": "code15597478179102",
                            "slfdf_1701180025": "产品编码002",
                            "slfdf_1701180026": "产品名称002",
                            "slfdf_1701180027": "4",
                            "slfdf_1701180028": "100"
                        },
                        {
                            "id": "2217888117059747332",
                            "source_code": "code15597478179102",
                            "slfdf_1701180025": "产品编码001",
                            "slfdf_1701180026": "产品名称001",
                            "slfdf_1701180027": "6",
                            "slfdf_1701180028": "100"
                        }
                    ]
                }
            ]
        }
    ],
    "return_code": 0,
    "return_msg": ""
}