Forum Discussion

Oleh_Karavskyi's avatar
Oleh_Karavskyi
Frequent Visitor
4 years ago

Auto refresh/ connect to google sheets doesn't work, always getting Error: (429): Too Many Requests

Hi.
Could you pls help, want to connect to google sheets and at least one time per day update my bi dasbords app/ workspase

Always when I try update manyally or set schedule update always getting such error:

Processing errorWeb.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/*******?fields=sheets/properties,namedRanges' (429): Too Many Requests

 

I don't need to update data every minute, just want that bi managed to take updated data from google sheets one/two times per day

APIS and Embedding

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Oleh_Karavskyi 

    The HTTP 429 Too Many Requests response status code indicates the user has sent too many requests in a given amount of time. How did you connect to Google and get data? Web connector or REST API ?

     

    Best Regard

    Community Support Team _ Ailsa Tao

    • Oleh_Karavskyi's avatar
      Oleh_Karavskyi
      Frequent Visitor
      4 years ago

      HI!@,

      Thank you a lot for your soonest response!
      I'm connecting to google sheets using = GoogleSheets.Contents(
      with Organisational privacy level