{"id":181810,"date":"2026-03-19T16:26:30","date_gmt":"2026-03-19T07:26:30","guid":{"rendered":"https:\/\/support.questetra.com\/?p=181810"},"modified":"2026-03-19T17:44:32","modified_gmt":"2026-03-19T08:44:32","slug":"googlecalendar-eventslist-get-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/googlecalendar-eventslist-get-2026\/","title":{"rendered":"Google Calendar: Get events list (schedules)"},"content":{"rendered":"\n

Google Calendar: Get events list (schedules)<\/strong><\/h4>\n\n\n\n

Google Calendar \u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u53d6\u5f97<\/a><\/p>\n\n\n\n

Accesses Google Calendar and retrieves a list of events\/schedules registered during the specified time period. Utilizing this Task in a Workflow will make it possible to get the next week\u2019s schedule, and announce it by email.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_UserID<\/dt>
C1: User who connects to Google Calendar *<\/span><\/dd>\n
conf_CalendarId<\/dt>
C2: Set CalendarID *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_StartDate<\/dt>
C3: Select DATE DATA for Start Date *<\/span><\/dd>\n
conf_EndDate<\/dt>
C4: Select DATE DATA for End Date *<\/span><\/dd>\n
conf_Timezone<\/dt>
C5: Set Timezone of Date Data (e.g -07:00) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
conf_EventsList<\/dt>
C6: Data Item that will save Events List *<\/span><\/dd>\n
conf_Response<\/dt>
C7: Data Item that will save Response<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/*\nNotes(en):\n- This request requires authorization with at least one of the following scopes:\n    - https:\/\/www.googleapis.com\/auth\/calendar.readonly\n    - https:\/\/www.googleapis.com\/auth\/calendar\n    - https:\/\/www.googleapis.com\/auth\/calendar.events.readonly\n    - https:\/\/www.googleapis.com\/auth\/calendar.events\n- Supports both My Calendars and Other Calendars.\n\nNotes(ja):\n- \u30ab\u30ec\u30f3\u30c0\u30fc\u6a29\u9650\u3092\u6301\u3064\u30e6\u30fc\u30b6\u306b\u3088\u308a\u3001OAuth\u8a8d\u53ef\u3055\u308c\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\uff08\u4ee5\u4e0b\u306e\u3046\u3061\u5c11\u306a\u304f\u3068\u3082\uff11\u3064\uff09\n    - https:\/\/www.googleapis.com\/auth\/calendar.readonly\n    - https:\/\/www.googleapis.com\/auth\/calendar\n    - https:\/\/www.googleapis.com\/auth\/calendar.events.readonly\n    - https:\/\/www.googleapis.com\/auth\/calendar.events\n- \u30de\u30a4\u30ab\u30ec\u30f3\u30c0\u30fc\u3068\u4ed6\u306e\u30ab\u30ec\u30f3\u30c0\u30fc\u306e\u4e21\u65b9\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\n\nNotes:\n- See Also\n   - https:\/\/developers.google.com\/calendar\/v3\/reference\/events\/list\n- To Get "ClientId" and "Secret"\n    - Access to https:\/\/console.developers.google.com\/\n- OAuth Setting sample\n    - "Authorization Endpoint URL"\n        - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n    - "Token Endpoint URL"\n        - https:\/\/accounts.google.com\/o\/oauth2\/token\n    - "Scope"\n        - https:\/\/www.googleapis.com\/auth\/calendar.events.readonly\n- Error Log sample (wrong CalendarID or Scope)\n    - AutomatedTask UnexpectedResponseError: 404\n        - { "error": {\n        - "errors": [ {\n        -     "domain": "global",\n        -     "reason": "notFound",\n        -     "message": "Not Found"\n        -    } ],\n        -   "code": 404,\n        -   "message": "Not Found"\n        - } }\n\n*\/\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main() {\n\n  \/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\n  const quser = configs.getObject( "conf_UserID" ); \/\/ com.questetra.bpms.core.event.scripttask.QuserView\n  const calendarId = configs.get( "conf_CalendarId" );\n  const startDateNum = configs.get( "conf_StartDate" );\n  const endDateNum = configs.get( "conf_EndDate" );\n  let   timezone = configs.get( "conf_Timezone" );\n  const eventsListNum = configs.get( "conf_EventsList" );\n  const responseNum = configs.get( "conf_Response" );\n\n\n  \/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n  const startDate = engine.findDataByNumber(startDateNum); \/\/ com.questetra.bpms.util.AddableDate\n  const endDate = engine.findDataByNumber(endDateNum); \/\/ com.questetra.bpms.util.AddableDate\n\n\n  \/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n  \/\/\/ Check Required\n  if ( calendarId === null || calendarId === "" ) {\n    throw "the CalendarID is empty.";\n  }\n  if ( startDate === null ) {\n    throw "the Start Date is empty.";\n  }\n  if ( endDate === null ) {\n    throw "the End Date is empty.";\n  }\n  if ( timezone === null || timezone === "" ) {\n    throw "the Timezone is empty.";\n  }\n\n  \/\/\/ Check Start Date \/ End Date Validity\n  if ( startDate.compareTo( endDate ) >= 1 ) {\n    \/\/ startDate > endDate\n    throw "The End Date should be the day after the Start Date.";\n  }\n\n  \/\/\/ Check Timezone Validity\n  if ( timezone.match(\/^([\\+\\-]?)([01][0-9]|2[0-3]):([0-5][0-9])$\/) == null ) {\n    throw "The Timezone format is incorrect.";\n  } else if ( timezone.match(\/^([01][0-9]|2[0-3]):([0-5][0-9])$\/) !== null ) {\n    \/\/ e.g.)  00:00, 09:00, -08:00  -->  +00:00, +09:00, -08:00\n    timezone = "+" + timezone;\n  }\n\n  \/\/\/ Get Events List\n  const responseTxt = getEventsList(quser, calendarId, startDate, endDate, timezone);\n\n  \/\/\/ Retrieve StartDate\/StartTime\/Summary date\n  const eventsListTsv = retrieveData( JSON.parse(responseTxt) );\n\n\n  \/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n  engine.setDataByNumber( eventsListNum, eventsListTsv );\n  if ( responseNum !== null && responseNum !== "") {\n    engine.setDataByNumber( responseNum, responseTxt );\n  }\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/**\n * Google Calendar \u304b\u3089\u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u3092\u53d6\u5f97\u3059\u308b\n * @param {Quser} quser \u8a8d\u8a3c\u30e6\u30fc\u30b6\n * @param {calendarId} Calendar's ID\n * @param {Date} startDate \u53c2\u7167\u671f\u9593\u958b\u59cb\u65e5\n * @param {Date} endDate \u53c2\u7167\u671f\u9593\u7d42\u4e86\u65e5\n * @param {String} timezone \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\n * @return {String} HTTP-Response (String)\n *\/\nfunction getEventsList(quser, calendarId, startDate, endDate, timezone) {\n\n  const uri = "https:\/\/www.googleapis.com\/calendar\/v3\/calendars\/" + calendarId + "\/events";\n  const sdf = new java.text.SimpleDateFormat("yyyy-MM-dd");\n\n  const response = httpClient.begin()\n    .googleOAuth2(quser, "Calendar")\n    .queryParam( "timeMax", sdf.format(endDate)   + "T23:59:59" + timezone )\n    .queryParam( "timeMin", sdf.format(startDate) + "T00:00:00" + timezone )\n    .queryParam( "timeZone", timezone )\n    .queryParam( "singleEvents", "True" )\n    .queryParam( "orderBy", "startTime" )\n    .get( uri );\n\n  const status = response.getStatusCode();\n  const responseTxt = response.getResponseAsString();\n\n  if (status >= 300) {\n    const error = `Failed to create\\nstatus:${status}`;\n    engine.log(responseTxt);\n    throw error;\n  }\n\n  return responseTxt;\n}\n\n\/**\n * \u53d6\u5f97\u3057\u305f\u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u304b\u3089 \u958b\u59cb\u65e5\uff0f\u958b\u59cb\u65e5\u6642\uff0f\u30b5\u30de\u30ea\u30fc\u3092\u62bd\u51fa\u3059\u308b\n * @param {String} eventsListJson \u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u306eJSON\n * @return {String} eventsListTsv \u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30c8\uff08\u4e88\u5b9a\uff09\u306e\u958b\u59cb\u65e5\uff0f\u958b\u59cb\u65e5\u6642\uff0f\u30b5\u30de\u30ea\u30fc\u306eTSV\n *\/\nfunction retrieveData(eventsListJson) {\n\n  let eventsListTsv = "";\n\n  for( let i = 0; i < eventsListJson.items.length; i++ ) {\n  \n    if ( "dateTime" in eventsListJson.items[i].start ) {\n      \/\/ "dateTime": "2021-01-18T13:00:00+09:00"\n      eventsListTsv += eventsListJson.items[i].start.dateTime.substring(0, 10);\n      eventsListTsv += "\\t(" + eventsListJson.items[i].start.dateTime.substring(11, 16) + ") \\t";\n    } else if ( "date" in eventsListJson.items[i].start ) {\n      \/\/ "date": "2021-01-18"\n      eventsListTsv += eventsListJson.items[i].start.date;\n      eventsListTsv += "\\t(--:--) \\t";\n    }\n    \n    eventsListTsv += eventsListJson.items[i].summary;\n    eventsListTsv += "\\n";\n  }\n\n  return eventsListTsv.slice(0, -1);\n}\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n