Click here to Skip to main content
15,867,568 members
Articles / Web Development / ASP.NET

Managing Google Calendar Events using .NET

Rate me:
Please Sign up or sign in to vote.
4.80/5 (10 votes)
15 May 2011CPOL2 min read 65K   38   21
How to create events in Google Calendar programmatically.

Yesterday I posted an article on how to create events in SalesForce programmatically. Now we will do the same thing for Google Calendar. The processes are nearly the same but it’s not as straightforward as the SalesForce one, specially on Event Creation and custom field extensions. One good thing though that Google has is a native .NET API that you can add to your project so you do not need to reference to the Google Calendar Web Service and the DLL handles it for you.

Image 1

First, you need to download that API and add it in your .NET project. You need to install the Google_Data_API_Setup_{CurrentVerion}.msi and to refer to it, you need to browse to “C:\Program Files (x86)\Google\Google Data API SDK\Redist” on 64 bit machines and “C:\Program Files\Google\Google Data API SDK\Redist” on 32 bit machines by default.

Image 2

You need to reference four main items for this scenario and it is as follows:

Image 3

Now include that reference in your code:

C#
using Google.GData.Client;
using Google.GData.Calendar;
using Google.GData.Extensions;

Then like what we had done with the SalesForce article, we need a method for login and here is the code snippet. Again, I provided a proxy setting in case you need it:

C#
private CalendarService GAuthenticate()
{
    string sGoogleUserName = "username";
    string sGooglePassword = "password";
    Uri oCalendarUri = new Uri("http://www.google.com/calendar/feeds/" + 
                               sGoogleUserName + "/private/full");

    //Initialize Calendar Service
    CalendarService oCalendarService = new CalendarService("CalendarSampleApp");
    oCalendarService.setUserCredentials(sGoogleUserName, sGooglePassword);

    //Use Proxy 
    GDataRequestFactory oRequestFactory = 
        (GDataRequestFactory)oCalendarService.RequestFactory;
    WebProxy oWebProxy = new WebProxy(
         WebRequest.DefaultWebProxy.GetProxy(oCalendarUri));
    oWebProxy.Credentials = CredentialCache.DefaultCredentials;
    oWebProxy.UseDefaultCredentials = true;
    oRequestFactory.Proxy = oWebProxy;

    return oCalendarService;
}

Now let's go to the methods you need; on all of the methods discussed below, you will need GAuthenticate to execute your methods.

1. Creating Calendar Entries in Google programmatically

Now if you noticed, we used four different object types unlike in SalesForce where we used only one object which is the SalesForceService.Event. Here we have to define an Event, Where, When, and ExtendedProperty if you need one. ExtendedProperty is a way of adding properties to objects programmatically, so in this case, we created a property called SynchronizationID which will hold our GUID that you can use with other apps. Hint: I use this for my sync application.

C#
//Set Event Entry 
EventEntry oEventEntry = new EventEntry();
oEventEntry.Title.Text = "Test Calendar Entry From .Net";
oEventEntry.Content.Content = 
  "Hurrah!!! I posted my first Google calendar event through .Net";

//Set Event Location 
Where oEventLocation = new Where();
oEventLocation.ValueString = "New Zealand";
oEventEntry.Locations.Add(oEventLocation);

//Set Event Time
When oEventTime = new When(new DateTime(2011, 5, 31, 9, 0, 0), 
     new DateTime(2011, 5, 31, 9, 0, 0).AddHours(1));
oEventEntry.Times.Add(oEventTime);

//Set Additional Properties
ExtendedProperty oExtendedProperty = new ExtendedProperty();
oExtendedProperty.Name = "SynchronizationID";
oExtendedProperty.Value = Guid.NewGuid().ToString();
oEventEntry.ExtensionElements.Add(oExtendedProperty);

CalendarService oCalendarService = GAuthenticate();

//Prevents This Error
//{"The remote server returned an error: (417) Expectation failed."}
System.Net.ServicePointManager.Expect100Continue = false;

//Save Event
oCalendarService.Insert(oCalendarUri, oEventEntry);

You might also notice the line “System.Net.ServicePointManager.Expect100Continue = false” takes care of the HTTP 417 Error, which is explained here.

2. Searching Calendar Entries in Google programmatically

Searching is also straightforward, just use the EventQuery properties to pass to the CalendarService.Query method. Set EventQuery.Query to the same query you use when you search for the calendar in Google.

Image 4

You can also filter by date start and end by using the StartDate and EndDate properties.

C#
CalendarService oCalendarService = GAuthenticate();

//Search for Event
EventQuery oEventQuery = new EventQuery(oCalendarUri.ToString());
oEventQuery.Query = "Query String";
oEventQuery.StartDate = new DateTime(2011, 6, 5);
oEventQuery.EndDate = new DateTime(2012, 6, 5);

Google.GData.Calendar.EventFeed oEventFeed = oCalendarService.Query(oEventQuery);

//Delete Related Events
foreach (EventEntry oEventEntry in oEventFeed.Entries)
{
    //Do your stuff here
    string sEventTitle = oEventEntry.Title.ToString();
}

But if you want to search for the ExtendedProperty like the SynchronizationID we created on the event creation on step 1, then you need to use the ExtraParameters property and use extq=[YourCutomProperty:TheValue] to get what you need.

