美文网首页
Kettle实战之(11)Json输入

Kettle实战之(11)Json输入

作者: 走码人 | 来源:发表于2022-11-24 11:59 被阅读0次

    读取JSON文件

    json文件

    {
        "configs": [
            {
                "id": "TD01050101",
                "todo_id": "TD01050101",
                "process_definition_key": "INFOMATION00101001",
                "description": "新建",
                "target_table": "prj_info",
                "target_table_alias": "ps",
                "target_table_key": "id",
                "filters": "ps.wbs_template_code='XQ'"
            },
            {
                "id": "TD01050102",
                "todo_id": "TD01050102",
                "process_definition_key": "INFOMATION00101002",
                "description": "延期",
                "target_table": "prj_change_time",
                "target_table_alias": "ps",
                "target_table_key": "id",
                "filters": "ps.wbs_template_code='XQ'"
            }
        ]
    }
    

    JSON输入节点配置

    image.png

    注意:路径的语法 $.跟着属性信息,如果是数组用两个点 ..

    $.configs..id
    

    相关文章

      网友评论

          本文标题:Kettle实战之(11)Json输入

          本文链接:https://www.haomeiwen.com/subject/rhtxfdtx.html