2 Replies Latest reply on Apr 15, 2016 6:58 PM by tbcomputerguy

    Parsing google Calendar API event List

    Gingernut

      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

        }

        }

      ]

      }