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