Returns the color definitions for calendars and events.
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
{
"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"
}
}
}