Google Calendar API Error 400

Question

I am trying to make a simple free request in the Google Calendar API. I have my authorization, everything works fine, they can view user calendars, etc. When I try to send a request for employment, I get an error of 400 (as far as I can tell), and not the details that I don't like it.

This is true both in my own code and when using the Google Calendar API "Try It" feature.

Here is my request (created using the Try It widget) and the answer: Request

POST https://www.googleapis.com/calendar/v3/freeBusy?key={YOUR_API_KEY} Content-Type: application/json Authorization: Bearer ya29.AHES6ZTr-2wksEvp0iGPTnHTirTIItib5WwxmSAySq1ghfI98Cz88kA X-JavaScript-User-Agent: Google APIs Explorer { "items": [ { "id": "[my calendar id goes here]@group.calendar.google.com" } ], "timeMin": "2012-01-31T09:00:00", "timeMax": "2012-01-31T10:00:00", "timeZone": "GMT" } Response 400 Bad Request cache-control: private, max-age=0 content-encoding: gzip content-length: 122 content-type: application/json; charset=UTF-8 date: Sun, 16 Jun 2013 13:08:32 GMT expires: Sun, 16 Jun 2013 13:08:32 GMT server: GSE { "error": { "errors": [ { "domain": "global", "reason": "badRequest", "message": "Bad Request" } ], "code": 400, "message": "Bad Request" } } 

I think this may have something to do with dateTime objects / formatting? But I have no idea what. I would really appreciate help; I was already staring at her for a week!

Answer 1

Well, I figured it out, and I leave an answer for someone else who LOSES THEIR MINDS.

Despite the fact that the Google documentation says about the format for datetime in this case, the only format I could get was the following:

2008-03-07T17: 06: 02.000Z

so YYYY-MM-DDThh: MM: SS.MMMZ

What is Z? I do not know, but he must be there.

Answer 2

The date time value must be in UTC "TZ" format. Almost all CRMs and the open API accept time in this format. If you convert datetime to UTC using basic language functions / language methods (e.g. C or Java), they will return a datetime instance in the format YYYY-MM-DDTHH: MM: SS.MMMZ.