Kettle实战之(11)Json输入

2022-11-24  本文已影响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
上一篇下一篇

猜你喜欢

热点阅读