We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Meeting Invite (ICS) with RSVP to Google Gmail/Calendar

rbeeman
Mega Sage

We have just recently switched our domain from Outlook/Exchange to Google Apps. In Outlook, our meeting invites that come from OoB Changes worked just fine. Once we switched to Google, our users were just receiving a blank email with an attached ICS file that Gmail wouldn't parse. We have an older instance and I found that the change.calendar.integration email template had this line with a variable that resolved to nothing.

PRIORITY:${priority}

I checked a clean personal developer instance, and I saw that they now hardcode it to this:

PRIORITY:3

After I changed that line on our template, Gmail now parses it, but it just has an "Add to Calendar" option instead of a "Yes, No, Maybe" RSVP.

Current State:

Add_to_calendar.jpg

We noticed that without the RSVP, the invite does not get recognized on iPhones as a meeting request so it doesn't get automatically added to users' calendars. We are trying to get the Yes, No, Maybe options from an RSVP like this:

Desired State:

Yes_no_maybe.jpg

We are using the OoB change.calendar.integration template, which is:

BEGIN:VCALENDAR

PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN

VERSION:2.0

METHOD:REQUEST

BEGIN:VEVENT

ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:${to}

ORGANIZER:MAILTO:${from}

DTSTART:${dtstart}

DTEND:${dtend}

LOCATION:${location}

TRANSP:OPAQUE

SEQUENCE:${sys_mod_count}

UID:${number}

DTSTAMP:${dtstamp}

DESCRIPTION:${description}

SUMMARY:${summary}

PRIORITY:3

X-MICROSOFT-CDO-IMPORTANCE:${priority}

STATUS:CONFIRMED

CLASS:PUBLIC

END:VEVENT

END:VCALENDAR

Has anyone got this to work properly with Google specifically?

15 REPLIES 15

As an experiment, I copy and pasted the ICS file from Google into my change.calendar.integration template and created a Change to test. So I am and sending their own ICS file back all hardcoded. It reverted to the blank email with just a download link to the ICS file. It didn't parse it at all.


Try to put the original one, but with "PARTSTAT=NEEDS-ACTION" parameter at   ATTENDEE line


I tried to add to Outlook the file you created with google, and it is not valid...



Interesting...


I tried again, with a little more care, and I had to delete two additional spaces at each line, and now it's working as expected, so, there seems to be the problem. Please, be carefull with the line formatting!



find_real_file.png


I see what you mean about the two extra characters. I removed them and tried emailing it again. It came out like this...google_test.jpg



Why does it keep changing?