Forum Discussion
Retrieve Dynamics 365 Calendar(s)
Actually forget all the previous - have a much easier method.
1. Get data from your dynamics online instance as normal.
2. Select Calendars
3. Wait for Preview
4. Tick the tick box and then hit [edit] - not [load]
5. Find the calender and look for the column calendar_Calendar_Rules
6. Click on the word Table
7. new query will be created blah blah blah, rename etc!
Thanx Maggie- I understand about the get method - just inquiring if anyone has managed to get calendar rule via other black magic methods.
Stan
OK - I have managed to achive what I wanted to do.
Essentially I want the data for a calendar called 'SLA Public Holidays'
How I did it.
Set up an Odata feed as follows;
[get data] - Odata Feed.
Tick advanced
enter URL as
https://{redacted}.api.crm6.dynamics.com/api/data/v9.1/
2nd part is
calendars?$select=name&$expand=calendar_calendar_rules
Click [Ok]
After preview comes back, hit Edit
Then I click the Table entry next to my SLA Public Holidays Calendar in the list of tables returned and a new query is created.
For cleanliness, I rename this new query 'SLAPublicHolidays' and hit close and apply.
Lo and behold I have the details of my SLA Public Holidays calendar!
I ended up with a single table called 'SLAPublicHolidays' that I can extract the EffectiveIntervalStart and the name to get all the public holidays entered into the SLA Public Holidays calendar!
Stan