Error 429 too many request on Power Query

Question

Hello Guys,&nbsp;I'm haveing troubles to end the follwing code.I need to find a solution to error 429...the API has a limit of 15 request per minute...could someone help me?&nbsp;Code:= (CNPJ as number) =&gt;letFonte = Json.Document(Web.Contents("URL" &amp;Text.PadStart(Number.ToText(CNPJ),14,"0")&amp; "&amp;plugin=RF"))inFonte&nbsp;Best regards

v-yingjl · Answer

Hi&nbsp;felipe_pinto&nbsp;,
As the article mentioned, need to add Value.Waitfor() definition in the query, after combining with your code, the final query could be like this:
(CNPJ as number) =&gt;
    let
        Value.WaitFor = (producer as function, interval as function, optional count as number) as any =&gt;
        let
            list = List.Generate(
                () =&gt; {0, null},
                (state) =&gt; state{0} &lt;&gt; null and (count = null or state{0} &lt; count),
                (state) =&gt; if state{1} &lt;&gt; null then {null, state{1}} else {1 + state{0}, Function.InvokeAfter(() =&gt; producer(state{0}), interval(state{0}))},
                (state) =&gt; state{1})
        in
            List.Last(list),

Result = Value.WaitFor(
 
            (iteration) =&gt;
 
            let
 
                content = Web.Contents("URL" &amp;Text.PadStart(Number.ToText(CNPJ),14,"0")&amp; "&amp;plugin=RF", [ManualStatusHandling = {429}]),
 
                buffered = Binary.Buffer(content),
 
                status = Value.Metadata(content)[Response.Status],
 
                actualResult = if status = 429 then null
 
                    else Json.Document(Text.FromBinary(buffered))
 
           in
 
                actualResult,
 
            (iteration) =&gt; #duration(0, 0, 1, 0),
 
            10
 
         )
 
    in
 
        Result
&nbsp;
Best Regards,Community Support Team _ Yingjie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

edhans · Answer

I think that is the site you are hitting, not Power Query itself.

felipe_pinto · Answer

Hello Edhans,Thank you for your reply!!Actually the site is working. The problem is the code beacuse I need to adpat it to wait 60 seconds before to consult another 15 codes. As I said, the API has a limit of 15 request a minute.&nbsp;You will find below a code that could correct and solve my problem, but I'm cannot add it to my code:Here you'll find the link with the codes below:&nbsp;https://4pbi.com/handling-http-errors-with-m-language/&nbsp;Code:&nbsp;Result = Value.WaitFor(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (iteration) =&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;content = Web.Contents(Url, [ManualStatusHandling = {429}]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; buffered = Binary.Buffer(content),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status = Value.Metadata(content)[Response.Status],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actualResult = if status = 429 then null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;else Json.Document(Text.FromBinary(buffered))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actualResult,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (iteration) =&gt; #duration(0, 0, 0, 5),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )******************************************************************************Value.WaitFor = (producer as function, interval as function, optional count as number) as any =&gt;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;list = List.Generate(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;() =&gt; {0, null},&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(state) =&gt; state{0} &lt;&gt; null and (count = null or state{0} &lt; count),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(state) =&gt; if state{1} &lt;&gt; null then {null, state{1}} else {1 + state{0}, Function.InvokeAfter(() =&gt; producer(state{0}), interval(state{0}))},&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(state) =&gt; state{1})&nbsp;&nbsp;&nbsp;&nbsp;in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List.Last(list);&nbsp;&nbsp;&nbsp;&nbsp; in&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Result;****************************************************************Could you help me adding this code to my one?&nbsp;

felipe_pinto · Answer

Hello&nbsp;v-yingjl&nbsp;, how are you doing?Thank you so much for your help and your time.I got the combination you did, I'll try that&nbsp;and see if it's gonna work 🙂Thank you so much one more time!!

Forum Discussion

Error 429 too many request on Power Query

4 Replies

Related content

Power BI refresh Error: Requested value 'None' was not found.

POWER BI, POWER QUERY ERROR: Requested value 'None' was not found

Livy HTTP Request Error

Power BI API 429 too many requests error

requests.exceptions.HTTPError: 400 Client Error: Bad Request for url