Microsoft Bookings: Graph API or other reporting?

%3CLINGO-SUB%20id%3D%22lingo-sub-227833%22%20slang%3D%22en-US%22%3EMicrosoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-227833%22%20slang%3D%22en-US%22%3EHello%20all!%20I%20am%20trying%20to%20get%20our%20Bookings%20data%20for%20all%20users%20that%20are%20utilizing%20the%20solution%2C%20but%20am%20having%20difficulty%20getting%20a%20report%20setup.%20A%20previous%20thread%20shows%20how%20to%20setup%20an%20Excel%2C%20but%20it%20is%20for%20a%20single%20user%2C%20not%20the%20whole%20organization.%20I%20would%20like%20to%20be%20able%20to%20pull%20reports%20that%20can%20be%20linked%20to%20other%20items%20in%20our%20DB(s)%20and%20would%20need%20to%20get%20this%20on%20a%20daily%2Fweekly%2Fmonthly%20basis.%20We%20have%2020%20or%20so%20users%20on%20Bookings%20now%2C%20but%20have%20to%20way%20of%20tying%20it%20in%20with%20some%20of%20our%20other%20data.%20Has%20anyone%20been%20successful%20in%20setting%20up%20the%20Graph%20API%20(or%20other%20solution)%20to%20get%20this%20information%20out%20in%20any%20format%3F%20As%20long%20as%20I%20can%20get%20the%20data%20out%2C%20I%20can%20work%20on%20getting%20into%20a%20format%20we%20need%2C%20but%20I%20have%20not%20been%20able%20to%20get%20it%20from%20the%20whole%20organization....%20Any%20insight%20would%20be%20greatly%20appreciated!%20Thanks%20in%20advance%20for%20any%20help!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-227833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebookings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1108451%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1108451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89377%22%20target%3D%22_blank%22%3E%40Jerome%20Stockwell%3C%2FA%3E%26nbsp%3BWere%20you%20able%20to%20find%20a%20solution%3F%20We%20are%20having%20the%20same%20issue%2C%20and%20are%20trying%20a%20couple%20of%20work%20arounds.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1108888%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1108888%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F435694%22%20target%3D%22_blank%22%3E%40Segura01%3C%2FA%3E%26nbsp%3Bno%2C%20I%20have%20not.%20It%20is%20quite%20ridiculous%20that%20this%20isn't%20a%20standard%20functionality%20for%20the%20product.%20I%20have%20been%20told%20that%20there%20are%20some%20options%20with%20the%20Graph%20API%2C%20but%20I%20do%20not%20have%20resources%20that%20can%20put%20that%20together%20at%20this%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20try%20and%20update%20if%20I%20do%20find%20someone%20and%2For%20another%20solution.%20Good%20luck!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524376%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89377%22%20target%3D%22_blank%22%3E%40Jerome%20Stockwell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20working%20on%20this%20over%20the%20past%20week%20and%20the%20only%20way%20I%20have%20found%20to%20accomplish%20this%20is%20to%20pull%20that%20information%20from%20MSGraph.%26nbsp%3B%20I'm%20not%20a%20programmer%20or%20powershell%20advanced%20user%3B%20I%20just%20learn%20by%20myself%2C%20so%20this%20was%20a%20big%20learning%20curve.%3C%2FP%3E%3CP%3EAnyways%2C%20there%20were%20quite%20a%20few%20steps%20but%20the%20biggest%20thing%20is%20authenticating%20to%20MSGraph.%26nbsp%3B%20I%20spent%20close%20to%202%20days%20trying%20to%20get%20this%20right.%26nbsp%3B%20I%20can%20now%20pull%20up%20all%20booking%20appointments%20for%20a%20specific%20Booking%20email%20address.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EYou'll%20need%20to%20have%20rights%20to%20add%20App%20registrations%20in%20Azure%20AD%20as%20well%20as%20have%20Full%20Access%20rights%20to%20the%20Booking%20Account's%20mailbox%20(this%20is%20so%20your%20account%20can%20read%2Fpull%20the%20calendar%20info).%26nbsp%3B%20Then%20in%20Powershell%2C%20you'll%20need%20to%20install%202%20modules%3A%3C%2FP%3E%3CP%3EMicrosoft.Graph.Authentication%3C%2FP%3E%3CP%3EMicrosoft.Graph.Bookings%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20get%20this%20to%20pull%20all%20appointments%20for%20all%20Booking%20accounts%20and%20export%20to%20excel.%26nbsp%3B%20Not%20quite%20there%20yet%20though.%26nbsp%3B%20If%20you%20want%20the%20specific%20instructions%2C%20just%20let%20me%20know.%26nbsp%3B%20Since%20I%20just%20got%20this%20working%20yesterday%2C%20I%20still%20have%20to%20document%20it%20for%20work%20so%20I%20can%20supply%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527110%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3BThis%20is%20what%20I%20have%20been%20trying%20to%20do%20for%20a%20while%2C%20but%20I%20have%20not%20had%20the%20time%20to%20look%20into%20it.%20Do%20you%20by%20chance%20have%20any%20documentation%20that%20you%20could%20share%3F%20The%20Graph%20documentation%20is%20lacking%20(at%20least%20what%20I've%20found).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527357%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527357%22%20slang%3D%22en-US%22%3EThe%20hard%20thing%20about%20the%20documentation%20is%20it%20was%20confusing%20to%20me%20cuz%20it%20had%20more%20info%20than%20I%20needed.%3CBR%20%2F%3EAnyway%2C%20going%20to%20work%20on%20the%20documentation%20today%20or%20tomorrow%20and%20will%20let%20you%20know.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527480%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%3A%20Graph%20API%20or%20other%20reporting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3BAny%20little%20bit%20helps.%20I'd%20sure%20appreciate%20it!%20Thanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
Hello all! I am trying to get our Bookings data for all users that are utilizing the solution, but am having difficulty getting a report setup. A previous thread shows how to setup an Excel, but it is for a single user, not the whole organization. I would like to be able to pull reports that can be linked to other items in our DB(s) and would need to get this on a daily/weekly/monthly basis. We have 20 or so users on Bookings now, but have to way of tying it in with some of our other data. Has anyone been successful in setting up the Graph API (or other solution) to get this information out in any format? As long as I can get the data out, I can work on getting into a format we need, but I have not been able to get it from the whole organization.... Any insight would be greatly appreciated! Thanks in advance for any help!
6 Replies

