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

Luis Barrientos's avatar
Luis Barrientos
Copper Contributor
May 31, 2018

Hi Geoff,

 

Can you explain me in deep how do you accomplish this???

 

Thanks in advance,

  • koichi206's avatar
    koichi206
    Copper Contributor
    Jan 10, 2023

    wow!!  This is so good!

     

    2 things:  How can I get data from a specific year.  Currently the data is defaulting to 2023 data only.

     

    In our booking data, we have custom fields.  It will not load the data.  Is there an enabler somewhere that will allow us to capture tis data too?

    • mk_iu1's avatar
      mk_iu1
      Copper Contributor
      Feb 28, 2023
      Yes thank you abdulrehman_binaltaf -- your Graph Explorer info was extremely helpful. Hopefully there will be a way to access Custom fields in the future
  • user1la2's avatar
    user1la2
    Copper Contributor
    Jun 23, 2020
    Thank you! This is great!
  • walbertoflores's avatar
    walbertoflores
    Copper Contributor
    Feb 12, 2020

    Thanks! It works!

  • Luis Barrientos's avatar
    Luis Barrientos
    Copper Contributor
    Jun 01, 2018

    Thanks Geoff,

     

    I tried with your guide but I'm getting an error that the mailbox address isn't valid, my address is like this:

     

    https://outlook.office365.com/owa/calendar/somename@company.onmicrosoft.com/bookings/

     

    Any idea about this error?

    • Louise Jansen's avatar
      Louise Jansen
      Copper Contributor
      Nov 30, 2018

      i have the same result - reporting on bookings is essential - is there an alternative address to enter?

       

      thanks in advance

    • Deleted's avatar
      Deleted
      Jun 01, 2018

      Hi Luis

       

      Based on what you've said the mailbox name you would enter in Excel is somename@company.onmicrosoft.com , although I would have expected you to be using your own domain name (i.e. company.com) rather than company.onmicrosoft.com

      • Luis Barrientos's avatar
        Luis Barrientos
        Copper Contributor
        Jun 01, 2018

        hmmm, that's the address for my bookings page, no idea why it has an onmicrosoft domain :(

Resources