Is there a ms365_calendar.next_free_slot_calendar_event or something similar?

[fft1010]

Hi,
I hope I am right here. I am trying to book the next free 15 minute Slot in a calendar. I managed to book a free slot in a room (where I check manually before, if it is free) in a HA script:

action: o365.create_calendar_event
metadata: {}
data:
  subject: Framery booking
  start: 2024-12-10T13:00:00+0100
  end: 2024-12-10T13:15:00+0100
target:
  entity_id: calendar.kalender_framery_test

I just wonder, if I need to program "find the next free slot" on my own, or if this might be already somewhere implemented? I did not find anything. Many thanks in advance

all the best
Juergen

[RogerSelwyn]

Hi Juergen,

Thanks for your generosity. I'm afraid you will need to programme that yourself, the integration provides information on what events there are, and to create/update/delete, but it doesn't go beyond that.

Thanks
Roger

[fft1010]

Thanks @RogerSelwyn for your awesome extension.
I'll try my best. As the calendar data is in HA, I might find a way there. I'll dig around, what is the best idea.

thank you
Juergen

[RogerSelwyn]

Just to come back to this one. I've had a look at the MS Graph API, and it appears you can do this in the api - https://learn.microsoft.com/en-us/graph/findmeetingtimes-example

However this isn't supported in the python-o365 library that the integrations use to access the MS graph api - https://github.com/O365/python-o365

My suggestion is that if you want to do this, that you should look at using Node Red to meet you need, possibly using this library - https://flows.nodered.org/node/node-red-contrib-msgraph

Yes, this is a learning curve, but it will enable you to do anything you like on the api.

[RogerSelwyn]

Just to add, I would not plan to implement what is a relatively niche requirement into what is already a very substantial set of integrations.

[fft1010]

Hi @RogerSelwyn,
thank you for your answers! Too bad, that I could not persuade you :-) but I really understand. You already helped me a lot, as I now have two options to get a free spot for booking: MS itself, and I also think, that the idea trying to find a spot in HomeAssistant (as I can access the calendar) might be an option as well.

The MS option is the perfect solution, but as my requirement is: "Book the room where I stand in front for the next 15 minutes", the data is all there locally, and hopefully is easier to access.

But again. Many thanks for your help!

Happy holidays, and a great start in 2025!

all the best
Juergen