谢谢老师，最难的遍历来了，怎样一期一组，全部找出来呢？尝试了一晚上，也没找到，学不会，再次请教老师.

[此贴子已经被作者于2021-6-1 07:02编辑过]

下载数据用时比较长（8秒左右），解析数据应该能控制在1秒内

老师，您是大神级高手，我是一个小菜鸟

试试
FOR lnj = 1 TO OCCURS("lotteryDrawNum", lcText)
    lyText = STREXTRACT(lcText,',"lotteryDrawNum":"','","lotteryDrawResult":"', lnj)
    lcText = STREXTRACT(lcText,'lotteryUnsortDrawresult":"','","matchList', lnj)
    ? lcText ,lyText
ENDFOR

FOR lnj = 1 TO OCCURS("lotteryDrawNum", lcText)
    lyText = STREXTRACT(lcText,',"lotteryDrawNum":"','","lotteryDrawResult":"', lnj)
    lcText = STREXTRACT(lcText,'lotteryUnsortDrawresult":"','","matchList', lnj)
    ? lcText ,lyText
ENDFOR

改为

FOR lnj = 1 TO OCCURS("lotteryDrawNum", lcText)
    lyText = STREXTRACT(lcText,',"lotteryDrawNum":"','","lotteryDrawResult":"', lnj)
    lxText = STREXTRACT(lcText,'lotteryUnsortDrawresult":"','","matchList', lnj) && lcText 为下载的数据
    ? lxText ,lyText
ENDFOR

从11006期开始才有出球顺序的数据，也就是lxText提取的数据

下载的数据有5M多，记录也2000多条，用STREXTRACT()要秒杀有难度。
试试用JavaScript应该能秒杀

CREATE CURSOR tt (DrawNum C(5), DrawResult C(20))
cUrl = "https://webapi./gateway/lottery/getHistoryPageListV1.qry?gameNo=85&provinceId=0&pageSize=0"
oHttp = CREATEOBJECT("MSXML2.XMLHTTP")
oHttp.Open("GET", cUrl, .F.)
oHttp.Send()
jsCode = 'var data='+oHttp.responseText+';var list=data["value"]["list"];'
oSC = CREATEOBJECT("ScriptControl")
oSC.Language = "JavaScript"
oSC.AddCode(jsCode)
FOR i=0 TO oSC.eval('list.length')-1
    INSERT INTO tt VALUES (oSC.eval('list['+TRANSFORM(i)+']["lotteryDrawNum"]'),;
                           oSC.eval('list['+TRANSFORM(i)+']["lotteryUnsortDrawresult"]'))
ENDFOR
SELECT * FROM tt
RETURN

JS部分这样写好读一点

jsCode = 'var data=' + oHttp.responseText + ';' +;
         'var list=data["value"]["list"];' +;
         'function getList(n,name){return list[n][name];}'
oSC = CREATEOBJECT("ScriptControl")
oSC.Language = "JavaScript"
oSC.AddCode(jsCode)
FOR i=0 TO oSC.eval('list.length')-1
    INSERT INTO tt VALUES (oSC.run("getList",i,"lotteryDrawNum"),;
                           oSC.run("getList",i,"lotteryUnsortDrawresult"))
ENDFOR

看惯VFP的代码，再看别的代码很不习惯！

windows环境避免不了，很多时要通过COM服务应用
面对WEB方面的编程，JS、HTML、CSS才是主体
就好象VFP面对EXCEL，不用VBA怕好难成事