简要描述:

  • 获取历史留痕数据

接口版本:

版本号 制定人 制定日期 修订日期
1.0 鲁航 2022-08-19 2022-08-19

请求URL:

  • /je/meta/resourceTable/loadHistoricalTraces

请求方式:

  • POST

请求头:

参数名 是否必须 类型 说明
Content-Type string 请求类型: application/json
authorization string 请求内容签名

请求参数:

参数名 是否必须 类型 说明
tableCode string 表编码
page string 页码
start string 起始页
limit string 每页条数
j_query string 查询、排序条件

返回示例:

正确时返回:

{
    "code": "1000",
    "data": {
        "rows": [
            {
                "SY_MODIFYORGID": null,
                "SY_FLAG": null,
                "JE_CORE_TABLETRACE_ID": "8d717e1a45224922ae7bd92803242fb4",
                "SY_MODIFYTIME": null,
                "SY_CREATEUSERNAME": "鲁航",
                "TABLETRACE_FIELDCODE": "JE_1660886633774",
                "TABLETRACE_CZRNAME": "鲁航",
                "TABLETRACE_CZRCODE": "luh",
                "TABLETRACE_TABLECODE": "JE_CORE_TABLEINDEX",
                "TABLETRACE_CZSJ": "2022-08-19 13:23:53",
                "SY_ORDERINDEX": null,
                "SY_MODIFYUSERID": null,
                "SY_MODIFYORG": null,
                "TABLETRACE_OPER": "添加",
                "SY_CREATEORGID": "dSxGZiOYSPQubZSW6Pm",
                "SY_STATUS": null,
                "SY_CREATEUSERID": "be97b58bfa284bc788e6a03ec265cbc2",
                "SY_FORMUPLOADFILES": null,
                "SY_MODIFYORGNAME": null,
                "SY_PYQC": null,
                "TABLETRACE_SFYY": "0",
                "SY_CREATETIME": "2022-08-19 13:23:53",
                "SY_CREATEORGNAME": "平台研发部",
                "TABLETRACE_XGNRJSON": [
                    {
                        "tableColumnCode": "TABLEINDEX_CLASSIFY",
                        "tableColumnName": "分类",
                        "type": "insert",
                        "tableColumnValue": "PRO"
                    },
                    {
                        "tableColumnCode": "TABLEINDEX_ISCREATE",
                        "tableColumnName": "创建",
                        "type": "insert",
                        "tableColumnValue": "0"
                    },
                    {
                        "tableColumnCode": "TABLEINDEX_NAME",
                        "tableColumnName": "名称",
                        "type": "insert",
                        "tableColumnValue": "JE_1660886633774"
                    },
                    {
                        "tableColumnCode": "TABLEINDEX_RESOURCETABLE_ID",
                        "tableColumnName": "外键",
                        "type": "insert",
                        "tableColumnValue": "bSWJMI19MamZGg852Gm"
                    },
                    {
                        "tableColumnCode": "TABLEINDEX_TABLECODE",
                        "tableColumnName": "表名",
                        "type": "insert",
                        "tableColumnValue": "JE_CORE_RESOURCETABLE"
                    },
                    {
                        "tableColumnCode": "TABLEINDEX_UNIQUE",
                        "tableColumnName": "唯一",
                        "type": "insert",
                        "tableColumnValue": "0"
                    },
                    {
                        "tableColumnCode": "JE_CORE_TABLEINDEX_ID",
                        "tableColumnName": "主键ID",
                        "type": "insert",
                        "tableColumnValue": "db663ce165d94b688641760be5cd4e90"
                    }
                ],
                "SY_PYJZ": null,
                "TABLETRACE_XGNR": null,
                "SY_MODIFYUSER": null,
                "TABLETRACE_TABLENAME": "索引",
                "SY_MODIFYUSERNAME": null,
                "TABLETRACE_RESOURCETABLE_ID": "bSWJMI19MamZGg852Gm"
            }
            }
        ],
        "totalCount": 1
    },
    "message": "操作成功!",
    "success": true,
    "rows": null,
    "totalCount": null
}

错误时返回:

{
"errcode": 500,
"errmsg": "invalid appid"
}

备注:

  • 更多返回错误代码请看首页的错误代码描述
最后编辑: 于春辉  文档更新时间: 2024-07-26 14:15   作者:于春辉