Meeting Invite (ICS) with RSVP to Google Gmail/Calendar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2015 08:42 AM
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:
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:
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?
- Labels:
-
Instance Configuration
-
Integrations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2015 12:20 AM
Sorry,
I have been busy this week ... Please, try with this file... Remember to change email addresses
Best Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2015 08:07 AM
Hi German,
Thanks, but shortly after my last post, without doing anything in prod, Google started recognizing the RSVP with the OoB ICS file we had in prod. So strange. I'm thinking this was a Google problem after all.
Thank you for all of your help with this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2020 06:16 AM
Hello German,
I am trying to create a Meeting invite in GMail from SN.
I tried to create a payload myself after referring to this post. Below is the code:-
payLoadGmail : function(gr){
var sDate = this._formatDate(gr.u_start_date);
var eDate = this._formatDate(gr.u_end_date);
var GPayload = "";
GPayload+= "BEGIN:VCALENDAR";
GPayload+= "PRODID:-//Google Inc//Google Calendar 70.9054//EN";
GPayload+= "VERSION:2.0";
GPayload+= "CALSCALE:GREGORIAN";
GPayload+= "METHOD:REQUEST";
GPayload+= "BEGIN:VEVENT";
GPayload+= "DTSTART:" + sDate + "\r\n";
GPayload+= "DTEND:" + eDate + "\r\n";
GPayload+= "DTSTAMP:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
GPayload+= "ORGANIZER;CN=Full Name:mailto:abc@abc.com";
GPayload+= "UID:orprgbsiga8otk1g04fcvlfais@google.com";
GPayload+= "ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;CN=https://devxxxxx@servicenowdevelopers.com;X-NUM-GUESTS=0:mailto:xxxxxx@gmail.com";
GPayload+= "CREATED:" + this._formatDate(new GlideDateTime().getValue()) + "\r\n";
GPayload+= "DESCRIPTION:View your event at https://www.google.com/calendar/event?action=VIEW&eid=b3Jwcmdic2lnYThvdGsxZzA0ZmN2bGZhaXMgcmJlZW1hbkBpcnZpbmVjb21wYW55LmNvbQ&tok=MjcjaXNhYmVsbGVlQGlydmluZWNvbXBhbnkuY29tYTc0NDdiYzU3Y2RjOWIwNGI3NjM2NGM5YTcyNjhhN2RhZjc0ZDIwNw&ctz=America/Los_Angeles&hl=en.";
GPayload+= "LAST-MODIFIED:" +this._formatDate(new GlideDateTime().getValue()) + "\r\n";
GPayload+= "LOCATION:TBD";
GPayload+= "SEQUENCE:0";
GPayload+= "STATUS:CONFIRMED";
GPayload+= "SUMMARY:Test";
GPayload+= "TRANSP:OPAQUE";
GPayload+= "END:VEVENT";
GPayload+= "END:VCALENDAR";
gs.log("Payload for google calendar "+GPayload,"Payload for google calendar");
var att = new GlideSysAttachment();
att.write(gr, "Google_Meeting_Invite[" + new GlideDateTime().getValue() + "].ics", 'text/calendar', GPayload);
But i am not receiving any email in my google mail account. For testing, i also sent it to an outlook account, where i received the mail with the attachment link. However, i try open it says operation failed.
Kindly provide inputs/help on this.
Thanks in Advance!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2015 11:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-28-2016 01:54 AM
Hi there.
I am facing a somewhat similar issue here where I am unable to view the detailed meeting invite sent by Outlook to Google mail.
However the software I am using is different from yours. We are using Outlook at work and due to the complications in syncing outlook calendar on phone, I integrated my company email onto gmail and send outlook calendar to my gmail (send to myself) to ease this complication.
Previously, when i forward a outlook calendar invite to my gmail, I was able to view the 'Add to calendar with the RSVP within gmail platform. I recently made some changes to the settings in both outlook and gmail and now all invites from outlook appears with only the ics attachment.
I've spent the whole day trying to fix this. Do you think you can possibly help me out with this?
As a temporary solution, I have resorted to importing/exporting cvs outlook calendar onto gmail calendar. This is a manual task but I would prefer to resort to the earlier setting.