I'm trying to use a http request to get various data from the Google
calendar system, like the list of calendars, the events in a specific
calendar and so on.
I'm using this:
set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
xmlhttp.open "GET", url, FALSE
xmlhttp.setRequestHeader "Content-type", "application/atom+xml"
xmlhttp.setRequestHeader "X-If-No-Redirect", "True"
xmlhttp.setRequestHeader "Authorization", "GoogleLogin auth=" &
nvp(1)
xmlhttp.send
Where the url will be
https://www.google.com/calendar/feeds/default/allcalendars/full
I'm authenticating via ClientLogin (which seems to work fine, since do get
"private" data out of the requests).
But my question is, how do I get the XML out of the response from the
server?
I've tried using xmlhttp.responseText, but that outputs something like this:
ResponseText:
http://www.google.com/calendar/feeds/default/allcalendars/full2011-05-04T13:54:[email protected]@gmail.comGoogle
Calendar1http://www.google.com/calendar/feeds/default/allcalendars/full/lanicalendar%40gmail.com2011-05-04T13:54:39.947Z2011-05-04T12:00:[email protected]@gmail.comhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp08%40lani.dk2011-05-04T13:54:39.945Z2011-05-03T13:46:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp06%40lani.dk2011-05-04T13:54:39.951Z2011-05-03T13:46:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp07%40lani.dk2011-05-04T13:54:39.947Z2011-05-04T07:16:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp20%40lani.dk2011-05-04T13:54:39.946Z2011-05-03T13:46:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp02%40lani.dk2011-05-04T13:54:39.946Z2011-05-03T12:55:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp03%40lani.dk2011-05-04T13:54:39.945Z2011-05-03T12:55:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp11%40lani.dk2011-05-04T13:54:39.945Z2011-05-03T13:46:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp09%40lani.dk2011-05-04T13:54:39.945Z2011-05-03T12:58:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp01%40lani.dk2011-05-04T13:54:39.964Z2011-05-04T12:00:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp19%40lani.dk2011-05-04T13:54:39.947Z2011-05-03T13:01:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp10%40lani.dk2011-05-04T13:54:39.945Z2011-05-03T12:59:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp04%40lani.dk2011-05-04T13:54:39.964Z2011-05-03T13:19:[email protected]@lani.dkhttp://www.google.com/calendar/feeds/default/allcalendars/full/pp12%40lani.dk2011-05-04T13:54:39.964Z2011-05-04T07:37:[email protected][email protected]
which is not what I expected (yes, the calendar in question is
administrating a bunch of sub-calendars).
I'm not sure what is wrong here, it feels like this is quite close to a
working solution, but not quite there!
--
You received this message because you are subscribed to the Google
Groups "Google Calendar Data API" group.
To post to this group, send email to
[email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://code.google.com/apis/calendar/community/forum.html
