How do you extract DTSTART...

verda
Mega Expert

‎07-22-2020 09:03 AM

In the inbound action Process CAB meeting invitation replies, the attendee list is extracted by dissecting  the ical content as follows:

var attachmentContent = new GlideSysAttachment().getContent(sysAttachmentsGr);
var attendeeMatch = attachmentContent.match(/ATTENDEE;.*PARTSTAT=.*;/);
var attendanceReply = attendeeMatch.toString().match(/PARTSTAT=(.*);/);

from the following list which is the  attachmentContent how would you extract the DTSTART:

AttachmentContent:BEGIN:VCALENDAR
METHOD:REQUEST
PRODID:Microsoft Exchange Server 2010
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Eastern Standard Time
BEGIN:STANDARD
DTSTART:16010101T020000
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=11
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:16010101T020000
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=2SU;BYMONTH=3
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
ORGANIZER;
ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;CN=IT Service
Desk:
DESCRIPTION;LANGUAGE=en-US:\n
UID:040000008200E00074C5B7101A82E008000000007012A8151E60D601000000000000000
0100000004B2FED01FBF22143B621B9439E116481
SUMMARY;LANGUAGE=en-US:interview
DTSTART;TZID=Eastern Standard Time:20200722T080000
DTEND;TZID=Eastern Standard Time:20200722T083000
CLASS:PUBLIC
PRIORITY:5
DTSTAMP:20200722T154858Z
TRANSP:OPAQUE
STATUS:CONFIRMED
SEQUENCE:0
LOCATION;LANGUAGE=en-US:
X-MICROSOFT-CDO-APPT-SEQUENCE:0
X-MICROSOFT-CDO-OWNERAPPTID:-2070513692
X-MICROSOFT-CDO-BUSYSTATUS:TENTATIVE
X-MICROSOFT-CDO-INTENDEDSTATUS:BUSY
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-CDO-INSTTYPE:0
X-MICROSOFT-DONOTFORWARDMEETING:FALSE
X-MICROSOFT-DISALLOW-COUNTER:FALSE
X-MICROSOFT-LOCATIONS:[]
BEGIN:VALARM
DESCRIPTION:REMINDER
TRIGGER;RELATED=START:-PT15M
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR
0 Helpfuls
  • 2,176 Views
1 REPLY 1

Rakesh Mamidi
ServiceNow Employee
ServiceNow Employee

‎07-23-2020 12:57 AM

Hi,

Are you looking to extract following data ?

DTSTART;TZID=Eastern Standard Time:20200722T080000
DTEND;TZID=Eastern Standard Time:20200722T083000

The DTSTART and DTEND entries are a combination of the date and time in the format, YYYYMMDDThhmmssZ, where YYYY=year, MM=month, DD=day of the month, T=start time character, hh=hour, mm=minutes, ss=seconds, Z=end character. This string expresses the time as Greenwich Mean Time (GMT), on a 24-hour clock so must be adjusted to your time zone.

Whereas TZID is the timezone ID.

Regards,

Rakesh Mamidi

Mark this answer as correct/helpful - if it solves/helps

0 Helpfuls