After adding google calendar as a source, appsheet shows an error of permission

[maretec]

After adding Google Calendar as a source, the app works fine. I can add an event from Appsheet and it appears in the Google Calendar and vice versa, but minutes later, Appsheet shows an error.

This is the error message.

Unable to fetch app definition.
Error: Data table 'App para Talleres' is not accessible due to: The service calendar has thrown an exception. HttpStatusCode is Forbidden. Request had insufficient authentication scopes.: Message[Insufficient Permission] Location[ - ] Reason[insufficientPermissions] Domain[global].

The owner of the app is the same as the owner of the calendar.

I deleted the table created from the calendar and I created it again, but with the same result (the app stops working and displays the error message).

I found this article: Error message for calendar datasource

Any idea what's going on?

[Trevwiller]

Is the Table Accessed as user or creator? 

[maretec]

Hello Trevwiller.  The table is accessed as app creator.

[maretec]

Mobile view doesn't work, but desktop view still works.

The desktop view shows a red exclamation mark, but I can still add, edit, etc.

[AleksiAlkio]

Have you tried to signout from your AppSheet account and then logged in again?

[maretec]

I just did it, but the mobile view won't load. I did it twice. The second time I used an incognito window.

[Steve]

Likely an internal bug. Please contact AppSheet Support for help with this.

Attn @AleksiAlkio

[maretec]

Most of the time this community gives me the answers, not Appsheet support, but I will reach out to them.

[Steve]

Attn @devingu 

[maretec]

I have contacted support but they have no idea. The agent is going to escalate this issue.

[maretec]

The first 2 times, I added the calendar using this "Plus" sign

The third time I added using this steps of this article: Use data from Google Calendar

1. Select My Account in the top navigation bar.
2. Select Sources.
3. Click + New Data Source.
4. Enter a name for the data source in the field provided.
5. Click Google Calendar and follow the prompts to authenticate.

The issue persisted.  Usually, the issue shows up some minutes later.

I re authenticated the calendar. It's been 60 minutes since the re authentication and the app is still working.  I'll wait until tomorrow to see if the problem is gone.

[maretec · Accepted solution]

Hello. Everything seems to be fine.

I added the calendar using 2 ways:

1. By clicking the plus sign at the top of the tables.
2. By following the steps in the article How to use Google Calendar data.

The first one gave me the error and didn't work.

The second one works. In addition to following the steps in the article, I had to re-authenticate Appsheet with Google Calendar.

Thank you for your time @Trevwiller, @AleksiAlkio and @Steve.

[AleksiAlkio]

Then it sounds the access token (or refresh token) was expired and because the Google Calendar is the secondary data source, logging out and in doesn't refresh the token. It only refresh the access token with your primary/default data source you used when you created your AppSheet account.