Skip to main content
Solved

Update Google Calendar / access spreadsheet add-ons

  • April 15, 2016
  • 3 replies
  • 33 views
J

Here is what I am trying to do: When someone puts a file in a certain folder, I want a notification on my Google Calendar on the day the file was put there.

I guess my first question would be, Is there a way to add things to Google Calendar?

My second question would be, assuming there is not a way to access the Calendar: I am able to create a spreadsheet in Google Docs. Then there is an add-on "From Sheets to Calendar" that will take the information from the spreadsheet and add it to the calendar. Is there a way for FME to access and run that Add-On?

Best answer by fmelizard

I love this scenario!

I presume you're using FME Server? It has a directory watcher that would create a notification to trigger the workspace to do the work.

FME 2016.1 comes with a definition for the "OAUTH" needed to use the "HTTPCaller" with Google Calendar. So pop down an HTTPCaller and go to the bottom Authentication area, and choose Web Connection for the method, and define a new connection in the Connection area. You'll need to authenticate to your google account.

Then we need to figure out the REST API for Google Calendars so we can insert our event. I found this link that defines the API, and this one that gave me a hint about how to format the JSON for the event request.

After battling through it I came up with the attached workspace. You'll need to turn on Authentication in the httpcaller and create a "Web Connection" to your Google Calendar, but it should get you going.

calendarpost.fmw

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • Best Answer
  • April 16, 2016

I love this scenario!

I presume you're using FME Server? It has a directory watcher that would create a notification to trigger the workspace to do the work.

FME 2016.1 comes with a definition for the "OAUTH" needed to use the "HTTPCaller" with Google Calendar. So pop down an HTTPCaller and go to the bottom Authentication area, and choose Web Connection for the method, and define a new connection in the Connection area. You'll need to authenticate to your google account.

Then we need to figure out the REST API for Google Calendars so we can insert our event. I found this link that defines the API, and this one that gave me a hint about how to format the JSON for the event request.

After battling through it I came up with the attached workspace. You'll need to turn on Authentication in the httpcaller and create a "Web Connection" to your Google Calendar, but it should get you going.

calendarpost.fmw

J

I love this scenario!

I presume you're using FME Server? It has a directory watcher that would create a notification to trigger the workspace to do the work.

FME 2016.1 comes with a definition for the "OAUTH" needed to use the "HTTPCaller" with Google Calendar. So pop down an HTTPCaller and go to the bottom Authentication area, and choose Web Connection for the method, and define a new connection in the Connection area. You'll need to authenticate to your google account.

Then we need to figure out the REST API for Google Calendars so we can insert our event. I found this link that defines the API, and this one that gave me a hint about how to format the JSON for the event request.

After battling through it I came up with the attached workspace. You'll need to turn on Authentication in the httpcaller and create a "Web Connection" to your Google Calendar, but it should get you going.

calendarpost.fmw

I am working on FME desktop, but I did get the calendar to update using your caldenarpost.fmw you posted- thank you so much!

mark2atsafe
Safer
Forum|alt.badge.img+59

Nice question!

FME Evangelist to the Rich and Famous!!

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.