kettle使用httpClient获取ES索引数据

  1. 编辑请求头参数
    image5a82456d3ea04439bcef8b50db6b358b.png
    (json为json格式请求体)
  2. 设置请求
    image.png
    image.png
  3. 解析返回数据
    返回数据格式如下:
{
    "data": [
        {
            "risk_content": "**",
            "risk_point": "**",
            "checked_type": "**",
            "correction_detail": "**",
            "supervisor_id": "**",
            "unit_address": "**",
            "review_law_document": "**",
            "checker_street": "**",
            "record_law_document_qr": "**",
            "checker": "**",
	    ...
        }{
            "risk_content": "**",
            "risk_point": "**",
            "checked_type": "**",
            "correction_detail": "**",
            "supervisor_id": "**",
            "unit_address": "**",
            "review_law_document": "**",
            "checker_street": "**",
            "record_law_document_qr": "**",
            "checker": "**",
	    ...
        }...
    ],
    "pageSize": 200,
    "totalCount": 1,
    "pageNum": 1
}
 

image.png
编辑映射
image.png
4. 截取参数(过滤掉前面设置的求头参数)
image.png
5. 数据入库(也可以导出EXCEL等,解析到了数据就能很方便的操作了)
image.png


版权声明:本文为listenFen原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。