iCalendar message gets system date/time not the dates/times from table

[Armin Heinlein1]

I am trying to create an iCalendar invite (scoped application) based on the instructions from the article ServiceNow Calendar Invites

Everything works and I get the invite however it shows the system date as start and end date and not the dates I have in the mapped database fields.

"dtstart" is mapped and "dtend" is mapped

The table record:

The map:

The template:

The output:

[Armin Heinlein1]

The problem was the naming of the sys_impex_map. It should be "icalendar.<table-name>". My problem is that my table name is too long so the iCalendar times are not working properly. So I have to redo all my table name. Can start the application from scratch unless I create some work around. ;-(

[Dagan]

Hi Armin, 

Funny seeing you here, my friend!

I ran into this issue as well, using the sn_apptmnt_booking_appointment_booking table. Since this table is OOB, truncating the name of the table isn't an option, so instead you can alter the dictionary definition of the sys_impex_map.name field to take in a longer value.

By default, all string fields are set to 40 characters in length, which is pretty short to start with. For my purposes, I increased the length to 60 characters. According to the docs page, "For a base system field, you cannot make a change that results in data loss."

[verdakosnett]

For DTSTART and DTEND if you don't append Z to the end of the date, it will produce the server's local time. No need to add to add the location format.