Cancelling the meeting invitation

[amaradiswamy]

Hi All,

We are working on creating outook meeting invitations from Servicenow. For that we have created a table and seems creating good. Now, we want to give the option to cancel and reschedule the meeting invitation. So, is there any way to cancel the meeting invitation by creating a record in servicenow table(how we will compare). Please advice on this.

Thanks & Regards,

Swamy

[Bradford Shelle]

Hi Stacy,

Yes, you can set the timezone! I personally have not done it from sending invites out of ServiceNow, though it should be feasible. The tricky part is if the timezone needs to be dynamic or not. Here are a couple of links that talk about timezones in iCalendar files.

iCalendar spec: 4.6.5 Time Zone Component

RFC 2446 - iCalendar Transport-Independent Interoperability Protocol (iTIP) Scheduling Events, BusyT...

I also recommend making some test meetings for yourself, open up the meeting, Save As an .ics file on your computer, then open up the file with something like Notepad++ to view the contents. Here's a quick example of a meeting I made where I set the time zone to Pacific Standard Time.

BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 16.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VTIMEZONE
TZID:Pacific Standard Time
BEGIN:STANDARD
DTSTART:16011104T020000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=11
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:16010311T020000
RRULE:FREQ=YEARLY;BYDAY=2SU;BYMONTH=3
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
DTEND;TZID="Pacific Standard Time":20170724T113000
DTSTAMP:20170724T132643Z
DTSTART;TZID="Pacific Standard Time":20170724T110000

We can see before the "BEGIN:VEVENT" we have two new begins: VTIMEZONE and DAYLIGHT. In each of these we define the criteria surrounding where the timezone is relative to UTC, and then when daylight savings happens (if applicable). Once we've defined these pieces of criteria, we can call them for the DTSTART and DTEND parameters of our invite. The times listed in DTSTART and DTEND should be the time you want to schedule the meeting in the specified time zone.

Hope this all helps!

[Stacy1]

This was extremely helpful.

I was successful at sending the Time Zone the user wants to set the time for.   The offsets though are not coming through correct.   My local time is PST.   So when it is converting my times it's not quite doing it correct.

For example I did 12:00pm EST and it came in to my box as 8am PST.   So 1 hour to many, and when I did 12:00pm CST it came in to mine as 11:00am PST and it should have been 10am.

I have a feeling it has to do with the standard and daylight settings in the code.   This is what I have put in my email template.   Does anything stand out to you that I need to modify:

BEGIN:VCALENDAR

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

VERSION:2.0

METHOD:REQUEST

BEGIN:VTIMEZONE

TZID:${u_tt_time_zone}

BEGIN:STANDARD

DTSTART:${dtstart}

RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=11

TZOFFSETFROM:-0600

TZOFFSETTO:-0700

END:STANDARD

BEGIN:DAYLIGHT

DTSTART:${dtstart}

RRULE:FREQ=YEARLY;BYDAY=2SU;BYMONTH=3

TZOFFSETFROM:-0700

TZOFFSETTO:-0600

END:DAYLIGHT

END:VTIMEZONE

BEGIN:VEVENT

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

ORGANIZER:MAILTO:${u_provisioner.email}

LOCATION:${u_site_id}

DTSTART;TZID=${u_tt_time_zone}:${dtstart}

DTEND;TZID=${u_tt_time_zone}:${dtend}

UID:${sys_id}

DTSTAMP:${dtstamp}

DESCRIPTION:

SUMMARY:

X-MICROSOFT-CDO-BUSYSTATUS:FREE

X-MICROSOFT-DISALLOW-COUNTER:TRUE

X-SNSYSID:${sys_id}

BEGIN:VALARM

TRIGGER:-PT15M

ACTION:DISPLAY

DESCRIPTION:Reminder

END:VALARM

END:VEVENT

END:VCALENDAR

And one more question.   In the wiki it says if I want the subject line and body (description, summary) to come from my notification to leave them blank here.   However, nothing is coming across in either field.   Should I be putting more in those fields?

Thank you,

Stacy

[Stacy1]

What I just learned in looking at the ics for different time zones is the offsets are different. When CST it's 0500 and 0600 when EST it's 0400 and 0500.   So I believe I am going to have to create a template for each time zone so I can have the correct offsets.

Thanks,

Stacy

[GeauxSteve]

Bradford, I'm sure this should work with the Change Management CAB Workbench meeting invites from Jakarta.   Could you provide an example of the Cancel ICS file for the out of the box invitations?   I think that example would be useful and the specific use case is one many users will have since the CAB Workbench Outlook integration is a big feature of this plugin.

Also, I really appreciate your article: ServiceNow Calendar Invites

[Megh]

METHOD:CANCEL

 DOES NOT SEEM TO BE WORKING NOW.

IT'S WORKING AS EXPECTED WITH :

METHOD:REQUEST
STATUS:CANCELLED