@Alex 还有个问题想请教一下,我想弄个延时,但是我这样子写会出错,不知道怎么写了:sob:
let
get_data = (page)=>
let
url="https://www.howbuy.com/fund/valuation/ajax.htm",
headers=[#"Content-Type"="application/x-www-form-urlencoded;Referer=https://www.howbuy.com/fund/valuation/index.htm"],
content="orderType=true&page="&Text.From(page)&"&allowGM=false"&"isOptional=false",
data=Table.FromRecords(Json.Document(Web.Contents(url,[Headers=headers,Content=Text.ToBinary(content)]))[list],{"date","jjdm","jjjc","jjjz","netValue","preJjjz"},MissingField.UseNull)
in
data,
result = Table.Combine(List.Transform({1..100},Function.InvokeAfter(get_data,#duration(0,0,0,5))))
in
result