Service | Customer Service, Contact Center, Fie...

Import holiday into calendar

(3) Share

Report

Posted on by Raphi

186

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

All responses (3)

Answers (0)

Suggested answer

Daivat Vartak (v-9d... 7,805 Super User 2025 Season 1 on at

Like (1)

Report
Import holiday into calendar

Hello 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:

Time-Consuming: Manual entry of holidays for multiple years is incredibly time-consuming and prone to errors.

Maintenance: Maintaining holidays across multiple years and business units becomes a nightmare.

Inconsistency: Manual entry can lead to inconsistencies in holiday definitions.

Workarounds and Considerations (with Limitations):

Manual Entry (The Unfortunate Reality):

This is the officially supported (though highly inefficient) method.

You'll need to manually create each holiday within the "Holiday Schedule" settings.

Tip: If you have recurring holidays (e.g., New Year's Day), you can use the "Recurrence" option to simplify the process, but you'll still need to create the initial holiday.

Custom Development (Unsupported, Risky):

Concept:

You could attempt to use the Dynamics 365 Web API or SDK to create holiday records.

However, as you noted, the internal entities used for holiday scheduling (calendars, calendarrules) are often marked as "internal use only" and are not intended for direct manipulation.

Risks:

Unsupported: This approach is completely unsupported by Microsoft.

Breaking Changes: Future Dynamics 365 updates could break your custom code.

Data Integrity: Directly manipulating internal entities can lead to data corruption or unexpected behavior.

Caution: This method is highly discouraged due to the risks involved.

Power Automate (Limited Automation):

Concept:

While you can't directly import holidays, you could create a Power Automate flow to automate the creation of individual holiday records.

You could use an Excel file or other data source as input for the flow.

Limitations:

You'll still need to manually set up the flow and data source.

The flow would create individual holiday records, which can be slow for large numbers of holidays.

This does not change the fact that the underlaying tables are internal use only.

Use case:

This could be useful for adding a few holidays on a regular basis, but is not a good solution for the initial bulk holiday import.

Third-Party Tools (Potential):

Concept:

There might be third-party tools or solutions available that provide holiday import functionality.

However, thoroughly research and vet any third-party tools before using them.

Considerations:

Ensure the tool is compatible with your Dynamics 365 version.

Check for security and reliability.

Provide Feedback to Microsoft:

UserVoice/Ideas Portal:

Submit a suggestion to Microsoft's Dynamics 365 Ideas portal requesting holiday import functionality.

Clearly explain the pain points and the need for this feature.

Encourage other users to vote for your suggestion.

Support Ticket:

You can also open a support ticket with Microsoft to request this feature.



Recommendation:

Manual Entry (with Recurrence): For now, the most reliable (though tedious) approach is manual entry. Use the "Recurrence" option where possible to reduce the workload.

Provide Feedback: Strongly advocate for holiday import functionality through Microsoft's feedback channels.

Avoid Custom Development: Do not attempt to directly manipulate internal holiday entities due to the risks involved.

Power Automate: Use Power Automate only for small amounts of holiday creation.

Third party tools: Use third party tools with caution.

I understand this is not the ideal answer, but it reflects the current limitations of Dynamics 365 Customer Service holiday scheduling.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Regards,

Daivat Vartak
Suggested answer

sym2 4 on at

Like (0)

Report
Import holiday into calendar

Here is a PowerShell script to load the holidays:

$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() }
Suggested answer

Community Member on at

Like (0)

Report

RE: Import holiday into calendar

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.