Google Calendar API获取事件时间与日历站点不一致问题求助

问题概述 #

老板在Google日历网页端修改了某事件的起止时间（应于以色列时间2023-04-06 19:15开始），4天后通过Google Calendar API获取该事件时，返回的开始时间仍为17:30（Asia/Jerusalem时区），已排除时区问题，怀疑API未同步更新后的信息。事件ID：6goj0c9h6hh38bb2cos32b9k61j3gb9o75imab9ickp62p1o74rjgdr46s_R20230406T143000

API返回的Event对象如下：

Google\Service\Calendar\Event Object
(
    [collection_key:protected] => recurrence
    [anyoneCanAddSelf] =>
    [attachmentsType:protected] => Google\Service\Calendar\EventAttachment
    [attachmentsDataType:protected] => array
    [attendeesType:protected] => Google\Service\Calendar\EventAttendee
    [attendeesDataType:protected] => array
    [attendeesOmitted] =>
    [colorId] =>
    [conferenceDataType:protected] => Google\Service\Calendar\ConferenceData
    [conferenceDataDataType:protected] =>
    [created] => 2023-02-22T07:13:30.000Z
    [creatorType:protected] => Google\Service\Calendar\EventCreator
    [creatorDataType:protected] =>
    [description] =>
    [endType:protected] => Google\Service\Calendar\EventDateTime
    [endDataType:protected] =>
    [endTimeUnspecified] =>
    [etag] => "3359659681366000"
    [eventType] => default
    [extendedPropertiesType:protected] => Google\Service\Calendar\EventExtendedProperties
    [extendedPropertiesDataType:protected] =>
    [gadgetType:protected] => Google\Service\Calendar\EventGadget
    [gadgetDataType:protected] =>
    [guestsCanInviteOthers] =>
    [guestsCanModify] =>
    [guestsCanSeeOtherGuests] =>
    [hangoutLink] =>
    [htmlLink] => https://www.google.com/calendar/event?eid=NmdvajBjOWg2aGgzOGJiMmNvczMyYjlrNjFqM2diOW83NWltYWI5aWNrcDYycDFvNzRyamdkcjQ2c18yMDIzMDQwNlQxNDMwMDBaIHJvbmVua21hbkBt
    [iCalUID] => 6goj0c9h6hh38bb2cos32b9k61j3gb9o75imab9ickp62p1o74rjgdr46s_R20230406T143000@google.com
    [id] => 6goj0c9h6hh38bb2cos32b9k61j3gb9o75imab9ickp62p1o74rjgdr46s_R20230406T143000
    [kind] => calendar#event
    [location] =>
    [locked] =>
    [organizerType:protected] => Google\Service\Calendar\EventOrganizer
    [organizerDataType:protected] =>
    [originalStartTimeType:protected] => Google\Service\Calendar\EventDateTime
    [originalStartTimeDataType:protected] =>
    [privateCopy] =>
    [recurrence] => Array
        (
            [0] => RRULE:FREQ=WEEKLY;WKST=MO
        )

    [recurringEventId] =>
    [remindersType:protected] => Google\Service\Calendar\EventReminders
    [remindersDataType:protected] =>
    [sequence] => 0
    [sourceType:protected] => Google\Service\Calendar\EventSource
    [sourceDataType:protected] =>
    [startType:protected] => Google\Service\Calendar\EventDateTime
    [startDataType:protected] =>
    [status] => confirmed
    [summary] => תפוס
    [transparency] =>
    [updated] => 2023-03-26T11:24:00.683Z
    [visibility] =>
    [internal_gapi_mappings:protected] => Array
        (
        )

    [modelData:protected] => Array
        (
        )

    [processed:protected] => Array
        (
        )

    [creator] => Google\Service\Calendar\EventCreator Object
        (
            [displayName] =>
            [email] => <stripped>@gmail.com
            [id] =>
            [self] => 1
            [internal_gapi_mappings:protected] => Array
                (
                )

            [modelData:protected] => Array
                (
                )

            [processed:protected] => Array
                (
                )

        )

    [organizer] => Google\Service\Calendar\EventOrganizer Object
        (
            [displayName] =>
            [email] => <stripped>@gmail.com
            [id] =>
            [self] => 1
            [internal_gapi_mappings:protected] => Array
                (
                )

            [modelData:protected] => Array
                (
                )

            [processed:protected] => Array
                (
                )

        )

    [start] => Google\Service\Calendar\EventDateTime Object
        (
            [date] =>
            [dateTime] => 2023-04-06T17:30:00+03:00
            [timeZone] => Asia/Jerusalem
            [internal_gapi_mappings:protected] => Array
                (
                )

            [modelData:protected] => Array
                (
                )

            [processed:protected] => Array
                (
                )

        )

    [end] => Google\Service\Calendar\EventDateTime Object
        (
            [date] =>
            [dateTime] => 2023-04-06T21:00:00+03:00
            [timeZone] => Asia/Jerusalem
            [internal_gapi_mappings:protected] => Array
                (
                )

            [modelData:protected] => Array
                (
                )

            [processed:protected] => Array
                (
                )

        )

    [reminders] => Google\Service\Calendar\EventReminders Object
        (
            [collection_key:protected] => overrides
            [overridesType:protected] => Google\Service\Calendar\EventReminder
            [overridesDataType:protected] => array
            [useDefault] => 1
            [internal_gapi_mappings:protected] => Array
                (
                )

            [modelData:protected] => Array
                (
                )

            [processed:protected] => Array
                (
                )

        )

)

排查与解决步骤 #

1. 确认事件是否为循环事件的单个实例 #

从API返回的recurrence字段可见，该事件是每周重复的循环事件。如果老板修改的是单个实例而非整个系列，需确保API请求时指定了正确的实例ID，或者调用events.get时传入originalStartTime参数获取修改后的实例。

2. 校验API请求参数 #

• 确认调用events.get时使用了正确的日历ID（通常为用户主邮箱地址）。
• 检查请求中是否包含showDeleted、singleEvents等可能干扰结果的参数，确保参数设置符合需求。

3. 强制获取最新数据（绕过缓存） #

Google Calendar API可能返回缓存结果，可通过以下方式强制刷新：

• 在请求头中添加cache-control: no-cache。
• 利用etag做条件请求：对比本地存储的etag与API返回值，不一致时再拉取新数据。
• 直接调用events.get接口（而非通过列表查询），能更直接获取最新事件信息。

4. 核对事件更新标识 #

API返回的sequence为0，updated时间为2023-03-26T11:24:00.683Z，与老板修改时间（4天前）不符，说明返回的是旧数据：

• 手动在网页端再次修改事件时间，观察网页端的更新时间是否变化，再调用API验证updated和sequence字段是否更新。
• 若网页端更新时间晚于API返回的updated，则可能是服务端同步延迟。

5. 排查权限问题 #

确保API使用的服务账号/OAuth令牌拥有该日历的读写权限，无权限限制导致无法获取最新数据。可尝试用拥有该日历权限的个人账号直接调用API测试。

6. 提交官方支持工单 #

若以上步骤均无法解决问题，可能是Google Calendar服务端同步故障，建议提交Google Cloud支持工单，提供事件ID、API请求详情、网页端事件截图等信息，请求官方排查。

内容的提问来源于stack exchange，提问作者HelloWorld