0

Google Calendar Today and Upcoming events - Rolling data

Torrey Tayenaka

September 28, 2017 12:38

None

Follow

Hey Klipfolio experts,

I've been loading Google calendar events and wanted to understand how I can set "Today" date (in timeMin) from the GET call and for next 2 weeks time (in timeMax) and was just not able to do it.

Output :Pull events data for the following time duration. This is 2 weeks of rolling data that should be fully dynamic.

timeMin = Today (dynamic)  ; timeMax = 2 weeks from now (dynamic) 

The query for Today's events is as follows - gives all events for today.

https://www.googleapis.com/calendar/v3/calendars/trIDdg@group.calendar.google.com/events?timeMin={date.format("yyyy-MM-dd'T'00:00:00Z")}&timeMax={date.format("yyyy-MM-dd'T'23:59:59Z")}&singleEvents=true

Other types of queries: 

https://www.googleapis.com/calendar/v3/calendars/thesparkfk4c@group.calendar.google.com/events?timeMin={date.startOfMonth.format("yyyy-MM-dd'T'HH:mm:ss")}-04:00&timeMax={date.endOfMonth.format("yyyy-MM-dd'T'HH:mm:ss")}-04:00

-- startOfMonth and startOfWeek  queries total - but this does not give rolling data again as the week or month ends.

 

Let me know how I can go about setting dates to get 2 weeks rolling data of events from today here

 

• Facebook
• Twitter
• LinkedIn

6 comments

• 2
  
  Adam Doogan-Smith September 28, 2017 13:20

  Hi Torrey!

  To create a rolling date range, you can utilize Klipfolio's date parameters. In the case of going from today to 14 days in the future you can use date.add(14), where the number within the parenthesis is the amount of days shifted from today. For example, you query will look like this
  
  https://www.googleapis.com/calendar/v3/calendars/trIDdg@group.calendar.google.com/events?timeMin={date.format("yyyy-MM-dd'T'00:00:00Z")}&timeMax={date.add(14).format("yyyy-MM-dd'T'23:59:59Z")}&singleEvents=true

  Hopefully this helps you create a rolling two week window for you Calendar events.

  Happy Dashboarding!

  Adam

• 0
  
  Torrey Tayenaka September 30, 2017 06:19

   Thanks Adam - this worked perfectly! 

• 0
  
  Luke Hatakeda October 18, 2018 22:29

  Hey Adam,

   

  I am looking at a similar issue. I used your query but it looks like it is showing all events from today-14days from today. I want it to show just the events that occur 14 days from today. What would that query look like?

• 0
  
  Adam Doogan-Smith October 19, 2018 13:23

  Hi Luke,

  If you only want to show the event that occurred on the day that is two weeks in the future then your query will look like this:
  
  https://www.googleapis.com/calendar/v3/calendars/<e-mail_adress>/events?timeMin={date.add(14).format("yyyy-MM-dd'T'00:00:00Z")}&timeMax={date.add(14).format("yyyy-MM-dd'T'23:59:59Z")}&singleEvents=true

  -Adam

   

• 0
  
  Surge It February 21, 2019 14:43

  Hi Adam 

  I am struggling with  this as well the standard Klip only shows data for today where can i change it?or do i need to build a new one? 

  I am no very good with HTML or any coding for that matter.. Please help

• 0
  
  Janice Janczyn February 25, 2019 13:44

  Hello, 

  The standard klip uses a Google Calendar datasource that pulls only today's events. To show a different date range would require modifying the date range specified in the datasource query (see Adam's October 19, 2018 response in this thread) as well as the klip. If you aren't comfortable with HTML, it may be better to build a new klip. If this is your first klip, a good starting point is Getting Started with Klipfolio.

  Thank you,
                 Janice