Any way to get data from Google calendars?

[m.ardito]

Not a big priority,

but I wonder if this can be done somehow... or if it coudl be implemented.

Having a sortable list of events from one or more google calendars could help to integrate that data with other SQL apps, in theory.

Did anyone ever try this, maybe using REST API?

[omer.younus]

Hi @Marco,

Yes, that is possible you can use the following Google API's to use fetch calendar information.

Java Quickstart  |  Google Calendar API  |  Google Developers

There are various language option available you can choose any language which is convenient to you.

Thanks

[m.ardito]

Thanks, I know there are API, but I was referring to a Teiid setup, in particular.

Something about setting the connection, with authorization mechanism, and how to get a list of events in a VDB, for example. I had some experience only with Google spreadsheet, which have their own resource adapter, though, this could be quite different.

I used some other oauth2+rest service before, but I am not (yet) completely sure on how to do in this case...

[rareddy]

Marco,

I think there got to be a way to extend the current Google Sheets resource-adapter but writing a new translator will work. That way you do not need to deal with the OAuth authorization stuff again. Even otherwise, we can see if the oauth-util.sh based auth works with Google and then you can use standard "webserivce" resource adapter. If you work on it, would like to see contribution back to Teiid community.

Ramesh..

[shawkins]

> I think there got to be a way to extend the current Google Sheets resource-adapter but writing a new translator will work.

Yes, that should be possible see teiid/GDataClientLoginAPI.java at 66b6685f9ec70c817bb9bafc5832039ac0af15b9 · teiid/teiid · GitHub - which is the core class interacting with the spreadsheet api.  The new classes that would be involved would be CalendarService and CalendarQuery - but I'm not quite sure of how you would want to model it - a calendar is a table, and each event is a row?

[m.ardito]

- but I'm not quite sure of how you would want to model it - a calendar is a table, and each event is a row?

Thanks for the infos. Tbh, I don't think I'll be able to master this matter soon, but I will dig into and try whatever I can: any help appreciated.

And of course I will report every success, too

Yes, that model is what I had in mind...

I have basic experience with Google Calendars, but sometimes I have requests from my company to use some data like that.

It could be the need to share data from people on remote locations, road warriors on mobile, and integrate also data related to resources reservations like classrooms, and so on.

Having a way to review past data, preview future data, aggregate resources usage, people time plannings, could be useful in many ways to us.

Of course we already have some implementation, but they're all different: some data is in RDBMS, other data is in Google calendars, other data is in local spreadsheets, other people could even use different calendaring systems...

Most of those sources are not a problem in Teiid now, but Google calendars (and such) are so much used nowadays, and available also on mobile so, if I could use Teiid to "master them all" together, in SQL, that could be a "game changer"...

Thanks,