cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
lala
Level VII

如何用脚本下载这个网站的查询结果?

这个是其他语言的代码、要如何修改才能工作?谢谢大家!

Sub West()
    Dim result, antistop, Values As Variant, i, j, x, y, cnt
    Dim Json As Object
    cnt = Range("b1") & ""
    antistop = "{""question"":""ROE>20"",""perpage"":" & cnt & ",""page"":9,""secondary_intent"":""stock"",""log_info"":""{\""input_type\"":\""click\""}"",""source"":""Ths_iwencai_Xuangu"",""version"":""2.0"",""query_area"":"""",""block_list"":"""",""add_info"":""{\""urp\"":{\""scene\"":1,\""company\"":1,\""business\"":1},\""contentType\"":\""json\"",\""searchInfo\"":true}""}"
    With CreateObject("WinHttp.WinHttpRequest.5.1")
        .Open "Post", "http://x.10jqka.com.cn/customized/chart/get-robot-data", False
        .setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36"
        .setRequestHeader "Content-Type", "application/json"
        .send antistop
        result = Split(Split(.responsetext, """datas"":")(1), ",""meta")(0)
        Set Json = JsonConverter.ParseJson(result)
      
    
End Sub
4 REPLIES 4
lala
Level VII

回复: 如何用脚本下载这个网站的查询结果?

  • The above is VBA code, how to modify in JSL execution?Thanks!

jthi
Super User

回复: 如何用脚本下载这个网站的查询结果?

Check out New HTTP Request in Scripting Index (and most likely Guide) with JSON enabled:

jthi_0-1642154397274.png

 

-Jarmo
lala
Level VII

回复: 如何用脚本下载这个网站的查询结果?

感谢!

通过多次的运用、这个脚本指南的这种方法我已经基本掌握了。

 

但这个网站不能用这种方法实现。

我按截图中的方式得到数据的网址、但不起作用

http://ai.iwencai.com/urp/v7/landing/getDataList

2022-01-14_212922.png

lala
Level VII

回复: 如何用脚本下载这个网站的查询结果?

{
    "data":"query=ROE%3E20&urp_sort_way=desc&urp_sort_index=%E5%87%80%E8%B5%84%E4%BA%A7%E6%94%B6%E7%9B%8A%E7%8E%87roe%28%E5%8A%A0%E6%9D%83%2C%E5%85%AC%E5%B8%83%E5%80%BC%29%5B20210930%5D&page=1&perpage=100&condition=%5B%7B%22indexName%22%3A%22%E5%87%80%E8%B5%84%E4%BA%A7%E6%94%B6%E7%9B%8A%E7%8E%87roe%28%E5%8A%A0%E6%9D%83%2C%E5%85%AC%E5%B8%83%E5%80%BC%29%22%2C%22indexProperties%22%3A%5B%22nodate%201%22%2C%22%E4%BA%A4%E6%98%93%E6%97%A5%E6%9C%9F%2020210930%22%2C%22%280.2%22%5D%2C%22source%22%3A%22new_parser%22%2C%22type%22%3A%22index%22%2C%22indexPropertiesMap%22%3A%7B%22%E4%BA%A4%E6%98%93%E6%97%A5%E6%9C%9F%22%3A%2220210930%22%2C%22%28%22%3A%220.2%22%2C%22nodate%22%3A%221%22%7D%2C%22reportType%22%3A%22QUARTER%22%2C%22dateType%22%3A%22%E6%8A%A5%E5%91%8A%E6%9C%9F%22%2C%22chunkedResult%22%3A%22roe%3E20%22%2C%22valueType%22%3A%22_%E6%B5%AE%E7%82%B9%E5%9E%8B%E6%95%B0%E5%80%BC%28%25%29%22%2C%22domain%22%3A%22abs_%E8%82%A1%E7%A5%A8%E9%A2%86%E5%9F%9F%22%2C%22uiText%22%3A%22%E5%87%80%E8%B5%84%E4%BA%A7%E6%94%B6%E7%9B%8A%E7%8E%87roe%28%E5%8A%A0%E6%9D%83%2C%E5%85%AC%E5%B8%83%E5%80%BC%29%3E20%25%22%2C%22sonSize%22%3A0%2C%22queryText%22%3A%22%E5%87%80%E8%B5%84%E4%BA%A7%E6%94%B6%E7%9B%8A%E7%8E%87roe%28%E5%8A%A0%E6%9D%83%2C%E5%85%AC%E5%B8%83%E5%80%BC%29%3E20%25%22%2C%22relatedSize%22%3A0%2C%22tag%22%3A%22%E5%87%80%E8%B5%84%E4%BA%A7%E6%94%B6%E7%9B%8A%E7%8E%87roe%28%E5%8A%A0%E6%9D%83%2C%E5%85%AC%E5%B8%83%E5%80%BC%29%22%7D%5D&codelist=&indexnamelimit=&logid=d1ebf57fb412af7ed78f80207695161f&ret=json_all&sessionid=d1ebf57fb412af7ed78f80207695161f&date_range%5B0%5D=20210930&iwc_token=0ac9529a16421667775453095&urp_use_sort=1&user_id=Ths_iwencai_Xuangu_s1xg1peju6l4ycle36dqpr7iq2hs3qba&uuids%5B0%5D=24087&query_type=stock&comp_id=5897333&business_cat=soniu&uuid=24087",
    "method":"POST",
    "url":"http://ai.iwencai.com/urp/v7/landing/getDataList",
    "headers":{
        "Accept":" application/json, text/plain, */*",
        "Accept-Encoding":" gzip, deflate",
        "Accept-Language":" zh-CN,zh;q=0.9,en;q=0.8,zh-TW;q=0.7",
        "Cache-control":" no-cache",
        "Connection":" keep-alive",
        "Content-Type":" application/x-www-form-urlencoded",
        "Cookie":" cid=bc9cfac7db41839ef3881b8dcb6d35731638928875; v=A3JRfcl9R2yuh3tQFvJLttzSw7NZA3TUqAJqwjxKnCoSFRhnJJPGrXiXusMP",
        "Origin":" http://www.iwencai.com",
        "Pragma":" no-cache",
        "Referer":" http://www.iwencai.com/unifiedwap/result?w=ROE%3E20&querytype=stock",
        "User-Agent":" Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36"
    }
}