SQL Server Google Calendar: Get Color Definitions

Back to Index

Returns the color definitions for calendars and events.

Documentation: https://developers.google.com/google-apps/calendar/v3/reference/colors/get


CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @rest int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Rest', @rest OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    --   Provide a previously obtained OAuth2 access token.
    DECLARE @oauth2 int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.OAuth2', @oauth2 OUT

    EXEC sp_OASetProperty @oauth2, 'AccessToken', 'OAUTH2_ACCESS_TOKEN'
    EXEC sp_OAMethod @rest, 'SetAuthOAuth2', @success OUT, STR(@oauth2)

    EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'www.googleapis.com', 443, 1, 1
    IF STR(@success) <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @oauth2
        RETURN
      END

    DECLARE @sbJson int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbJson OUT

    EXEC sp_OAMethod @rest, 'FullRequestNoBodySb', @success OUT, 'GET', '/calendar/v3/colors', STR(@sbJson)
    IF STR(@success) <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @oauth2
        EXEC @hr = sp_OADestroy @sbJson
        RETURN
      END

    EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
    IF @iTmp0 <> 200
      BEGIN

        EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
        PRINT 'Received error response code: ' + @iTmp0

        PRINT 'Response body:'
        EXEC sp_OAMethod @sbJson, 'GetAsString', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @oauth2
        EXEC @hr = sp_OADestroy @sbJson
        RETURN
      END

    DECLARE @json int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT

    EXEC sp_OAMethod @json, 'LoadSb', @success OUT, STR(@sbJson)

    --  The following code parses the JSON response.
    --  A sample JSON response is shown below the sample code.
    DECLARE @kind nvarchar(4000)

    DECLARE @updated nvarchar(4000)

    DECLARE @calendar1Background nvarchar(4000)

    DECLARE @calendar1Foreground nvarchar(4000)

    DECLARE @calendar2Background nvarchar(4000)

    DECLARE @calendar2Foreground nvarchar(4000)

    DECLARE @calendar3Background nvarchar(4000)

    DECLARE @calendar3Foreground nvarchar(4000)

    DECLARE @calendar4Background nvarchar(4000)

    DECLARE @calendar4Foreground nvarchar(4000)

    DECLARE @calendar5Background nvarchar(4000)

    DECLARE @calendar5Foreground nvarchar(4000)

    DECLARE @calendar6Background nvarchar(4000)

    DECLARE @calendar6Foreground nvarchar(4000)

    DECLARE @calendar7Background nvarchar(4000)

    DECLARE @calendar7Foreground nvarchar(4000)

    DECLARE @calendar8Background nvarchar(4000)

    DECLARE @calendar8Foreground nvarchar(4000)

    DECLARE @calendar9Background nvarchar(4000)

    DECLARE @calendar9Foreground nvarchar(4000)

    DECLARE @calendar10Background nvarchar(4000)

    DECLARE @calendar10Foreground nvarchar(4000)

    DECLARE @calendar11Background nvarchar(4000)

    DECLARE @calendar11Foreground nvarchar(4000)

    DECLARE @calendar12Background nvarchar(4000)

    DECLARE @calendar12Foreground nvarchar(4000)

    DECLARE @calendar13Background nvarchar(4000)

    DECLARE @calendar13Foreground nvarchar(4000)

    DECLARE @calendar14Background nvarchar(4000)

    DECLARE @calendar14Foreground nvarchar(4000)

    DECLARE @calendar15Background nvarchar(4000)

    DECLARE @calendar15Foreground nvarchar(4000)

    DECLARE @calendar16Background nvarchar(4000)

    DECLARE @calendar16Foreground nvarchar(4000)

    DECLARE @calendar17Background nvarchar(4000)

    DECLARE @calendar17Foreground nvarchar(4000)

    DECLARE @calendar18Background nvarchar(4000)

    DECLARE @calendar18Foreground nvarchar(4000)

    DECLARE @calendar19Background nvarchar(4000)

    DECLARE @calendar19Foreground nvarchar(4000)

    DECLARE @calendar20Background nvarchar(4000)

    DECLARE @calendar20Foreground nvarchar(4000)

    DECLARE @calendar21Background nvarchar(4000)

    DECLARE @calendar21Foreground nvarchar(4000)

    DECLARE @calendar22Background nvarchar(4000)

    DECLARE @calendar22Foreground nvarchar(4000)

    DECLARE @calendar23Background nvarchar(4000)

    DECLARE @calendar23Foreground nvarchar(4000)

    DECLARE @calendar24Background nvarchar(4000)

    DECLARE @calendar24Foreground nvarchar(4000)

    DECLARE @event1Background nvarchar(4000)

    DECLARE @event1Foreground nvarchar(4000)

    DECLARE @event2Background nvarchar(4000)

    DECLARE @event2Foreground nvarchar(4000)

    DECLARE @event3Background nvarchar(4000)

    DECLARE @event3Foreground nvarchar(4000)

    DECLARE @event4Background nvarchar(4000)

    DECLARE @event4Foreground nvarchar(4000)

    DECLARE @event5Background nvarchar(4000)

    DECLARE @event5Foreground nvarchar(4000)

    DECLARE @event6Background nvarchar(4000)

    DECLARE @event6Foreground nvarchar(4000)

    DECLARE @event7Background nvarchar(4000)

    DECLARE @event7Foreground nvarchar(4000)

    DECLARE @event8Background nvarchar(4000)

    DECLARE @event8Foreground nvarchar(4000)

    DECLARE @event9Background nvarchar(4000)

    DECLARE @event9Foreground nvarchar(4000)

    DECLARE @event10Background nvarchar(4000)

    DECLARE @event10Foreground nvarchar(4000)

    DECLARE @event11Background nvarchar(4000)

    DECLARE @event11Foreground nvarchar(4000)

    EXEC sp_OAMethod @json, 'StringOf', @kind OUT, 'kind'
    EXEC sp_OAMethod @json, 'StringOf', @updated OUT, 'updated'
    EXEC sp_OAMethod @json, 'StringOf', @calendar1Background OUT, 'calendar.1.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar1Foreground OUT, 'calendar.1.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar2Background OUT, 'calendar.2.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar2Foreground OUT, 'calendar.2.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar3Background OUT, 'calendar.3.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar3Foreground OUT, 'calendar.3.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar4Background OUT, 'calendar.4.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar4Foreground OUT, 'calendar.4.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar5Background OUT, 'calendar.5.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar5Foreground OUT, 'calendar.5.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar6Background OUT, 'calendar.6.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar6Foreground OUT, 'calendar.6.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar7Background OUT, 'calendar.7.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar7Foreground OUT, 'calendar.7.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar8Background OUT, 'calendar.8.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar8Foreground OUT, 'calendar.8.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar9Background OUT, 'calendar.9.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar9Foreground OUT, 'calendar.9.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar10Background OUT, 'calendar.10.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar10Foreground OUT, 'calendar.10.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar11Background OUT, 'calendar.11.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar11Foreground OUT, 'calendar.11.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar12Background OUT, 'calendar.12.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar12Foreground OUT, 'calendar.12.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar13Background OUT, 'calendar.13.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar13Foreground OUT, 'calendar.13.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar14Background OUT, 'calendar.14.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar14Foreground OUT, 'calendar.14.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar15Background OUT, 'calendar.15.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar15Foreground OUT, 'calendar.15.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar16Background OUT, 'calendar.16.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar16Foreground OUT, 'calendar.16.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar17Background OUT, 'calendar.17.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar17Foreground OUT, 'calendar.17.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar18Background OUT, 'calendar.18.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar18Foreground OUT, 'calendar.18.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar19Background OUT, 'calendar.19.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar19Foreground OUT, 'calendar.19.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar20Background OUT, 'calendar.20.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar20Foreground OUT, 'calendar.20.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar21Background OUT, 'calendar.21.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar21Foreground OUT, 'calendar.21.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar22Background OUT, 'calendar.22.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar22Foreground OUT, 'calendar.22.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar23Background OUT, 'calendar.23.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar23Foreground OUT, 'calendar.23.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @calendar24Background OUT, 'calendar.24.background'
    EXEC sp_OAMethod @json, 'StringOf', @calendar24Foreground OUT, 'calendar.24.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event1Background OUT, 'event.1.background'
    EXEC sp_OAMethod @json, 'StringOf', @event1Foreground OUT, 'event.1.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event2Background OUT, 'event.2.background'
    EXEC sp_OAMethod @json, 'StringOf', @event2Foreground OUT, 'event.2.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event3Background OUT, 'event.3.background'
    EXEC sp_OAMethod @json, 'StringOf', @event3Foreground OUT, 'event.3.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event4Background OUT, 'event.4.background'
    EXEC sp_OAMethod @json, 'StringOf', @event4Foreground OUT, 'event.4.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event5Background OUT, 'event.5.background'
    EXEC sp_OAMethod @json, 'StringOf', @event5Foreground OUT, 'event.5.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event6Background OUT, 'event.6.background'
    EXEC sp_OAMethod @json, 'StringOf', @event6Foreground OUT, 'event.6.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event7Background OUT, 'event.7.background'
    EXEC sp_OAMethod @json, 'StringOf', @event7Foreground OUT, 'event.7.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event8Background OUT, 'event.8.background'
    EXEC sp_OAMethod @json, 'StringOf', @event8Foreground OUT, 'event.8.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event9Background OUT, 'event.9.background'
    EXEC sp_OAMethod @json, 'StringOf', @event9Foreground OUT, 'event.9.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event10Background OUT, 'event.10.background'
    EXEC sp_OAMethod @json, 'StringOf', @event10Foreground OUT, 'event.10.foreground'
    EXEC sp_OAMethod @json, 'StringOf', @event11Background OUT, 'event.11.background'
    EXEC sp_OAMethod @json, 'StringOf', @event11Foreground OUT, 'event.11.foreground'


    PRINT 'Example Completed.'

    EXEC @hr = sp_OADestroy @rest
    EXEC @hr = sp_OADestroy @oauth2
    EXEC @hr = sp_OADestroy @sbJson
    EXEC @hr = sp_OADestroy @json


