(SQL Server) OneDrive -- List Root Directory

See more OneDrive Examples

This gets the collection of DriveItem children of the root DriveItem. In OneDrive, a driveItem resource represents a file, folder, or other item stored in a drive. All file system objects in OneDriveare returned as driveItem resources (which are JSON objects).

This example returns the collection of child DriveItems for the root DriveItem.

Note: This example requires Chilkat v9.5.0.97 or greater.

For more information, see https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_list_children?view=odsp-graph-online

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
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- This example uses the OAuth client credentials flow.
    -- See How to Create an Azure App Registration for OAuth 2.0 Client Credentials

    -- Use your client ID, client secret, and tenant ID in the following lines
    DECLARE @json int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'client_id', '2871da2c-8176-4b7f-869b-2311aa82e743'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'client_secret', '2hu9Q~r5QuryUcEkNbg1btLtnfU1VUXzhSCG6brH'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'scope', 'https://graph.microsoft.com/.default'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'token_endpoint', 'https://login.microsoftonline.com/114d7ed6-71bf-4dbe-a866-748364121bf2/oauth2/v2.0/token'

    DECLARE @http int
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT

    EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
    EXEC sp_OASetProperty @http, 'AuthToken', @sTmp0

    -- Sends the following GET request:
    -- GET https://graph.microsoft.com/v1.0/users/{user-id}/drive/items/{item-id}/children

    -- Use your specific Id instead of what we're using here:
    EXEC sp_OAMethod @http, 'SetUrlVar', @success OUT, 'userId', '4fe732c3-322e-4a6b-b729-2fd1eb5c6104'
    EXEC sp_OAMethod @http, 'SetUrlVar', @success OUT, 'itemId', 'root'

    DECLARE @resp nvarchar(4000)
    EXEC sp_OAMethod @http, 'QuickGetStr', @resp OUT, 'https://graph.microsoft.com/v1.0/users/{$userId}/drive/items/{$itemId}/children'
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @http
        RETURN
      END

    -- The response should be JSON.
    EXEC sp_OASetProperty @json, 'EmitCompact', 0
    EXEC sp_OAMethod @json, 'Load', @success OUT, @resp

    -- A successful response should return a status code of 200.
    EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT
    IF @iTmp0 <> 200
      BEGIN
        EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
        PRINT @sTmp0

        EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT
        PRINT 'Response status = ' + @iTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @http
        RETURN
      END

    EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    -- See the sample JSON response and output below..

    DECLARE @lastMod int
    -- Use "Chilkat_9_5_0.CkDateTime" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.CkDateTime', @lastMod OUT

    DECLARE @photoTaken int
    -- Use "Chilkat_9_5_0.CkDateTime" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.CkDateTime', @photoTaken OUT

    -- Iterate over the DriveItems in the JSON response:
    -- (I tested this example with a root that contains a several folders,
    -- a JPG image file, an XML file, and a WAV audio file.)
    DECLARE @i int
    SELECT @i = 0
    DECLARE @numItems int
    EXEC sp_OAMethod @json, 'SizeOfArray', @numItems OUT, 'value'
    WHILE @i < @numItems
      BEGIN
        EXEC sp_OASetProperty @json, 'I', @i

        PRINT '-- DriveItem ' + @i + 1

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'value[i].id'
        PRINT 'id: ' + @sTmp0

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'value[i].name'
        PRINT 'name: ' + @sTmp0

        EXEC sp_OAMethod @json, 'IntOf', @iTmp0 OUT, 'value[i].size'
        PRINT 'size: ' + @iTmp0

        -- Get the lastModifiedDateTime
        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'value[i].fileSystemInfo.lastModifiedDateTime'
        EXEC sp_OAMethod @lastMod, 'SetFromTimestamp', @success OUT, @sTmp0

        -- Is this a folder?
        EXEC sp_OAMethod @json, 'HasMember', @iTmp0 OUT, 'value[i].folder'
        IF @iTmp0 = 1
          BEGIN

            EXEC sp_OAMethod @json, 'IntOf', @iTmp0 OUT, 'value[i].folder.childCount'

            PRINT 'This is a folder with ' + @iTmp0 + ' children'
          END
        EXEC sp_OAMethod @json, 'HasMember', @iTmp0 OUT, 'value[i].file'
        IF @iTmp0 = 1
          BEGIN

            PRINT 'This is a file.'

            EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'value[i].file.hashes.sha1Hash'
            PRINT 'SHA1 hash: ' + @sTmp0

            EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'value[i].mimeType'
            PRINT 'mimeType: ' + @sTmp0
          END
        EXEC sp_OAMethod @json, 'HasMember', @iTmp0 OUT, 'value[i].image'
        IF @iTmp0 = 1
          BEGIN

            PRINT 'This is an image.'

            EXEC sp_OAMethod @json, 'IntOf', @iTmp0 OUT, 'value[i].image.height'
            PRINT 'height: ' + @iTmp0

            EXEC sp_OAMethod @json, 'IntOf', @iTmp0 OUT, 'value[i].image.width'
            PRINT 'width: ' + @iTmp0
          END
        EXEC sp_OAMethod @json, 'HasMember', @iTmp0 OUT, 'value[i].photo'
        IF @iTmp0 = 1
          BEGIN

            PRINT 'This is a photo.'
            EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'value[i].photo.takenDateTime'
            EXEC sp_OAMethod @photoTaken, 'SetFromTimestamp', @success OUT, @sTmp0

            EXEC sp_OAMethod @photoTaken, 'GetAsRfc822', @sTmp0 OUT, 1
            PRINT 'photo taken on ' + @sTmp0
          END
        EXEC sp_OAMethod @json, 'HasMember', @iTmp0 OUT, 'value[i].audio'
        IF @iTmp0 = 1
          BEGIN

            PRINT 'This is an audio file.'

            EXEC sp_OAMethod @json, 'IntOf', @iTmp0 OUT, 'value[i].audio.duration'
            PRINT 'duration: ' + @iTmp0
          END

        SELECT @i = @i + 1
      END

    -- The output for the above loop:

    -- -- DriveItem 1
    -- id: 3A33FCEB9B74CC15!187
    -- name: Documents
    -- size: 4452847
    -- This is a folder with 8 children
    -- -- DriveItem 2
    -- id: 3A33FCEB9B74CC15!4114
    -- name: Downloads
    -- size: 18240001
    -- This is a folder with 6 children
    -- -- DriveItem 3
    -- id: 3A33FCEB9B74CC15!4407
    -- name: lots-of-files
    -- size: 7542
    -- This is a folder with 450 children
    -- -- DriveItem 4
    -- id: 3A33FCEB9B74CC15!4858
    -- name: Misc
    -- size: 819922938
    -- This is a folder with 6 children
    -- -- DriveItem 5
    -- id: 3A33FCEB9B74CC15!185
    -- name: Pictures
    -- size: 0
    -- This is a folder with 3 children
    -- -- DriveItem 6
    -- id: 3A33FCEB9B74CC15!186
    -- name: Public
    -- size: 0
    -- This is a folder with 0 children
    -- -- DriveItem 7
    -- id: 3A33FCEB9B74CC15!4860
    -- name: hamlet.xml
    -- size: 279658
    -- This is a file.
    -- SHA1 hash: C6AD0095E07141C97A3C6B85778602AD883F5500
    -- mimeType: 
    -- -- DriveItem 8
    -- id: 3A33FCEB9B74CC15!4861
    -- name: msg_123_abc.wav
    -- size: 155564
    -- This is a file.
    -- SHA1 hash: 1F51ADBDAADEAABC2D588C2A795AE86758525984
    -- mimeType: 
    -- This is an audio file.
    -- duration: 9720
    -- -- DriveItem 9
    -- id: 3A33FCEB9B74CC15!4859
    -- name: penguins.jpg
    -- size: 777835
    -- This is a file.
    -- SHA1 hash: DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0
    -- mimeType: 
    -- This is an image.
    -- height: 768
    -- width: 1024
    -- This is a photo.
    -- photo taken on Sun, 17 Feb 2008 23:07:31 -0600
    -- 

    -- -------------------------------------------------------
    -- This is the JSON response when this example was tested:

    -- {
    --   "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('me')/drive/root/children",
    --   "value": [
    --     {
    --       "createdBy": {
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         }
    --       },
    --       "createdDateTime": "2013-06-12T19:49:08.367Z",
    --       "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITE4Ny42MzYyODA2Nzc4MjI3MzAwMDA",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSExODcuMA",
    --       "id": "3A33FCEB9B74CC15!187",
    --       "lastModifiedBy": {
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-04-17T23:16:22.273Z",
    --       "name": "Documents",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 4452847,
    --       "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6gTs",
    --       "fileSystemInfo": {
    --         "createdDateTime": "2013-06-12T19:49:08.366Z",
    --         "lastModifiedDateTime": "2013-06-12T19:49:08.367Z"
    --       },
    --       "folder": {
    --         "childCount": 8
    --       },
    --       "specialFolder": {
    --         "name": "documents"
    --       }
    --     },
    --     {
    --       "createdBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "createdDateTime": "2016-12-07T14:02:22.417Z",
    --       "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITQxMTQuNjM2MjQzMzEyODEwMjAwMDAw",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0MTE0LjE",
    --       "id": "3A33FCEB9B74CC15!4114",
    --       "lastModifiedBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-03-05T17:21:21.02Z",
    --       "name": "Downloads",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 18240001,
    --       "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6oBI",
    --       "fileSystemInfo": {
    --         "createdDateTime": "2016-12-07T14:02:09Z",
    --         "lastModifiedDateTime": "2016-12-07T14:02:09Z"
    --       },
    --       "folder": {
    --         "childCount": 6
    --       }
    --     },
    --     {
    --       "createdBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "createdDateTime": "2017-06-02T02:14:59.797Z",
    --       "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITQ0MDcuNjM2MzE5NjY2MDIzNDcwMDAw",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0NDA3LjA",
    --       "id": "3A33FCEB9B74CC15!4407",
    --       "lastModifiedBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-06-02T02:16:42.347Z",
    --       "name": "lots-of-files",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 7542,
    --       "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6ojc",
    --       "fileSystemInfo": {
    --         "createdDateTime": "2017-06-02T02:13:11Z",
    --         "lastModifiedDateTime": "2017-06-02T02:14:54Z"
    --       },
    --       "folder": {
    --         "childCount": 450
    --       }
    --     },
    --     {
    --       "createdBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "createdDateTime": "2017-06-02T19:06:10.293Z",
    --       "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITQ4NTguNjM2MzIwMjcxOTAxNDcwMDAw",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODU4LjA",
    --       "id": "3A33FCEB9B74CC15!4858",
    --       "lastModifiedBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-06-02T19:06:30.147Z",
    --       "name": "Misc",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 819922938,
    --       "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6pXo",
    --       "fileSystemInfo": {
    --         "createdDateTime": "2017-06-02T19:06:02Z",
    --         "lastModifiedDateTime": "2017-06-02T19:06:02Z"
    --       },
    --       "folder": {
    --         "childCount": 6
    --       }
    --     },
    --     {
    --       "createdBy": {
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         }
    --       },
    --       "createdDateTime": "2013-06-12T19:49:08.123Z",
    --       "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITE4NS42MzYxNDU5MzkxMDcyMDAwMDA",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSExODUuMA",
    --       "id": "3A33FCEB9B74CC15!185",
    --       "lastModifiedBy": {
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         }
    --       },
    --       "lastModifiedDateTime": "2016-11-13T00:31:50.72Z",
    --       "name": "Pictures",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 0,
    --       "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6gTk",
    --       "fileSystemInfo": {
    --         "createdDateTime": "2013-06-12T19:49:08.123Z",
    --         "lastModifiedDateTime": "2013-06-12T19:49:08.123Z"
    --       },
    --       "folder": {
    --         "childCount": 3
    --       },
    --       "specialFolder": {
    --         "name": "photos"
    --       }
    --     },
    --     {
    --       "createdBy": {
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         }
    --       },
    --       "createdDateTime": "2013-06-12T19:49:08.183Z",
    --       "cTag": "adDozQTMzRkNFQjlCNzRDQzE1ITE4Ni42MzUwNjY2MzM0ODMwMzAwMDA",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSExODYuMQ",
    --       "id": "3A33FCEB9B74CC15!186",
    --       "lastModifiedBy": {
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         }
    --       },
    --       "lastModifiedDateTime": "2013-06-12T19:49:08.303Z",
    --       "name": "Public",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 0,
    --       "webUrl": "https://1drv.ms/f/s!ABXMdJvr_DM6gTo",
    --       "fileSystemInfo": {
    --         "createdDateTime": "2013-06-12T19:49:08.183Z",
    --         "lastModifiedDateTime": "2013-06-12T19:49:08.183Z"
    --       },
    --       "folder": {
    --         "childCount": 0
    --       },
    --       "shared": {
    --         "owner": {
    --           "user": {
    --             "displayName": "Matt Smith",
    --             "id": "3a33fceb9b74cc15"
    --           }
    --         },
    --         "scope": "anonymous"
    --       },
    --       "specialFolder": {
    --         "name": "public"
    --       }
    --     },
    --     {
    --       "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4m8Y4r_Ewfy3hIxqpU-_dxvY455X2gAZd3LJXE908zgA1ErQUm5wZpiyz6Rs0YfFb_c5SKgOFZV6HU1YpEmd0MvWbQ-dJVy2lLfRqTUnHEY8znUIQrljmTk1GR2auv4rTitRzWEZztQV0iId2-_FdQj2aZK5sdpmkdbgNuishP0NalJBsLdiBeKBVsy7A_zFTUXbw28ZzJctfyqITNUtBPxmDRzF39UWRjTo74CksCHc4",
    --       "createdBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "createdDateTime": "2017-06-02T19:08:34.14Z",
    --       "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NjAuMjU3",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODYwLjA",
    --       "id": "3A33FCEB9B74CC15!4860",
    --       "lastModifiedBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-06-02T19:08:34.14Z",
    --       "name": "hamlet.xml",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 279658,
    --       "webUrl": "https://1drv.ms/u/s!ABXMdJvr_DM6pXw",
    --       "file": {
    --         "hashes": {
    --           "sha1Hash": "C6AD0095E07141C97A3C6B85778602AD883F5500"
    --         },
    --         "mimeType": "application/xml"
    --       },
    --       "fileSystemInfo": {
    --         "createdDateTime": "2017-06-02T19:08:30Z",
    --         "lastModifiedDateTime": "2016-03-03T23:10:30Z"
    --       }
    --     },
    --     {
    --       "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4mZ4m1N8Vzd40ZtPERT8qEo4nOxt786w5uHDuX4VkessshXBY9z9wyG3rb0GYAAaCYWd64tLCmFcObsobWoLZXkGwgAdBE5ebvHTxmS3W6Z7U0ZzBHviaIa2RufoGhOtAWCImPxRKxID3wPvqPW5jCG31tCXhtrJMuGHnW2TkWg3FxJEvezSkI2PBTGpMzvGVjjX-qsHSnP5OMFyx0ikwVMaGU7_KvGcDUZtj9clz8rXQ",
    --       "createdBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "createdDateTime": "2017-06-02T19:08:53.167Z",
    --       "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NjEuMjU3",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODYxLjA",
    --       "id": "3A33FCEB9B74CC15!4861",
    --       "lastModifiedBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-06-02T19:08:53.167Z",
    --       "name": "msg_123_abc.wav",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 155564,
    --       "webUrl": "https://1drv.ms/u/s!ABXMdJvr_DM6pX0",
    --       "audio": {
    --         "bitrate": 128,
    --         "duration": 9720,
    --         "hasDrm": false
    --       },
    --       "file": {
    --         "hashes": {
    --           "sha1Hash": "1F51ADBDAADEAABC2D588C2A795AE86758525984"
    --         },
    --         "mimeType": "audio/wav"
    --       },
    --       "fileSystemInfo": {
    --         "createdDateTime": "2017-06-02T19:08:49Z",
    --         "lastModifiedDateTime": "2017-04-18T14:27:12Z"
    --       }
    --     },
    --     {
    --       "@microsoft.graph.downloadUrl": "https://public.dm2301.livefilestore.com/y4m5U-QanvmGcb5NeRyPaf2dy32EyX2yf_uNvPgnioU2JGrvB25yZq4uKEiQGMex99sWQ2LXcjAQbQx41C-SpqRrccIKsTvnIbbyaB45gaBSLsTeryE75p70-l4FOXb8HJWfPZmMl30BhCqpMge2ZLVo8h3uUlL7WIijap5wHdVlb0g_nm47EMDFh3USIL43kY5u4NPpoaxNEoMGYtYZ2ojzDwu-kBgKgD0S3wxCvmlD8o",
    --       "createdBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "createdDateTime": "2017-06-02T19:07:06.813Z",
    --       "cTag": "aYzozQTMzRkNFQjlCNzRDQzE1ITQ4NTkuMjU3",
    --       "eTag": "aM0EzM0ZDRUI5Qjc0Q0MxNSE0ODU5LjI",
    --       "id": "3A33FCEB9B74CC15!4859",
    --       "lastModifiedBy": {
    --         "device": {
    --           "id": "187ffebfaf8fa5"
    --         },
    --         "user": {
    --           "displayName": "Matt Smith",
    --           "id": "3a33fceb9b74cc15"
    --         },
    --         "oneDriveSync": {
    --           "@odata.type": "#microsoft.graph.identity",
    --           "id": "388149ab-8073-45aa-a68c-aac791ec9c1d"
    --         }
    --       },
    --       "lastModifiedDateTime": "2017-06-02T19:07:09.203Z",
    --       "name": "penguins.jpg",
    --       "parentReference": {
    --         "driveId": "3a33fceb9b74cc15",
    --         "id": "3A33FCEB9B74CC15!184",
    --         "path": "/drive/root:"
    --       },
    --       "size": 777835,
    --       "webUrl": "https://1drv.ms/i/s!ABXMdJvr_DM6pXs",
    --       "file": {
    --         "hashes": {
    --           "sha1Hash": "DF7BE9DC4F467187783ACA68C7CE98E4DF2172D0"
    --         },
    --         "mimeType": "image/jpeg"
    --       },
    --       "fileSystemInfo": {
    --         "createdDateTime": "2017-06-02T19:06:54Z",
    --         "lastModifiedDateTime": "2009-07-14T05:32:31Z"
    --       },
    --       "image": {
    --         "height": 768,
    --         "width": 1024
    --       },
    --       "photo": {
    --         "takenDateTime": "2008-02-18T05:07:31Z"
    --       }
    --     }
    --   ]
    -- }

    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @lastMod
    EXEC @hr = sp_OADestroy @photoTaken


END
GO