chunjun icon indicating copy to clipboard operation
chunjun copied to clipboard

请问flinkX的http请求获取到json后,怎么解析嵌套的json数组?

Open 1007841800 opened this issue 3 years ago • 3 comments

这是我写的json脚本

{
  "job": {
    "content": [
      {
        "reader": {
          "parameter": {
            "intervalTime": 3000,
            "url": "http://api.map.baidu.com/place/v2/suggestion?query=%E6%98%A5%E7%86%99%E8%B7%AF&region=%E6%88%90%E9%83%BD%E5%B8%82&output=json&ak=n0lHarpY3QZx6xXXIaWMFLxj",
            "requestMode": "get",
            "decode": "json",
            "column": [
              {
                "name": "result.name",
                "type": "string",
                "isNest": true
              },
              {
                "name": "result.uid",
                "type": "string",
                "isNest": true
              }
            ],
            "header": [],
            "body": []
          },
          "name": "restapireader"
        },
        "writer": {
          "parameter": {
            "print": true
          },
          "name": "streamwriter"
        }
      }
    ],
    "setting": {
      "speed": {
        "bytes": 0,
        "channel": 1
      }
    }
  }
}

这是我要解析的json,能获取到status和message,但是获取不到result.name

{
    "status":0,
    "message":"ok",
    "result":[
        {
            "name":"春熙路-地铁站",
            "location":{
                "lat":30.659204,
                "lng":104.086002
            },
            "uid":"3a49b04c2186aaa7d7851f2c",
            "province":"四川省",
            "city":"成都市",
            "district":"锦江区",
            "business":"",
            "cityid":"75",
            "tag":"地铁站",
            "address":"",
            "children":[
                
            ],
            "adcode":"510104"
        },
        {
            "name":"春熙路步行街",
            "location":{
                "lat":30.661516,
                "lng":104.084227
            },
            "uid":"03a6e15e1464026f88f15d3e",
            "province":"四川省",
            "city":"成都市",
            "district":"锦江区",
            "business":"",
            "cityid":"75",
            "tag":"步行街",
            "address":"成都市-锦江区-春熙路",
            "children":[
                
            ],
            "adcode":"510104"
        },
        {
            "name":"春熙路地铁站-c口",
            "location":{
                "lat":30.659748,
                "lng":104.086734
            },
            "uid":"f3e24284b0b68a6dc6f50de5",
            "province":"四川省",
            "city":"成都市",
            "district":"锦江区",
            "business":"",
            "cityid":"75",
            "tag":"",
            "address":"",
            "children":[
            ],
            "adcode":"510104"
        }
    ]
}

最后把整个json都输出了 output

1007841800 avatar Mar 08 '22 03:03 1007841800

老哥解决这个问题了没?

heyiheng1024 avatar Dec 20 '22 07:12 heyiheng1024

这个是用jsonpath

加个这个配置 : "dataSubject":"$.result.rows" image

CongLollipop avatar Aug 18 '23 07:08 CongLollipop

有人知道怎么分页请求吗?

CongLollipop avatar Aug 18 '23 07:08 CongLollipop