END
GO

Sample JSON Response Body

{
  "kind": "calendar#colors",
  "updated": "2012-02-14T00:00:00.000Z",
  "calendar": {
    "1": {
      "background": "#ac725e",
      "foreground": "#1d1d1d"
    },
    "2": {
      "background": "#d06b64",
      "foreground": "#1d1d1d"
    },
    "3": {
      "background": "#f83a22",
      "foreground": "#1d1d1d"
    },
    "4": {
      "background": "#fa573c",
      "foreground": "#1d1d1d"
    },
    "5": {
      "background": "#ff7537",
      "foreground": "#1d1d1d"
    },
    "6": {
      "background": "#ffad46",
      "foreground": "#1d1d1d"
    },
    "7": {
      "background": "#42d692",
      "foreground": "#1d1d1d"
    },
    "8": {
      "background": "#16a765",
      "foreground": "#1d1d1d"
    },
    "9": {
      "background": "#7bd148",
      "foreground": "#1d1d1d"
    },
    "10": {
      "background": "#b3dc6c",
      "foreground": "#1d1d1d"
    },
    "11": {
      "background": "#fbe983",
      "foreground": "#1d1d1d"
    },
    "12": {
      "background": "#fad165",
      "foreground": "#1d1d1d"
    },
    "13": {
      "background": "#92e1c0",
      "foreground": "#1d1d1d"
    },
    "14": {
      "background": "#9fe1e7",
      "foreground": "#1d1d1d"
    },
    "15": {
      "background": "#9fc6e7",
      "foreground": "#1d1d1d"
    },
    "16": {
      "background": "#4986e7",
      "foreground": "#1d1d1d"
    },
    "17": {
      "background": "#9a9cff",
      "foreground": "#1d1d1d"
    },
    "18": {
      "background": "#b99aff",
      "foreground": "#1d1d1d"
    },
    "19": {
      "background": "#c2c2c2",
      "foreground": "#1d1d1d"
    },
    "20": {
      "background": "#cabdbf",
      "foreground": "#1d1d1d"
    },
    "21": {
      "background": "#cca6ac",
      "foreground": "#1d1d1d"
    },
    "22": {
      "background": "#f691b2",
      "foreground": "#1d1d1d"
    },
    "23": {
      "background": "#cd74e6",
      "foreground": "#1d1d1d"
    },
    "24": {
      "background": "#a47ae2",
      "foreground": "#1d1d1d"
    }
  },
  "event": {
    "1": {
      "background": "#a4bdfc",
      "foreground": "#1d1d1d"
    },
    "2": {
      "background": "#7ae7bf",
      "foreground": "#1d1d1d"
    },
    "3": {
      "background": "#dbadff",
      "foreground": "#1d1d1d"
    },
    "4": {
      "background": "#ff887c",
      "foreground": "#1d1d1d"
    },
    "5": {
      "background": "#fbd75b",
      "foreground": "#1d1d1d"
    },
    "6": {
      "background": "#ffb878",
      "foreground": "#1d1d1d"
    },
    "7": {
      "background": "#46d6db",
      "foreground": "#1d1d1d"
    },
    "8": {
      "background": "#e1e1e1",
      "foreground": "#1d1d1d"
    },
    "9": {
      "background": "#5484ed",
      "foreground": "#1d1d1d"
    },
    "10": {
      "background": "#51b749",
      "foreground": "#1d1d1d"
    },
    "11": {
      "background": "#dc2127",
      "foreground": "#1d1d1d"
    }
  }
}