在遇到一个问题，想向各位老师请教下：集思录上的数据改版后现在是限制游客登录只能查看前30条数据 登录之后才能查看所有数据 之前我是可以正常用PQ抓取数据的 现在即使我把登录的cookie加进去 也发现还是只能抓取前30条记录 想请您有空了帮忙给看下 谢谢了
let
url="https://www.jisilu.cn/data/cbnew/cb_list/?___jsl=LST___t=1627788961010 ",
headers=[#"Content-Type"="application/x-www-form-urlencoded",Cookie="_ga=GA1.2.690178055.1594797259; Hm_lvt_164fe01b1433a19b507595a43bf58262=1624424906,1626445525; kbzw__Session=ljfkjed9skgp5u4fokoh3d16r2
"], //Content-Type必填，如不需要登录Cookie可省略
query=[],
content="fprice=&tprice=&curr_iss_amt=&volume=&svolume=&premium_rt=&ytm_rt=&rating_cd=&is_search=N&market_cd%5B%5D=shmb&market_cd%5B%5D=shkc&market_cd%5B%5D=szmb&market_cd%5B%5D=szcy&btype=&listed=Y&qflag=N&sw_cd=&bondids=&rp=50&page=1",
Source=Json.Document(Web.Contents(url,[Headers=headers,Query=query,Content=Text.ToBinary(content)])),
rows = Table.Combine(Table.FromList(Source[rows],each {Table.FromRecords({Record.FieldValues(){1}})},{"t"})[t])
in
rows
