landscapeinstitute / peoplehr-holiday-office365-sync

Automate Calendar events for PeopleHR Holidays

PeopleHR-Holiday-Office365-Sync

Automate Calendar events for PeopleHR Holidays

Install https://www.microsoft.com/en-us/download/details.aspx?id=35371 on the server that will be running script. This is required to Access EWS

Input your password and username into the main script

The Make-Owner script can be adapted, it is capable of storing admin credentials but could be run manually. We dont recommend storing admin credentials for O365 in plain text on the script.

Run PeopleHRSync-MakeOwner.PS1 , This loops through all your mailboxes and ensures your PeopleHR mailbox is able to add calandar events.

this will give your dedicated service account Ownership over all mailboxes so it can add and delete appointments

this should be run manually everytime you have a new starter. It can however be coded to run automaticly but may be a little overkill thus not included in the main script.

now run PeopleHRSyncEWS.PS1

it should..

1. use peopleHR API to find all employees
2. find all their holidays
3. Removes some legacy entries from an older script i wrote, this can be removed for most people
4. adds the holiday to their calender, their managers calender and any additional accounts specified at the top
5. using an array of holidays for that employee. remove any holidays that are now no longer on PeopleHR
6. Save everything to a log file.

peoplehr-holiday-office365-sync's Issues

Move to EWS from O365 API

Newest Release now EWS based

Holidays Deleted in PeopleHR should remove in O365

The script would need to identify events in the PeopleHR mailbox which do not have an active holiday in PeopleHR API and cancel said event.

Use the Webhook Option to Automate

Set up a basic TCP listener to intercept Webhooks from PeopleHR so the script can run when changes are made rather than on a schedule.

Employees Recieve Event as "Free" status on Calendar but this should be "Busy"

Managers should have the event as status "Free"
Employees should have the event as "Out of Office"
PeopleHR Mailbox should have the event as "Free"

This may require 2 calls to the API to send the event but may cause 2 events in PeopleHR mailbox if done this way.

Errors running the script

PeopleHR-Office365-Errors.txt

I received multiple errors in the file linked. hoping you can help.

Dont store UID in body of event