AnsweredAssumed Answered

Parsing google Calendar API event List

Question asked by Gingernut on Dec 9, 2015
Latest reply on Apr 15, 2016 by tbcomputerguy

I have managed to get this event list from Google API get events into a field and I now want to parse them into either a virtual table or list so I can perform scripts on the results - ie compare to events in Filemaker Events Table .

 

I am struggling to know what functions to use to extract only the events and then the Times description status etc -- Can anyone please help me. I am pretty sure it is going to involve a looping script and some Position or custom functions and I have got so far only for my brain to feel like it is going to explode

 

{

"kind": "calendar#events",

"etag": "\"1449664348669000\"",

"summary": "Work test calendar",

"updated": "2015-12-09T12:32:28.669Z",

"timeZone": "UTC",

"accessRole": "owner",

"defaultReminders": [],

"nextSyncToken": "CMiIr8TkzskCEMiIr8TkzskCGAU=",

"items": [

  {

  "kind": "calendar#event",

  "etag": "\"2899328274228000\"",

  "id": "n9ibfsola3uqltt13abmji77ng",

  "status": "cancelled"

  },

  {

  "kind": "calendar#event",

  "etag": "\"2899328276152000\"",

  "id": "mrvkh2j2v10ojv2fetot0a1it4",

  "status": "cancelled"

  },

  {

  "kind": "calendar#event",

  "etag": "\"2899328277648000\"",

  "id": "ike3pt75ovrif73b0sgcgfat7o",

  "status": "cancelled"

  },

  {

  "kind": "calendar#event",

  "etag": "\"2899328283818000\"",

  "id": "ho25l1o04mrsgudorlhlidu9r0",

  "status": "confirmed",

  "htmlLink": "https://calendar.google.com/calendar/event?eid=aG8yNWwxbzA0bXJzZ3Vkb3JsaGxpZHU5cjAgZDZ2a2FvMTltaDY3bzIwMXVmNmpxbGhlczBAZw",

  "created": "2015-12-09T12:03:24.000Z",

  "updated": "2015-12-09T12:29:01.909Z",

  "summary": "KD6_fzZzskCEKD6_fzZzskCGAU",

  "creator": {

  "email": "zootonon@gmail.com",

  "displayName": "Cathy Evans"

  },

  "organizer": {

  "email": "d6vkao19mh67o201uf6jqlhes0@group.calendar.google.com",

  "displayName": "Work test calendar",

  "self": true

  },

  "start": {

  "dateTime": "2015-12-11T14:00:00Z"

  },

  "end": {

  "dateTime": "2015-12-11T15:00:00Z"

  },

  "iCalUID": "ho25l1o04mrsgudorlhlidu9r0@google.com",

  "sequence": 0,

  "reminders": {

  "useDefault": true

  }

  }

]

}

Outcomes