Forum Discussion

Deleted's avatar
Deleted
May 24, 2018
Solved

Microsoft Bookings - Reports

Would love to be able to report on Microsoft Bookings. Future pipe line, previous appointments  ect. is this in the roadmap at all?
Bookings
Calendar
office 365
outlook
  • Deleted's avatar
    Deleted
    May 24, 2018

    I agree - this would be great. The only way I've found so far to extract data from Bookings is using Excel:

     

    Data>Get Data>From Online Services>From Microsoft Exchange Online> and then entering the email address associated with the booking page of the calendar. This will at least allow you to pull a list of bookings and show cancellations, etc

abdulrehman_binaltaf's avatar
abdulrehman_binaltaf
MCT
Apr 04, 2021

you can get the data in microsoft graph also. 

login at Graph Explorer - Microsoft Graph

assign the proper permission (check screenshot 01 and 02)

run the below query in GET > beta and copy the id (check screenshot 03)

https://graph.microsoft.com/beta/bookingBusinesses/

replace tttttt with id in the below query 

Now run the below query and you have all the data (check screenshot 04)

https://graph.microsoft.com/beta/bookingBusinesses/tttttt/appointments

 

for more details check Microsoft Bookings and Microsoft Graph | Kurt Hatlevik – Dynamics 365 Blog

 

Resources