You’re offline. This is a read only version of the page.
Announcements
182
Hi
I am currently setting up our dynamics 365 customer service environment and could not find a possibility to import holidays into the holiday scheduling for usage in the SLAs.
I understand that it does not seem to be possible to programmatically import holidays (calendars/calendarrules internal use limitation).
There is an excel import functionality, which does not work either - I get the message "The 'Create' method does not support entities of type 'holidaywrapper'. MessageProcessorCache returned MessageProcessor.Empty.".
Do I have to create EVERY holiday for ALL years manually? Or is there another possibility to import holidays?
Thank you.
Best regards
Raphael
You've hit upon a significant pain point when setting up Dynamics 365 Customer Service SLAs: the lack of a straightforward way to import holidays. The "holidaywrapper" error you're encountering with the Excel import confirms the limitations.
Unfortunately, you are correct in your understanding that there is no officially supported, programmatic, or bulk import method for holidays in Dynamics 365 Customer Service for SLA purposes.
Why This Is a Problem:
Workarounds and Considerations (with Limitations):
Recommendation:
I understand this is not the ideal answer, but it reflects the current limitations of Dynamics 365 Customer Service holiday scheduling.
Share
Report
All responses (
Answers (
$ENV = @{name = "dev1"; url = "https://mydev.dynamics.com"; username = "abc@microsoft.com"; password = "***" }
try {
$password = ConvertTo-SecureString $ENV.password -AsPlainText -Force
$cred = new-object -typename System.Management.Automation.PSCredential -ArgumentList $ENV.username, $password
$conn1 = Connect-CrmOnline -ServerUrl $ENV.url -Credential $cred -ForceOAuth -ErrorAction Stop
$accessToken = $conn1.CurrentAccessToken
# Call Dynamics 365 API
$headers = @{
"Authorization" = "Bearer $accessToken"
"Accept" = "application/json"
"Content-Type" = "application/json; charset=utf-8"
"OData-Version" = "4.0"
}
$resource = "$($ENV.url)/api/data/v9.2/SaveHoliday"
$HolidayCalendarId = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
$filepath = "C:\MyFolder"
$holidays = Import-Csv "$($filepath)\Holidays.csv" #name, starttime
foreach ($e in $holidays) {
if ($e.name) {
$sdat = [DateTime]::Parse($e.starttime).Date.ToString("yyyy-MM-ddTHH:mm:ss") #Truncate time to 00:00:00 and use the ISO format
$edat = [DateTime]::Parse($sdat).AddDays(1).ToString("yyyy-MM-ddTHH:mm:ss") #End the next day
write-host $e.name.padRight('42', ' ') $sdat
# Define JSON Payload
$payload = @{
HolidayInfo = "{`"calendarId`":`"$HolidayCalendarId`",`"calendarRuleId`":`"`",`"name`":`"$($e.name)`",`"scheduledStart`":`"$sdat`",`"scheduledEnd`":`"$edat`",`"timeZone`":-1}"
} | ConvertTo-Json -Compress
$response = Invoke-RestMethod -Method POST -Uri $resource -Headers $headers -body $payload
}
}
}
catch {
Write-Host $_ -ForegroundColor Red
}
finally {
$conn1.Dispose()
}
Hi RaphiB,
Tried to import holiday and get the same error with yours.
And didn't find any other way to import them. So you have to do this manually.
#1
André Arnaud de Cal...
293,354
Super User 2025 Season 1
#2
Martin Dráb
232,498
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
