Often when using GSC connector i got this exception. I use default formula like this:
=Dump(Connector("GoogleSearchConsole.SearchAnalytics";"https://www.DOMAIN.pl/";"2016-12-01";"2017-02-13";"query=~"&A1;"web";"3";"0";"Page";FAŁSZ);PRAWDA)
I spread this formula for hundreds cells.
GSC api had some session time or it's a bug?
Edit:
When recalculate cells its working.
When this exception shows all remaining formula got this error.. (So for each remaining cell this message are show).
Most likely trespassing the API limit. According to the documentation, it's 200 per minute, so it makes sense if errors are returned when you run hundreds of urls:
Can you try to use a delay in Global HTTP Settings?
I already have 350 ms delay set up.
Before setting up delay I just got an error about API quota but this was something like API Quota message.
This error is essentially for credentials. I got this when doing hundreds of cells and this taking long time.
I will try replicate API quota error tommorow.
And here it is. - quota error. So invalid credentials is totally other error.
Thanks! Yes, it does appear the error is unrelated. A session timer might be the cause:
"This is due to the fact that the google clients access token has expired. The authentication tokens work for 3600 seconds only."
Does this happen after a while or within an hour?
It showing often after a break (it's possible 60m+) but sometimes it's showing after doing few cells after renewed authentication. I can't replicate at this moment.