@Jerome Stockwell Were you able to find a solution? We are having the same issue, and are trying a couple of work arounds. 

@Segura01 no, I have not. It is quite ridiculous that this isn't a standard functionality for the product. I have been told that there are some options with the Graph API, but I do not have resources that can put that together at this time.

 

I will try and update if I do find someone and/or another solution. Good luck!

 

@Jerome Stockwell 

I have been working on this over the past week and the only way I have found to accomplish this is to pull that information from MSGraph.  I'm not a programmer or powershell advanced user; I just learn by myself, so this was a big learning curve.

Anyways, there were quite a few steps but the biggest thing is authenticating to MSGraph.  I spent close to 2 days trying to get this right.  I can now pull up all booking appointments for a specific Booking email address.  

You'll need to have rights to add App registrations in Azure AD as well as have Full Access rights to the Booking Account's mailbox (this is so your account can read/pull the calendar info).  Then in Powershell, you'll need to install 2 modules:

Microsoft.Graph.Authentication

Microsoft.Graph.Bookings

 

Trying to get this to pull all appointments for all Booking accounts and export to excel.  Not quite there yet though.  If you want the specific instructions, just let me know.  Since I just got this working yesterday, I still have to document it for work so I can supply it.

@brphillips This is what I have been trying to do for a while, but I have not had the time to look into it. Do you by chance have any documentation that you could share? The Graph documentation is lacking (at least what I've found).

The hard thing about the documentation is it was confusing to me cuz it had more info than I needed.
Anyway, going to work on the documentation today or tomorrow and will let you know.

@brphillips Any little bit helps. I'd sure appreciate it! Thanks!