Hi,
I am making an automated report for calendar events based on employees and am running into a really weird issue regarding the get events(v4) and the data it is pulling which complicates all actions below. Currently the calendar we use shows up as EST timezone in all events and settings within the calendar settings. However when i look at what the table is getting as an input from the Get Events(V4) I see it is timezone = utc.
"subject": "Thomas - Personal",
"start": "2024-01-25T18:00:00.0000000",
"end": "2024-01-26T00:00:00.0000000",
"startWithTimeZone": "2024-01-25T18:00:00+00:00",
"endWithTimeZone": "2024-01-26T00:00:00+00:00",
"body": "",
"isHtml": true,
"responseType": "organizer",
"responseTime": "0001-01-01T00:00:00+00:00",
"id": "",
"createdDateTime": "2024-01-25T17:07:19.9106087+00:00",
"lastModifiedDateTime": "2024-01-25T17:07:21.6970464+00:00",
"organizer": "",
"timeZone": "UTC",
"iCalUId": "",
"categories": [],
"webLink": "",
"requiredAttendees": "",
"optionalAttendees": "",
"resourceAttendees": "",
"location": "",
"importance": "normal",
"isAllDay": false,
"recurrence": "none",
"reminderMinutesBeforeStart": 15,
"isReminderOn": false,
"showAs": "oof",
"responseRequested": false,
"sensitivity": "normal"
},
This is throwing everything off by 5 hours and making everything below error out or be inaccurate. I have tried to manually convert it back to UTC -5 for EST timezone and it somewhat works where it pushes back any non full day events to their true time. The catch is any fullday event is rolled over to the next day. Any advice on how to make the Get Events V4 to pull actual data in EST Timezone instead of UTC? As that would remedy the initial issue.
