(SQL Server) Outlook Calendar Create an Event

See more Outlook Calendar Examples

Create an event in the specified time zone, and assign the event an optional transactionId value.

For more information, see https://docs.microsoft.com/en-us/graph/api/user-post-events?view=graph-rest-1.0&tabs=http#example-1-create-an-event-in-the-specified-time-zone-and-assign-the-event-an-optional-transactionid-value

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Use your previously obtained access token here: Get Outlook Calendar OAuth2 Access Token (Azure AD v2.0 Endpoint).

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

    DECLARE @success int
    EXEC sp_OAMethod @jsonToken, 'LoadFile', @success OUT, 'qa_data/tokens/outlookCalendar.json'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @jsonToken, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @jsonToken
        RETURN
      END
    EXEC sp_OAMethod @jsonToken, 'StringOf', @sTmp0 OUT, 'access_token'
    EXEC sp_OASetProperty @http, 'AuthToken', @sTmp0

    -- Send the following POST:

    -- POST https://graph.microsoft.com/v1.0/me/events
    -- Prefer: outlook.timezone="Pacific Standard Time"
    -- Content-type: application/json
    -- 
    -- {
    --   "subject": "Let's go for lunch",
    --   "body": {
    --     "contentType": "HTML",
    --     "content": "Does noon work for you?"
    --   },
    --   "start": {
    --       "dateTime": "2017-04-15T12:00:00",
    --       "timeZone": "Pacific Standard Time"
    --   },
    --   "end": {
    --       "dateTime": "2017-04-15T14:00:00",
    --       "timeZone": "Pacific Standard Time"
    --   },
    --   "location":{
    --       "displayName":"Harry's Bar"
    --   },
    --   "attendees": [
    --     {
    --       "emailAddress": {
    --         "address":"samanthab@contoso.onmicrosoft.com",
    --         "name": "Samantha Booth"
    --       },
    --       "type": "required"
    --     }
    --   ],
    --   "allowNewTimeProposals": true,
    --   "transactionId":"7E163156-7762-4BEB-A1C6-729EA81755A7"
    -- }

    -- Build the JSON body of the POST.
    DECLARE @json int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT

    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'subject', 'Let''s go for lunch'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'body.contentType', 'HTML'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'body.content', 'Does noon work for you?'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'start.dateTime', '2021-05-15T12:00:00'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'start.timeZone', 'Pacific Standard Time'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'end.dateTime', '2021-05-15T14:00:00'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'end.timeZone', 'Pacific Standard Time'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'location.displayName', 'Harry''s Bar'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'attendees[0].emailAddress.address', 'samanthab@contoso.onmicrosoft.com'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'attendees[0].emailAddress.name', 'Samantha Booth'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'attendees[0].type', 'required'
    EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'allowNewTimeProposals', 1

    -- Generate a UUID.
    DECLARE @crypt int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Crypt2', @crypt OUT

    EXEC sp_OAMethod @crypt, 'GenerateUuid', @sTmp0 OUT
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transactionId', @sTmp0

    -- Add the "Prefer" request header.
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Prefer', 'outlook.timezone="Pacific Standard Time"'

    -- Send the HTTP POST
    DECLARE @resp int
    EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
    EXEC sp_OAMethod @http, 'PostJson2', @resp OUT, 'https://graph.microsoft.com/v1.0/me/events', 'application/json', @sTmp0
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @jsonToken
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @crypt
        RETURN
      END

    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    PRINT 'Response status code = ' + @iTmp0

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

    EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
    EXEC sp_OAMethod @jResp, 'Load', @success OUT, @sTmp0
    EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
    EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @resp

    -- The send succeeded if the response status code = 201.
    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    IF @iTmp0 <> 201
      BEGIN

        PRINT 'Failed'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @jsonToken
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @crypt
        EXEC @hr = sp_OADestroy @jResp
        RETURN
      END

    -- Sample JSON response:
    -- (Sample code for parsing the JSON response is shown below)

    -- {
    --   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('user%40example.com')/events/$entity",
    --   "@odata.etag": "W/\"5+vF7TKKdE6bGCRqXyl2PQAEaGQgcw==\"",
    --   "id": "AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5_vF7TKKdE6bGCRqXyl2PQAAAgENAAAA5_vF7TKKdE6bGCRqXyl2PQAEaDkEcAAAAA==",
    --   "createdDateTime": "2021-04-18T23:38:52.1979259Z",
    --   "lastModifiedDateTime": "2021-04-18T23:38:53.3747647Z",
    --   "changeKey": "5+vF7TKKdE6bGCRqXyl2PQAEaGQgcw==",
    --   "categories": [
    --   ],
    --   "transactionId": "1d12b565-3ca3-4ed8-b3f9-e8a14ac3ac17",
    --   "originalStartTimeZone": "Pacific Standard Time",
    --   "originalEndTimeZone": "Pacific Standard Time",
    --   "iCalUId": "040000008200E00074C5B7101A82E00800000000EF0328FDAB34D7010000000000000000100000004478DD5948382543AFD1B52C25E88C02",
    --   "reminderMinutesBeforeStart": 15,
    --   "isReminderOn": true,
    --   "hasAttachments": false,
    --   "subject": "Let's go for lunch",
    --   "bodyPreview": "Does noon work for you?",
    --   "importance": "normal",
    --   "sensitivity": "normal",
    --   "isAllDay": false,
    --   "isCancelled": false,
    --   "isOrganizer": true,
    --   "responseRequested": true,
    --   "seriesMasterId": null,
    --   "showAs": "busy",
    --   "type": "singleInstance",
    --   "webLink": "https://outlook.live.com/owa/?itemid=AQMkADAwATM0MDAAMS1iNTcwLWI2NTEtMDACLTAwCgBGAAADsVyfxjDU406Ic4X7ill8xAcA5%2BvF7TKKdE6bGCRqXyl2PQAAAgENAAAA5%2BvF7TKKdE6bGCRqXyl2PQAEaDkEcAAAAA%3D%3D&exvsurl=1&path=/calendar/item",
    --   "onlineMeetingUrl": null,
    --   "isOnlineMeeting": false,
    --   "onlineMeetingProvider": "unknown",
    --   "allowNewTimeProposals": true,
    --   "isDraft": false,
    --   "hideAttendees": false,
    --   "recurrence": null,
    --   "onlineMeeting": null,
    --   "responseStatus": {
    --     "response": "organizer",
    --     "time": "0001-01-01T00:00:00Z"
    --   },
    --   "body": {
    --     "contentType": "html",
    --     "content": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta content=\"text/html; charset=us-ascii\">\r\n</head>\r\n<body>\r\nDoes noon work for you?\r\n</body>\r\n</html>\r\n"
    --   },
    --   "start": {
    --     "dateTime": "2021-05-15T12:00:00.0000000",
    --     "timeZone": "Pacific Standard Time"
    --   },
    --   "end": {
    --     "dateTime": "2021-05-15T14:00:00.0000000",
    --     "timeZone": "Pacific Standard Time"
    --   },
    --   "location": {
    --     "displayName": "Harry's Bar",
    --     "locationType": "default",
    --     "uniqueId": "Harry's Bar",
    --     "uniqueIdType": "private"
    --   },
    --   "locations": [
    --     {
    --       "displayName": "Harry's Bar",
    --       "locationType": "default",
    --       "uniqueId": "Harry's Bar",
    --       "uniqueIdType": "private"
    --     }
    --   ],
    --   "attendees": [
    --     {
    --       "type": "required",
    --       "status": {
    --         "response": "none",
    --         "time": "0001-01-01T00:00:00Z"
    --       },
    --       "emailAddress": {
    --         "name": "Samantha Booth",
    --         "address": "samanthab@contoso.onmicrosoft.com"
    --       }
    --     }
    --   ],
    --   "organizer": {
    --     "emailAddress": {
    --       "name": "John Doe",
    --       "address": "outlook_3A33FCEB9B74CC15@outlook.com"
    --     }
    --   }
    -- }

    -- Sample code for parsing the JSON response...
    -- Use the following online tool to generate parsing code from sample JSON:
    -- Generate Parsing Code from JSON

    DECLARE @displayName nvarchar(4000)

    DECLARE @locationType nvarchar(4000)

    DECLARE @uniqueId nvarchar(4000)

    DECLARE @uniqueIdType nvarchar(4000)

    DECLARE @statusResponse nvarchar(4000)

    DECLARE @statusTime nvarchar(4000)

    DECLARE @emailAddressName nvarchar(4000)

    DECLARE @emailAddressAddress nvarchar(4000)

    DECLARE @odata_context nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @odata_context OUT, '"@odata.context"'
    DECLARE @odata_etag nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @odata_etag OUT, '"@odata.etag"'
    DECLARE @id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @id OUT, 'id'
    DECLARE @createdDateTime nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @createdDateTime OUT, 'createdDateTime'
    DECLARE @lastModifiedDateTime nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @lastModifiedDateTime OUT, 'lastModifiedDateTime'
    DECLARE @changeKey nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @changeKey OUT, 'changeKey'
    DECLARE @transactionId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @transactionId OUT, 'transactionId'
    DECLARE @originalStartTimeZone nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @originalStartTimeZone OUT, 'originalStartTimeZone'
    DECLARE @originalEndTimeZone nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @originalEndTimeZone OUT, 'originalEndTimeZone'
    DECLARE @iCalUId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @iCalUId OUT, 'iCalUId'
    DECLARE @reminderMinutesBeforeStart int
    EXEC sp_OAMethod @jResp, 'IntOf', @reminderMinutesBeforeStart OUT, 'reminderMinutesBeforeStart'
    DECLARE @isReminderOn int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isReminderOn OUT, 'isReminderOn'
    DECLARE @hasAttachments int
    EXEC sp_OAMethod @jResp, 'BoolOf', @hasAttachments OUT, 'hasAttachments'
    DECLARE @subject nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @subject OUT, 'subject'
    DECLARE @bodyPreview nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @bodyPreview OUT, 'bodyPreview'
    DECLARE @importance nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @importance OUT, 'importance'
    DECLARE @sensitivity nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @sensitivity OUT, 'sensitivity'
    DECLARE @isAllDay int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isAllDay OUT, 'isAllDay'
    DECLARE @isCancelled int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isCancelled OUT, 'isCancelled'
    DECLARE @isOrganizer int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isOrganizer OUT, 'isOrganizer'
    DECLARE @responseRequested int
    EXEC sp_OAMethod @jResp, 'BoolOf', @responseRequested OUT, 'responseRequested'
    DECLARE @seriesMasterId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @seriesMasterId OUT, 'seriesMasterId'
    DECLARE @showAs nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @showAs OUT, 'showAs'
    DECLARE @v_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'type'
    DECLARE @webLink nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @webLink OUT, 'webLink'
    DECLARE @onlineMeetingUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @onlineMeetingUrl OUT, 'onlineMeetingUrl'
    DECLARE @isOnlineMeeting int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isOnlineMeeting OUT, 'isOnlineMeeting'
    DECLARE @onlineMeetingProvider nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @onlineMeetingProvider OUT, 'onlineMeetingProvider'
    DECLARE @allowNewTimeProposals int
    EXEC sp_OAMethod @jResp, 'BoolOf', @allowNewTimeProposals OUT, 'allowNewTimeProposals'
    DECLARE @isDraft int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isDraft OUT, 'isDraft'
    DECLARE @hideAttendees int
    EXEC sp_OAMethod @jResp, 'BoolOf', @hideAttendees OUT, 'hideAttendees'
    DECLARE @recurrence nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @recurrence OUT, 'recurrence'
    DECLARE @onlineMeeting nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @onlineMeeting OUT, 'onlineMeeting'
    DECLARE @responseStatusResponse nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @responseStatusResponse OUT, 'responseStatus.response'
    DECLARE @responseStatusTime nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @responseStatusTime OUT, 'responseStatus.time'
    DECLARE @bodyContentType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @bodyContentType OUT, 'body.contentType'
    DECLARE @bodyContent nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @bodyContent OUT, 'body.content'
    DECLARE @startDateTime nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @startDateTime OUT, 'start.dateTime'
    DECLARE @startTimeZone nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @startTimeZone OUT, 'start.timeZone'
    DECLARE @endDateTime nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @endDateTime OUT, 'end.dateTime'
    DECLARE @endTimeZone nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @endTimeZone OUT, 'end.timeZone'
    DECLARE @locationDisplayName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @locationDisplayName OUT, 'location.displayName'
    DECLARE @locationLocationType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @locationLocationType OUT, 'location.locationType'
    DECLARE @locationUniqueId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @locationUniqueId OUT, 'location.uniqueId'
    DECLARE @locationUniqueIdType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @locationUniqueIdType OUT, 'location.uniqueIdType'
    DECLARE @organizerEmailAddressName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @organizerEmailAddressName OUT, 'organizer.emailAddress.name'
    DECLARE @organizerEmailAddressAddress nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @organizerEmailAddressAddress OUT, 'organizer.emailAddress.address'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'categories'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        SELECT @i = @i + 1
      END
    SELECT @i = 0
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'locations'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'StringOf', @displayName OUT, 'locations[i].displayName'
        EXEC sp_OAMethod @jResp, 'StringOf', @locationType OUT, 'locations[i].locationType'
        EXEC sp_OAMethod @jResp, 'StringOf', @uniqueId OUT, 'locations[i].uniqueId'
        EXEC sp_OAMethod @jResp, 'StringOf', @uniqueIdType OUT, 'locations[i].uniqueIdType'
        SELECT @i = @i + 1
      END
    SELECT @i = 0
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'attendees'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'attendees[i].type'
        EXEC sp_OAMethod @jResp, 'StringOf', @statusResponse OUT, 'attendees[i].status.response'
        EXEC sp_OAMethod @jResp, 'StringOf', @statusTime OUT, 'attendees[i].status.time'
        EXEC sp_OAMethod @jResp, 'StringOf', @emailAddressName OUT, 'attendees[i].emailAddress.name'
        EXEC sp_OAMethod @jResp, 'StringOf', @emailAddressAddress OUT, 'attendees[i].emailAddress.address'
        SELECT @i = @i + 1
      END


    PRINT 'Event created.'

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @jsonToken
    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @crypt
    EXEC @hr = sp_OADestroy @jResp


END
GO