corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Getting a list of events from an Office365 calendar


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Getting a list of events from an Office365 calendar
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
8th Feb 15 at 13:22   View Garage View User's Profile U2U Member Reply With Quote

Right, little project I've got going on over a couple of sites where I want to create some display screens for showing what's on today etc.

I'm a bit of a n00b when it comes to raw 'coding', bit of VB and HTML and PHP and I'm done. Give me a powershell script anyday

I want to basically pull a list of events for today from a calendar in office365 and print it into a nice little formatted list on a webpage:

Event 1 - All Day
Event 2 - 090 to 09:30
Event 3 - 10:30 to 12:30
Event 4 - 15:30 to 17:45.

I'm quite happy for the code to pass a username and password as the web server is internal only. I just have no idea how to do it or where to start! Any pointers?
Dom
Member

Registered: 13th Sep 03
User status: Offline
8th Feb 15 at 14:08   View User's Profile U2U Member Reply With Quote

Look at the Office 365 (calendar) API. Yet to play around with it but it seems relatively(ish) straight forward - authorise an app with O365, authenticate using Oauth2 and then drag (calendar) data out as JSON.

There's a load of documents on MSDN and you'll probably find if you Google, a class/module for accessing it in what ever language you decide to do it with.

Edit - Be interested to hear how you get on with this (using whatever method), as I've got to soon implement something similar for a digital signage project

[Edited on 08-02-2015 by Dom]
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
8th Feb 15 at 20:17   View Garage View User's Profile U2U Member Reply With Quote

If you can get the data from powershell, and I'm betting you can, just write-host it as html to a textfile.htm
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
8th Feb 15 at 20:18   View Garage View User's Profile U2U Member Reply With Quote

http://blogs.technet.com/b/heyscriptingguy/archive/2011/05/24/use-powershell-to-export-outlook-calendar-information.aspx
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
8th Feb 15 at 20:18   View Garage View User's Profile U2U Member Reply With Quote

Might need some work for that work with a o365 calendar though
Dom
Member

Registered: 13th Sep 03
User status: Offline
20th Apr 15 at 12:00   View User's Profile U2U Member Reply With Quote

Did you get anywhere with pulling events out of O365 calendars? If so, what route did you go down?

I'm currently attempting to do the same for digital signage but the API looks an absolute ballache
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
20th Apr 15 at 13:19   View Garage View User's Profile U2U Member Reply With Quote

Exchange 365 supports webcalendars, heres one of ours

http://outlook.office365.com/owa/calendar/b05ff4e267094dacba60c4ba97d4154b@herefordcs.com/3905f34f8b5c417fb02eb726f679282313353780616373256137/calendar.html

Could just stick it in an iframe
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
20th Apr 15 at 17:13   View Garage View User's Profile U2U Member Reply With Quote

Sacked the idea off and used the sims calendar instead. Hence the other thread lol. However it works much better :-)
Dom
Member

Registered: 13th Sep 03
User status: Offline
20th Apr 15 at 19:02   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Steve
Exchange 365 supports webcalendars, heres one of ours

http://outlook.office365.com/owa/calendar/b05ff4e267094dacba60c4ba97d4154b@herefordcs.com/3905f34f8b5c417fb02eb726f679282313353780616373256137/calendar.html

Could just stick it in an iframe


Would have done if it was a shared calendar but apparently that's too much hard work for everyone to keep updated, so i've got to grab events out of everyones individual calendars


Pow - I don't blame you
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
21st Apr 15 at 21:19   View Garage View User's Profile U2U Member Reply With Quote

Thanks Dom

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
trackscotland - vids AK General Chat 12 656
24th Feb 07 at 17:51
by jr
 
Online Calendar Database liamC Geek Day 5 647
3rd Aug 09 at 06:30
by liamC
 
Microsoft Office James Geek Day 26 1518
7th Mar 12 at 21:49
by John
 
Sharepoint calendar to a simple webpage list pow Geek Day 12 534
6th Feb 13 at 09:56
by ed
 
iPhone calendars Robbo Geek Day 7 578
4th Aug 14 at 10:58
by Robbo
 

Corsa Sport » Message Board » Off Day » Geek Day » Getting a list of events from an Office365 calendar 29 database queries in 0.0178528 seconds