C#
CalendarService oCalendarService = GAuthenticate();

//Search for Event
EventQuery oEventQuery = new EventQuery(oCalendarUri.ToString());
oEventQuery.ExtraParameters = "extq=[SynchronizationID:Your GUID Here]";

Google.GData.Calendar.EventFeed oEventFeed = oCalendarService.Query(oEventQuery);

//Delete Related Events
foreach (EventEntry oEventEntry in oEventFeed.Entries)
{
    //Do your stuff here
    string sEventTitle = oEventEntry.Title.ToString();
}

3. Updating Calendar Entries in Google programmatically

Updating is straightforward, just search for the item and then use the CalendarService.Update method.

C#
CalendarService oCalendarService = GAuthenticate();

//Search for Event
EventQuery oEventQuery = new EventQuery(oCalendarUri.ToString());
oEventQuery.ExtraParameters = "extq=[SynchronizationID:{Your GUID Here}]";

Google.GData.Calendar.EventFeed oEventFeed = oCalendarService.Query(oEventQuery);

//Delete Related Events
foreach (EventEntry oEventEntry in oEventFeed.Entries)
{
    //Update Event
    oEventEntry.Title.Text = "Updated Entry";

    oCalendarService.Update(oEventEntry);
    break;
}

4. Deleting Calendar Entries in Google programatically

Deleting is straightforward as well, just search for the item and then use the CalendarService.Delete method.

C#
CalendarService oCalendarService = GAuthenticate();

//Search for Event
EventQuery oEventQuery = new EventQuery(oCalendarUri.ToString());
oEventQuery.ExtraParameters = "extq=[SynchronizationID:{Your GUID Here}]";

Google.GData.Calendar.EventFeed oEventFeed = oCalendarService.Query(oEventQuery);

//Delete Related Events
foreach (EventEntry oEventEntry in oEventFeed.Entries)
{
    oEventEntry.Delete();
    break;
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead
New Zealand New Zealand
http://nz.linkedin.com/in/macaalay
http://macaalay.com/

Comments and Discussions

 
Questionsub : Calendar.exe Exception request failed Pin
p_ashokkumar_be23-Apr-15 0:16
p_ashokkumar_be23-Apr-15 0:16 
QuestionCan you search for multiple ID's at once? Pin
sirdaveo1-Feb-14 18:00
sirdaveo1-Feb-14 18:00 
GeneralMy vote of 5 Pin
shielawxy4-Oct-12 8:49
shielawxy4-Oct-12 8:49 
QuestionA specific calendar Pin
Paul Rohith4-Sep-12 2:36
Paul Rohith4-Sep-12 2:36 
GeneralUri needs to be https Pin
Alind Gupta8-Jul-12 22:41
Alind Gupta8-Jul-12 22:41 
GeneralRe: Uri needs to be https Pin
Paul Rohith4-Sep-12 2:49
Paul Rohith4-Sep-12 2:49 
QuestionHow do I clear this error when trying to use this program? Pin
John Sterling Robertson23-Mar-12 3:59
John Sterling Robertson23-Mar-12 3:59 
QuestionRe: How do I clear this error when trying to use this program? Pin
Raymund Macaalay25-Mar-12 12:12
Raymund Macaalay25-Mar-12 12:12 
AnswerRe: How do I clear this error when trying to use this program? Pin
John Sterling Robertson26-Mar-12 2:46
John Sterling Robertson26-Mar-12 2:46 
GeneralRe: How do I clear this error when trying to use this program? Pin
Raymund Macaalay28-Mar-12 9:00
Raymund Macaalay28-Mar-12 9:00 
Does it make an exception in the last line?
oCalendarService.Insert(oCalendarUri, oEventEntry);


Have you checked if the oCalendarService have successfully authenticated?

Also can you return the last line as an EventEntry object and see whats inside.
QuestionMy vote of 5! Pin
MaulikDusara7-Nov-11 17:32
MaulikDusara7-Nov-11 17:32 
Questionauthentication Issue Pin
Azmat ullah8-Aug-11 3:44
Azmat ullah8-Aug-11 3:44 
AnswerRe: authentication Issue Pin
Raymund Macaalay8-Aug-11 10:05
Raymund Macaalay8-Aug-11 10:05 
GeneralRe: authentication Issue Pin
Azmat ullah16-Aug-11 21:22
Azmat ullah16-Aug-11 21:22 
AnswerRe: authentication Issue Pin
jackie12312-Sep-11 8:33
jackie12312-Sep-11 8:33 
AnswerRe: authentication Issue Pin
CoreyJG15-Dec-11 10:31
CoreyJG15-Dec-11 10:31 
GeneralRe: authentication Issue Pin
deepu sehrawat25-Sep-12 20:32
deepu sehrawat25-Sep-12 20:32 
AnswerAuthentication Error 405 Pin
Alhoot200419-Feb-13 14:49
professionalAlhoot200419-Feb-13 14:49 
GeneralMy vote of 5 Pin
yrsk.aravind27-Jul-11 9:27
yrsk.aravind27-Jul-11 9:27 
GeneralMy vote of 5 Pin
krb4220-May-11 3:45
krb4220-May-11 3:45 
GeneralMy vote of 5 Pin
saxenaabhi615-May-11 19:38
saxenaabhi615-May-11 19:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.