(SQL Server) Frame.io - Get Root Asset ID

Using the returned team_id, fetch the Projects accessible to your team. Each Project returned contains the root_asset_id in the response body. You may see one or multiple Projects returned in the resulting response:

For more information, see https://docs.frame.io/docs/root-asset-ids

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

    DECLARE @http int
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    -- Implements the following CURL command:

    -- curl \
    --     -H "Authorization: Bearer <FRAME_IO_DEV_TOKEN>" \
    --     https://api.frame.io/v2/teams/<TEAM_ID>/projects

    -- Use the following online tool to generate HTTP code from a CURL command
    -- Convert a cURL Command to HTTP Source Code

    -- Adds the "Authorization: Bearer <FRAME_IO_DEV_TOKEN>" header.
    EXEC sp_OASetProperty @http, 'AuthToken', '<FRAME_IO_DEV_TOKEN>'

    EXEC sp_OAMethod @http, 'SetUrlVar', @success OUT, 'team_id', '95a5fbad-688d-46fc-aef1-2f011dd76c10'

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

    EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://api.frame.io/v2/teams/{$team_id}/projects', @sbResponseBody
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbResponseBody
        RETURN
      END

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

    EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
    EXEC sp_OASetProperty @jResp, 'EmitCompact', 0


    PRINT 'Response Body:'
    EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    DECLARE @respStatusCode int
    EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT

    PRINT 'Response Status Code = ' + @respStatusCode
    IF @respStatusCode >= 400
      BEGIN

        PRINT 'Response Header:'
        EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT
        PRINT @sTmp0

        PRINT 'Failed.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbResponseBody
        EXEC @hr = sp_OADestroy @jResp
        RETURN
      END

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

    -- {
    --   "_type": "project",
    --   "archive_status": "standard",
    --   "archived_at": null,
    --   "archived_file_count": 0,
    --   "archived_storage": 0,
    --   "collaborator_count": 1,
    --   "deleted_at": null,
    --   "description": null,
    --   "file_count": 0,
    --   "folder_count": 0,
    --   "id": "e76653c4-6cc0-4c47-936b-f7885b477dc0",
    --   "ignore_archive": false,
    --   "inserted_at": "2020-08-18T02:20:13.182739Z",
    --   "invite_url": null,
    --   "name": "Demo Project",
    --   "owner_id": "34b4f98a-7cc9-4159-8f46-c7c3d837fc6f",
    --   "private": false,
    --   "project_preferences": {
    --     "_type": "project_preference",
    --     "collaborator_can_download": true,
    --     "collaborator_can_invite": true,
    --     "collaborator_can_share": false,
    --     "deleted_at": null,
    --     "id": null,
    --     "inserted_at": null,
    --     "notify_on_new_asset": true,
    --     "notify_on_new_collaborator": true,
    --     "notify_on_new_comment": true,
    --     "notify_on_new_mention": true,
    --     "notify_on_updated_label": true,
    --     "notify_slack": false,
    --     "project_id": null,
    --     "updated_at": null,
    --     "user_id": null
    --   },
    --   "read_only": false,
    --   "resource_id": "084f0074-dc55-426f-9006-1c5b61e9a73c",
    --   "root_asset": {
    --     "cover_asset_id": "ea9801c1-63e3-42a9-bfb4-88069bc78a58",
    --     "updated_at": "2020-08-18T02:20:14.443053Z",
    --     "filesize": 0,
    --     "team_id": "95a5fbad-688d-46fc-aef1-2f011dd76c10",
    --     "public_item_count": 0,
    --     "archived_at": null,
    --     "description": null,
    --     "parent_id": "e76653c4-6cc0-4c47-936b-f7885b477dc0",
    --     "index": 0.0,
    --     "shared": false,
    --     "comment_count": 0,
    --     "filetype": null,
    --     "archive_scheduled_at": null,
    --     "name": "root",
    --     "versions": 0,
    --     "hard_deleted_at": null,
    --     "uploaded_at": null,
    --     "resource_id": "b9d8f9cc-6c47-46a2-b5c9-42c28daa41f4",
    --     "checksums": null,
    --     "label": "none",
    --     "duration": null,
    --     "properties": null,
    --     "cover_asset": {
    --       "frame_thumb": null,
    --       "image_full": "https://frameio-assets-production.s3-accelerate.amazonaws.com/image/b0185958...941c453b",
    --       "image_small": "https://frameio-assets-production.s3-accelerate.amazonaws.com/image/b0185958...3a7c601",
    --       "webm_720": null,
    --       "hls_manifest": "https://stream.frame.io/manifest/hls/master?token=eyJ0e...ESPlqY",
    --       "cover_asset_id": null,
    --       "upload_completed_at": "2019-01-31T21:05:00.166807Z",
    --       "frame_custom": null,
    --       "updated_at": "2020-08-18T02:20:13.248074Z",
    --       "thumb_scrub": "https://frameio-assets-production.s3-accelerate.amazonaws.com/scrub/b0185958...0258415",
    --       "filesize": 324818296,
    --       "h264_2160": null,
    --       "status": "transcoded",
    --       "page_full": null,
    --       "team_id": "95a5fbad-688d-46fc-aef1-2f011dd76c10",
    --       "h264_1080_best": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...13c2d534",
    --       "webm_360": null,
    --       "video_h265_180": null,
    --       "public_item_count": null,
    --       "archived_at": null,
    --       "description": null,
    --       "parent_id": "4ecb383f-71a8-4233-b665-d8f75136f554",
    --       "frame_cover": null,
    --       "downloads": {
    --         "h264_1080_best": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...0f5b62e",
    --         "h264_2160": null,
    --         "h264_360": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...67e39fa",
    --         "h264_540": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...11c49",
    --         "h264_720": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...645a6b2",
    --         "image_full": "https://frameio-assets-production.s3-accelerate.amazonaws.com/image/b0185958...9c9ba3",
    --         "image_high": null,
    --         "image_small": "https://frameio-assets-production.s3-accelerate.amazonaws.com/image/b0185958...b27a62f51"
    --       },
    --       "webm_1080_best": null,
    --       "index": -6.0,
    --       "shared": true,
    --       "thumb_540": "https://frameio-assets-production.s3-accelerate.amazonaws.com/video-thumbnail/b0185958...f475f2c4",
    --       "required_transcodes": [
    --         "cover",
    --         "h264_1080_best",
    --         "h264_360",
    --         "h264_540",
    --         "h264_720",
    --         "image_full",
    --         "thumb",
    --         "thumb_540",
    --         "thumb_scrub"
    --       ],
    --       "thumb_orig_ar_540": null,
    --       "comment_count": 4,
    --       "h264_720": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...4bdb2",
    --       "filetype": "video/mp4",
    --       "archive_scheduled_at": null,
    --       "name": "60 Second Cut.mp4",
    --       "versions": 0,
    --       "hard_deleted_at": null,
    --       "page_thumb": null,
    --       "uploaded_at": "2019-01-31T21:02:51.933691Z",
    --       "resource_id": "771257e3-bdd0-4143-8ca6-ac17a0cfbf04",
    --       "timecode": null,
    --       "transcode_statuses": {
    --         "cover": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 70439,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": null,
    --           "width": null
    --         },
    --         "h264_1080_best": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 27454966,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": {
    --             "id": "69751009-0f67-47bd-af04-c5e0308275e4",
    --             "image": false,
    --             "text": false
    --           },
    --           "width": null
    --         },
    --         "h264_360": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 9428415,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": {
    --             "id": "18c972ab-303c-4e62-9401-c568d816ead0",
    --             "image": false,
    --             "text": false
    --           },
    --           "width": null
    --         },
    --         "h264_540": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 15124961,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": {
    --             "id": "3020e1b7-f352-4d81-a5f7-7e54a383bce0",
    --             "image": false,
    --             "text": false
    --           },
    --           "width": null
    --         },
    --         "h264_720": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 20408545,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": {
    --             "id": "445b9dcc-0cf7-48ae-843c-5d8f8444f78b",
    --             "image": false,
    --             "text": false
    --           },
    --           "width": null
    --         },
    --         "image_full": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 83611,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": {
    --             "id": "868e3f16-ee1d-4801-ae8d-f3aa45c48244",
    --             "image": false,
    --             "text": false
    --           },
    --           "width": null
    --         },
    --         "image_small": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 11536,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": {
    --             "id": "a589f2c8-3163-4e00-8188-915983ca5c69",
    --             "image": false,
    --             "text": false
    --           },
    --           "width": null
    --         },
    --         "thumb": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 5372,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": null,
    --           "width": null
    --         },
    --         "thumb_540": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 639200,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": null,
    --           "width": null
    --         },
    --         "thumb_scrub": {
    --           "codec": null,
    --           "duration": null,
    --           "encode_status": "success",
    --           "encode_time": null,
    --           "error": null,
    --           "filesize": 222692,
    --           "fps": null,
    --           "height": null,
    --           "language": null,
    --           "num_channels": null,
    --           "num_frames": null,
    --           "storage_class": "regular",
    --           "watermark": null,
    --           "width": null
    --         }
    --       },
    --       "checksums": null,
    --       "original": "https://frameio-uploads-production.s3-accelerate.amazonaws.com/uploads/b0185958...bd9da6a8",
    --       "label": "none",
    --       "h265_hdr_2160": null,
    --       "duration": 53.930667,
    --       "properties": null,
    --       "_type": "file",
    --       "thumb": "https://frameio-assets-production.s3-accelerate.amazonaws.com/video-thumbnail/b0185958...04c1e998",
    --       "is_360": false,
    --       "private": false,
    --       "page_small": null,
    --       "type": "file",
    --       "audio_tracks": null,
    --       "asset_type": "stream",
    --       "is_session_watermarked": false,
    --       "archive_status": null,
    --       "image_high": null,
    --       "project_id": "e76653c4-6cc0-4c47-936b-f7885b477dc0",
    --       "is_hls_required": false,
    --       "subtitle_tracks": null,
    --       "waveform": null,
    --       "creator_id": "c36e05d8-6bad-42ed-ae7a-c922ac7157b1",
    --       "includes": [
    --         "video",
    --         "audio"
    --       ],
    --       "h265_hdr_1080": null,
    --       "autoversion_id": null,
    --       "sha256": null,
    --       "transcodes": {
    --         "_type": "transcode_state",
    --         "codec": "AVC",
    --         "id": "85b2f3b8-14ff-4a87-bebe-0e4f39045492",
    --         "original_height": 1080,
    --         "original_width": 1920,
    --         "resolutions": [
    --           1080,
    --           720,
    --           540,
    --           360
    --         ],
    --         "thumb_height": 135,
    --         "thumb_state": "media",
    --         "thumb_width": 240,
    --         "thumbs": 50,
    --         "total_audio_tracks": null
    --       },
    --       "cover": "https://frameio-assets-production.s3-accelerate.amazonaws.com/video-cover/b0185958...dd94b623",
    --       "fps": 23.976,
    --       "frames": 1292,
    --       "account_id": "b1cd046b-a3bf-4ef8-81a6-0afd74ecc455",
    --       "h264_540": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...dc70e1cd4d8",
    --       "rating": null,
    --       "transcoded_at": "2019-01-31T21:07:30.490202Z",
    --       "h264_360": "https://frameio-assets-production.s3-accelerate.amazonaws.com/encode/b0185958...febcd42b4",
    --       "source": null,
    --       "id": "5cb9fda5-dbdf-43c8-a0ef-69e1ae323fd9",
    --       "copy": true,
    --       "view_count": 23,
    --       "deleted_at": null,
    --       "page_high": null,
    --       "user_permissions": {
    --         "can_download": true,
    --         "can_modify_template": false,
    --         "can_public_share_presentation": true,
    --         "can_public_share_review_link": true,
    --         "can_share_downloadable_presentation": true,
    --         "can_share_downloadable_review_link": true,
    --         "can_share_unwatermarked_presentation": true,
    --         "can_share_unwatermarked_review_link": true
    --       },
    --       "webm_540": null,
    --       "item_count": 0,
    --       "inserted_at": "2020-08-18T02:20:13.248074Z",
    --       "archive_from": "2020-08-18T02:20:13.248074Z"
    --     },
    --     "_type": "folder",
    --     "is_360": false,
    --     "private": false,
    --     "type": "folder",
    --     "audio_tracks": null,
    --     "is_session_watermarked": false,
    --     "archive_status": null,
    --     "project_id": "e76653c4-6cc0-4c47-936b-f7885b477dc0",
    --     "is_hls_required": false,
    --     "subtitle_tracks": null,
    --     "creator_id": "34b4f98a-7cc9-4159-8f46-c7c3d837fc6f",
    --     "autoversion_id": null,
    --     "fps": null,
    --     "frames": 0,
    --     "account_id": "b1cd046b-a3bf-4ef8-81a6-0afd74ecc455",
    --     "rating": null,
    --     "id": "4ecb383f-71a8-4233-b665-d8f75136f554",
    --     "copy": false,
    --     "deleted_at": null,
    --     "user_permissions": {
    --       "can_download": true,
    --       "can_modify_template": false,
    --       "can_public_share_presentation": true,
    --       "can_public_share_review_link": true,
    --       "can_share_downloadable_presentation": true,
    --       "can_share_downloadable_review_link": true,
    --       "can_share_unwatermarked_presentation": true,
    --       "can_share_unwatermarked_review_link": true
    --     },
    --     "item_count": 5,
    --     "inserted_at": "2020-08-18T02:20:13.192042Z"
    --   },
    --   "root_asset_id": "4ecb383f-71a8-4233-b665-d8f75136f554",
    --   "shared": false,
    --   "storage": 0,
    --   "team_id": "95a5fbad-688d-46fc-aef1-2f011dd76c10",
    --   "updated_at": "2020-08-18T02:20:14.428106Z",
    --   "user_permissions": {
    --     "can_download": true,
    --     "can_modify_template": false,
    --     "can_public_share_presentation": true,
    --     "can_public_share_review_link": true,
    --     "can_share_downloadable_presentation": true,
    --     "can_share_downloadable_review_link": true,
    --     "can_share_unwatermarked_presentation": true,
    --     "can_share_unwatermarked_review_link": true
    --   },
    --   "user_preferences": null
    -- }

    -- 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 @strVal nvarchar(4000)

    DECLARE @intVal int

    DECLARE @v_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, '_type'
    DECLARE @archive_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @archive_status OUT, 'archive_status'
    DECLARE @archived_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @archived_at OUT, 'archived_at'
    DECLARE @archived_file_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @archived_file_count OUT, 'archived_file_count'
    DECLARE @archived_storage int
    EXEC sp_OAMethod @jResp, 'IntOf', @archived_storage OUT, 'archived_storage'
    DECLARE @collaborator_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @collaborator_count OUT, 'collaborator_count'
    DECLARE @deleted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @deleted_at OUT, 'deleted_at'
    DECLARE @description nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'description'
    DECLARE @file_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @file_count OUT, 'file_count'
    DECLARE @folder_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @folder_count OUT, 'folder_count'
    DECLARE @id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @id OUT, 'id'
    DECLARE @ignore_archive int
    EXEC sp_OAMethod @jResp, 'BoolOf', @ignore_archive OUT, 'ignore_archive'
    DECLARE @inserted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @inserted_at OUT, 'inserted_at'
    DECLARE @invite_url nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @invite_url OUT, 'invite_url'
    DECLARE @name nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'name'
    DECLARE @owner_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @owner_id OUT, 'owner_id'
    DECLARE @v_private int
    EXEC sp_OAMethod @jResp, 'BoolOf', @v_private OUT, 'private'
    DECLARE @project_preferences_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferences_type OUT, 'project_preferences._type'
    DECLARE @project_preferencesCollaborator_can_download int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesCollaborator_can_download OUT, 'project_preferences.collaborator_can_download'
    DECLARE @project_preferencesCollaborator_can_invite int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesCollaborator_can_invite OUT, 'project_preferences.collaborator_can_invite'
    DECLARE @project_preferencesCollaborator_can_share int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesCollaborator_can_share OUT, 'project_preferences.collaborator_can_share'
    DECLARE @project_preferencesDeleted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferencesDeleted_at OUT, 'project_preferences.deleted_at'
    DECLARE @project_preferencesId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferencesId OUT, 'project_preferences.id'
    DECLARE @project_preferencesInserted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferencesInserted_at OUT, 'project_preferences.inserted_at'
    DECLARE @project_preferencesNotify_on_new_asset int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesNotify_on_new_asset OUT, 'project_preferences.notify_on_new_asset'
    DECLARE @project_preferencesNotify_on_new_collaborator int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesNotify_on_new_collaborator OUT, 'project_preferences.notify_on_new_collaborator'
    DECLARE @project_preferencesNotify_on_new_comment int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesNotify_on_new_comment OUT, 'project_preferences.notify_on_new_comment'
    DECLARE @project_preferencesNotify_on_new_mention int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesNotify_on_new_mention OUT, 'project_preferences.notify_on_new_mention'
    DECLARE @project_preferencesNotify_on_updated_label int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesNotify_on_updated_label OUT, 'project_preferences.notify_on_updated_label'
    DECLARE @project_preferencesNotify_slack int
    EXEC sp_OAMethod @jResp, 'BoolOf', @project_preferencesNotify_slack OUT, 'project_preferences.notify_slack'
    DECLARE @project_preferencesProject_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferencesProject_id OUT, 'project_preferences.project_id'
    DECLARE @project_preferencesUpdated_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferencesUpdated_at OUT, 'project_preferences.updated_at'
    DECLARE @project_preferencesUser_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @project_preferencesUser_id OUT, 'project_preferences.user_id'
    DECLARE @read_only int
    EXEC sp_OAMethod @jResp, 'BoolOf', @read_only OUT, 'read_only'
    DECLARE @resource_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @resource_id OUT, 'resource_id'
    DECLARE @root_assetCover_asset_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_asset_id OUT, 'root_asset.cover_asset_id'
    DECLARE @root_assetUpdated_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetUpdated_at OUT, 'root_asset.updated_at'
    DECLARE @root_assetFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetFilesize OUT, 'root_asset.filesize'
    DECLARE @root_assetTeam_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetTeam_id OUT, 'root_asset.team_id'
    DECLARE @root_assetPublic_item_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetPublic_item_count OUT, 'root_asset.public_item_count'
    DECLARE @root_assetArchived_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetArchived_at OUT, 'root_asset.archived_at'
    DECLARE @root_assetDescription nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetDescription OUT, 'root_asset.description'
    DECLARE @root_assetParent_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetParent_id OUT, 'root_asset.parent_id'
    DECLARE @root_assetIndex nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetIndex OUT, 'root_asset.index'
    DECLARE @root_assetShared int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetShared OUT, 'root_asset.shared'
    DECLARE @root_assetComment_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetComment_count OUT, 'root_asset.comment_count'
    DECLARE @root_assetFiletype nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetFiletype OUT, 'root_asset.filetype'
    DECLARE @root_assetArchive_scheduled_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetArchive_scheduled_at OUT, 'root_asset.archive_scheduled_at'
    DECLARE @root_assetName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetName OUT, 'root_asset.name'
    DECLARE @root_assetVersions int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetVersions OUT, 'root_asset.versions'
    DECLARE @root_assetHard_deleted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetHard_deleted_at OUT, 'root_asset.hard_deleted_at'
    DECLARE @root_assetUploaded_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetUploaded_at OUT, 'root_asset.uploaded_at'
    DECLARE @root_assetResource_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetResource_id OUT, 'root_asset.resource_id'
    DECLARE @root_assetChecksums nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetChecksums OUT, 'root_asset.checksums'
    DECLARE @root_assetLabel nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetLabel OUT, 'root_asset.label'
    DECLARE @root_assetDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetDuration OUT, 'root_asset.duration'
    DECLARE @root_assetProperties nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetProperties OUT, 'root_asset.properties'
    DECLARE @root_assetCover_assetFrame_thumb nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetFrame_thumb OUT, 'root_asset.cover_asset.frame_thumb'
    DECLARE @root_assetCover_assetImage_full nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetImage_full OUT, 'root_asset.cover_asset.image_full'
    DECLARE @root_assetCover_assetImage_small nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetImage_small OUT, 'root_asset.cover_asset.image_small'
    DECLARE @root_assetCover_assetWebm_720 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetWebm_720 OUT, 'root_asset.cover_asset.webm_720'
    DECLARE @root_assetCover_assetHls_manifest nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetHls_manifest OUT, 'root_asset.cover_asset.hls_manifest'
    DECLARE @root_assetCover_assetCover_asset_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetCover_asset_id OUT, 'root_asset.cover_asset.cover_asset_id'
    DECLARE @root_assetCover_assetUpload_completed_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetUpload_completed_at OUT, 'root_asset.cover_asset.upload_completed_at'
    DECLARE @root_assetCover_assetFrame_custom nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetFrame_custom OUT, 'root_asset.cover_asset.frame_custom'
    DECLARE @root_assetCover_assetUpdated_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetUpdated_at OUT, 'root_asset.cover_asset.updated_at'
    DECLARE @root_assetCover_assetThumb_scrub nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetThumb_scrub OUT, 'root_asset.cover_asset.thumb_scrub'
    DECLARE @root_assetCover_assetFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetFilesize OUT, 'root_asset.cover_asset.filesize'
    DECLARE @root_assetCover_assetH264_2160 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH264_2160 OUT, 'root_asset.cover_asset.h264_2160'
    DECLARE @root_assetCover_assetStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetStatus OUT, 'root_asset.cover_asset.status'
    DECLARE @root_assetCover_assetPage_full nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetPage_full OUT, 'root_asset.cover_asset.page_full'
    DECLARE @root_assetCover_assetTeam_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTeam_id OUT, 'root_asset.cover_asset.team_id'
    DECLARE @root_assetCover_assetH264_1080_best nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH264_1080_best OUT, 'root_asset.cover_asset.h264_1080_best'
    DECLARE @root_assetCover_assetWebm_360 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetWebm_360 OUT, 'root_asset.cover_asset.webm_360'
    DECLARE @root_assetCover_assetVideo_h265_180 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetVideo_h265_180 OUT, 'root_asset.cover_asset.video_h265_180'
    DECLARE @root_assetCover_assetPublic_item_count nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetPublic_item_count OUT, 'root_asset.cover_asset.public_item_count'
    DECLARE @root_assetCover_assetArchived_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetArchived_at OUT, 'root_asset.cover_asset.archived_at'
    DECLARE @root_assetCover_assetDescription nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDescription OUT, 'root_asset.cover_asset.description'
    DECLARE @root_assetCover_assetParent_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetParent_id OUT, 'root_asset.cover_asset.parent_id'
    DECLARE @root_assetCover_assetFrame_cover nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetFrame_cover OUT, 'root_asset.cover_asset.frame_cover'
    DECLARE @root_assetCover_assetDownloadsH264_1080_best nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsH264_1080_best OUT, 'root_asset.cover_asset.downloads.h264_1080_best'
    DECLARE @root_assetCover_assetDownloadsH264_2160 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsH264_2160 OUT, 'root_asset.cover_asset.downloads.h264_2160'
    DECLARE @root_assetCover_assetDownloadsH264_360 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsH264_360 OUT, 'root_asset.cover_asset.downloads.h264_360'
    DECLARE @root_assetCover_assetDownloadsH264_540 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsH264_540 OUT, 'root_asset.cover_asset.downloads.h264_540'
    DECLARE @root_assetCover_assetDownloadsH264_720 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsH264_720 OUT, 'root_asset.cover_asset.downloads.h264_720'
    DECLARE @root_assetCover_assetDownloadsImage_full nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsImage_full OUT, 'root_asset.cover_asset.downloads.image_full'
    DECLARE @root_assetCover_assetDownloadsImage_high nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsImage_high OUT, 'root_asset.cover_asset.downloads.image_high'
    DECLARE @root_assetCover_assetDownloadsImage_small nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDownloadsImage_small OUT, 'root_asset.cover_asset.downloads.image_small'
    DECLARE @root_assetCover_assetWebm_1080_best nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetWebm_1080_best OUT, 'root_asset.cover_asset.webm_1080_best'
    DECLARE @root_assetCover_assetIndex nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetIndex OUT, 'root_asset.cover_asset.index'
    DECLARE @root_assetCover_assetShared int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetShared OUT, 'root_asset.cover_asset.shared'
    DECLARE @root_assetCover_assetThumb_540 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetThumb_540 OUT, 'root_asset.cover_asset.thumb_540'
    DECLARE @root_assetCover_assetThumb_orig_ar_540 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetThumb_orig_ar_540 OUT, 'root_asset.cover_asset.thumb_orig_ar_540'
    DECLARE @root_assetCover_assetComment_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetComment_count OUT, 'root_asset.cover_asset.comment_count'
    DECLARE @root_assetCover_assetH264_720 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH264_720 OUT, 'root_asset.cover_asset.h264_720'
    DECLARE @root_assetCover_assetFiletype nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetFiletype OUT, 'root_asset.cover_asset.filetype'
    DECLARE @root_assetCover_assetArchive_scheduled_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetArchive_scheduled_at OUT, 'root_asset.cover_asset.archive_scheduled_at'
    DECLARE @root_assetCover_assetName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetName OUT, 'root_asset.cover_asset.name'
    DECLARE @root_assetCover_assetVersions int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetVersions OUT, 'root_asset.cover_asset.versions'
    DECLARE @root_assetCover_assetHard_deleted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetHard_deleted_at OUT, 'root_asset.cover_asset.hard_deleted_at'
    DECLARE @root_assetCover_assetPage_thumb nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetPage_thumb OUT, 'root_asset.cover_asset.page_thumb'
    DECLARE @root_assetCover_assetUploaded_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetUploaded_at OUT, 'root_asset.cover_asset.uploaded_at'
    DECLARE @root_assetCover_assetResource_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetResource_id OUT, 'root_asset.cover_asset.resource_id'
    DECLARE @root_assetCover_assetTimecode nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTimecode OUT, 'root_asset.cover_asset.timecode'
    DECLARE @root_assetCover_assetTranscode_statusesCoverCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverCodec OUT, 'root_asset.cover_asset.transcode_statuses.cover.codec'
    DECLARE @root_assetCover_assetTranscode_statusesCoverDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverDuration OUT, 'root_asset.cover_asset.transcode_statuses.cover.duration'
    DECLARE @root_assetCover_assetTranscode_statusesCoverEncode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverEncode_status OUT, 'root_asset.cover_asset.transcode_statuses.cover.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesCoverEncode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverEncode_time OUT, 'root_asset.cover_asset.transcode_statuses.cover.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesCoverError nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverError OUT, 'root_asset.cover_asset.transcode_statuses.cover.error'
    DECLARE @root_assetCover_assetTranscode_statusesCoverFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesCoverFilesize OUT, 'root_asset.cover_asset.transcode_statuses.cover.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesCoverFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverFps OUT, 'root_asset.cover_asset.transcode_statuses.cover.fps'
    DECLARE @root_assetCover_assetTranscode_statusesCoverHeight nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverHeight OUT, 'root_asset.cover_asset.transcode_statuses.cover.height'
    DECLARE @root_assetCover_assetTranscode_statusesCoverLanguage nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverLanguage OUT, 'root_asset.cover_asset.transcode_statuses.cover.language'
    DECLARE @root_assetCover_assetTranscode_statusesCoverNum_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverNum_channels OUT, 'root_asset.cover_asset.transcode_statuses.cover.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesCoverNum_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverNum_frames OUT, 'root_asset.cover_asset.transcode_statuses.cover.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesCoverStorage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverStorage_class OUT, 'root_asset.cover_asset.transcode_statuses.cover.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesCoverWatermark nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverWatermark OUT, 'root_asset.cover_asset.transcode_statuses.cover.watermark'
    DECLARE @root_assetCover_assetTranscode_statusesCoverWidth nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesCoverWidth OUT, 'root_asset.cover_asset.transcode_statuses.cover.width'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestCodec OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.codec'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestDuration OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.duration'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestEncode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestEncode_status OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestEncode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestEncode_time OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestError nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestError OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.error'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesH264_1080_bestFilesize OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestFps OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.fps'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestHeight nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestHeight OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.height'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestLanguage nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestLanguage OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.language'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestNum_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestNum_channels OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestNum_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestNum_frames OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestStorage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestStorage_class OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestWatermarkId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestWatermarkId OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.watermark.id'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestWatermarkImage int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_1080_bestWatermarkImage OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.watermark.image'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestWatermarkText int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_1080_bestWatermarkText OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.watermark.text'
    DECLARE @root_assetCover_assetTranscode_statusesH264_1080_bestWidth nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_1080_bestWidth OUT, 'root_asset.cover_asset.transcode_statuses.h264_1080_best.width'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Codec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Codec OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.codec'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Duration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Duration OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.duration'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Encode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Encode_status OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Encode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Encode_time OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Error nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Error OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.error'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Filesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesH264_360Filesize OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Fps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Fps OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.fps'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Height nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Height OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.height'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Language nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Language OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.language'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Num_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Num_channels OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Num_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Num_frames OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Storage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Storage_class OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360WatermarkId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360WatermarkId OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.watermark.id'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360WatermarkImage int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_360WatermarkImage OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.watermark.image'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360WatermarkText int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_360WatermarkText OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.watermark.text'
    DECLARE @root_assetCover_assetTranscode_statusesH264_360Width nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_360Width OUT, 'root_asset.cover_asset.transcode_statuses.h264_360.width'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Codec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Codec OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.codec'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Duration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Duration OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.duration'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Encode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Encode_status OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Encode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Encode_time OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Error nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Error OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.error'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Filesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesH264_540Filesize OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Fps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Fps OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.fps'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Height nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Height OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.height'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Language nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Language OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.language'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Num_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Num_channels OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Num_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Num_frames OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Storage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Storage_class OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540WatermarkId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540WatermarkId OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.watermark.id'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540WatermarkImage int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_540WatermarkImage OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.watermark.image'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540WatermarkText int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_540WatermarkText OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.watermark.text'
    DECLARE @root_assetCover_assetTranscode_statusesH264_540Width nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_540Width OUT, 'root_asset.cover_asset.transcode_statuses.h264_540.width'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Codec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Codec OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.codec'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Duration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Duration OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.duration'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Encode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Encode_status OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Encode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Encode_time OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Error nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Error OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.error'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Filesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesH264_720Filesize OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Fps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Fps OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.fps'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Height nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Height OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.height'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Language nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Language OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.language'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Num_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Num_channels OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Num_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Num_frames OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Storage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Storage_class OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720WatermarkId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720WatermarkId OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.watermark.id'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720WatermarkImage int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_720WatermarkImage OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.watermark.image'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720WatermarkText int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesH264_720WatermarkText OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.watermark.text'
    DECLARE @root_assetCover_assetTranscode_statusesH264_720Width nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesH264_720Width OUT, 'root_asset.cover_asset.transcode_statuses.h264_720.width'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullCodec OUT, 'root_asset.cover_asset.transcode_statuses.image_full.codec'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullDuration OUT, 'root_asset.cover_asset.transcode_statuses.image_full.duration'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullEncode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullEncode_status OUT, 'root_asset.cover_asset.transcode_statuses.image_full.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullEncode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullEncode_time OUT, 'root_asset.cover_asset.transcode_statuses.image_full.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullError nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullError OUT, 'root_asset.cover_asset.transcode_statuses.image_full.error'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesImage_fullFilesize OUT, 'root_asset.cover_asset.transcode_statuses.image_full.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullFps OUT, 'root_asset.cover_asset.transcode_statuses.image_full.fps'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullHeight nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullHeight OUT, 'root_asset.cover_asset.transcode_statuses.image_full.height'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullLanguage nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullLanguage OUT, 'root_asset.cover_asset.transcode_statuses.image_full.language'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullNum_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullNum_channels OUT, 'root_asset.cover_asset.transcode_statuses.image_full.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullNum_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullNum_frames OUT, 'root_asset.cover_asset.transcode_statuses.image_full.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullStorage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullStorage_class OUT, 'root_asset.cover_asset.transcode_statuses.image_full.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullWatermarkId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullWatermarkId OUT, 'root_asset.cover_asset.transcode_statuses.image_full.watermark.id'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullWatermarkImage int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesImage_fullWatermarkImage OUT, 'root_asset.cover_asset.transcode_statuses.image_full.watermark.image'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullWatermarkText int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesImage_fullWatermarkText OUT, 'root_asset.cover_asset.transcode_statuses.image_full.watermark.text'
    DECLARE @root_assetCover_assetTranscode_statusesImage_fullWidth nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_fullWidth OUT, 'root_asset.cover_asset.transcode_statuses.image_full.width'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallCodec OUT, 'root_asset.cover_asset.transcode_statuses.image_small.codec'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallDuration OUT, 'root_asset.cover_asset.transcode_statuses.image_small.duration'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallEncode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallEncode_status OUT, 'root_asset.cover_asset.transcode_statuses.image_small.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallEncode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallEncode_time OUT, 'root_asset.cover_asset.transcode_statuses.image_small.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallError nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallError OUT, 'root_asset.cover_asset.transcode_statuses.image_small.error'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesImage_smallFilesize OUT, 'root_asset.cover_asset.transcode_statuses.image_small.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallFps OUT, 'root_asset.cover_asset.transcode_statuses.image_small.fps'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallHeight nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallHeight OUT, 'root_asset.cover_asset.transcode_statuses.image_small.height'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallLanguage nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallLanguage OUT, 'root_asset.cover_asset.transcode_statuses.image_small.language'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallNum_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallNum_channels OUT, 'root_asset.cover_asset.transcode_statuses.image_small.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallNum_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallNum_frames OUT, 'root_asset.cover_asset.transcode_statuses.image_small.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallStorage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallStorage_class OUT, 'root_asset.cover_asset.transcode_statuses.image_small.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallWatermarkId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallWatermarkId OUT, 'root_asset.cover_asset.transcode_statuses.image_small.watermark.id'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallWatermarkImage int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesImage_smallWatermarkImage OUT, 'root_asset.cover_asset.transcode_statuses.image_small.watermark.image'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallWatermarkText int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetTranscode_statusesImage_smallWatermarkText OUT, 'root_asset.cover_asset.transcode_statuses.image_small.watermark.text'
    DECLARE @root_assetCover_assetTranscode_statusesImage_smallWidth nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesImage_smallWidth OUT, 'root_asset.cover_asset.transcode_statuses.image_small.width'
    DECLARE @root_assetCover_assetTranscode_statusesThumbCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbCodec OUT, 'root_asset.cover_asset.transcode_statuses.thumb.codec'
    DECLARE @root_assetCover_assetTranscode_statusesThumbDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbDuration OUT, 'root_asset.cover_asset.transcode_statuses.thumb.duration'
    DECLARE @root_assetCover_assetTranscode_statusesThumbEncode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbEncode_status OUT, 'root_asset.cover_asset.transcode_statuses.thumb.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesThumbEncode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbEncode_time OUT, 'root_asset.cover_asset.transcode_statuses.thumb.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesThumbError nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbError OUT, 'root_asset.cover_asset.transcode_statuses.thumb.error'
    DECLARE @root_assetCover_assetTranscode_statusesThumbFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesThumbFilesize OUT, 'root_asset.cover_asset.transcode_statuses.thumb.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesThumbFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbFps OUT, 'root_asset.cover_asset.transcode_statuses.thumb.fps'
    DECLARE @root_assetCover_assetTranscode_statusesThumbHeight nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbHeight OUT, 'root_asset.cover_asset.transcode_statuses.thumb.height'
    DECLARE @root_assetCover_assetTranscode_statusesThumbLanguage nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbLanguage OUT, 'root_asset.cover_asset.transcode_statuses.thumb.language'
    DECLARE @root_assetCover_assetTranscode_statusesThumbNum_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbNum_channels OUT, 'root_asset.cover_asset.transcode_statuses.thumb.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesThumbNum_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbNum_frames OUT, 'root_asset.cover_asset.transcode_statuses.thumb.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesThumbStorage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbStorage_class OUT, 'root_asset.cover_asset.transcode_statuses.thumb.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesThumbWatermark nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbWatermark OUT, 'root_asset.cover_asset.transcode_statuses.thumb.watermark'
    DECLARE @root_assetCover_assetTranscode_statusesThumbWidth nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumbWidth OUT, 'root_asset.cover_asset.transcode_statuses.thumb.width'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Codec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Codec OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.codec'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Duration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Duration OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.duration'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Encode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Encode_status OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Encode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Encode_time OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Error nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Error OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.error'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Filesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesThumb_540Filesize OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Fps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Fps OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.fps'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Height nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Height OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.height'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Language nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Language OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.language'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Num_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Num_channels OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Num_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Num_frames OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Storage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Storage_class OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Watermark nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Watermark OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.watermark'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_540Width nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_540Width OUT, 'root_asset.cover_asset.transcode_statuses.thumb_540.width'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubCodec OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.codec'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubDuration OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.duration'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubEncode_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubEncode_status OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.encode_status'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubEncode_time nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubEncode_time OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.encode_time'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubError nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubError OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.error'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubFilesize int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscode_statusesThumb_scrubFilesize OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.filesize'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubFps OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.fps'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubHeight nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubHeight OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.height'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubLanguage nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubLanguage OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.language'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubNum_channels nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubNum_channels OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.num_channels'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubNum_frames nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubNum_frames OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.num_frames'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubStorage_class nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubStorage_class OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.storage_class'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubWatermark nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubWatermark OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.watermark'
    DECLARE @root_assetCover_assetTranscode_statusesThumb_scrubWidth nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscode_statusesThumb_scrubWidth OUT, 'root_asset.cover_asset.transcode_statuses.thumb_scrub.width'
    DECLARE @root_assetCover_assetChecksums nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetChecksums OUT, 'root_asset.cover_asset.checksums'
    DECLARE @root_assetCover_assetOriginal nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetOriginal OUT, 'root_asset.cover_asset.original'
    DECLARE @root_assetCover_assetLabel nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetLabel OUT, 'root_asset.cover_asset.label'
    DECLARE @root_assetCover_assetH265_hdr_2160 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH265_hdr_2160 OUT, 'root_asset.cover_asset.h265_hdr_2160'
    DECLARE @root_assetCover_assetDuration nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDuration OUT, 'root_asset.cover_asset.duration'
    DECLARE @root_assetCover_assetProperties nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetProperties OUT, 'root_asset.cover_asset.properties'
    DECLARE @root_assetCover_asset_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_asset_type OUT, 'root_asset.cover_asset._type'
    DECLARE @root_assetCover_assetThumb nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetThumb OUT, 'root_asset.cover_asset.thumb'
    DECLARE @root_assetCover_assetIs_360 int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetIs_360 OUT, 'root_asset.cover_asset.is_360'
    DECLARE @root_assetCover_assetPrivate int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetPrivate OUT, 'root_asset.cover_asset.private'
    DECLARE @root_assetCover_assetPage_small nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetPage_small OUT, 'root_asset.cover_asset.page_small'
    DECLARE @root_assetCover_assetType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetType OUT, 'root_asset.cover_asset.type'
    DECLARE @root_assetCover_assetAudio_tracks nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetAudio_tracks OUT, 'root_asset.cover_asset.audio_tracks'
    DECLARE @root_assetCover_assetAsset_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetAsset_type OUT, 'root_asset.cover_asset.asset_type'
    DECLARE @root_assetCover_assetIs_session_watermarked int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetIs_session_watermarked OUT, 'root_asset.cover_asset.is_session_watermarked'
    DECLARE @root_assetCover_assetArchive_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetArchive_status OUT, 'root_asset.cover_asset.archive_status'
    DECLARE @root_assetCover_assetImage_high nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetImage_high OUT, 'root_asset.cover_asset.image_high'
    DECLARE @root_assetCover_assetProject_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetProject_id OUT, 'root_asset.cover_asset.project_id'
    DECLARE @root_assetCover_assetIs_hls_required int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetIs_hls_required OUT, 'root_asset.cover_asset.is_hls_required'
    DECLARE @root_assetCover_assetSubtitle_tracks nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetSubtitle_tracks OUT, 'root_asset.cover_asset.subtitle_tracks'
    DECLARE @root_assetCover_assetWaveform nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetWaveform OUT, 'root_asset.cover_asset.waveform'
    DECLARE @root_assetCover_assetCreator_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetCreator_id OUT, 'root_asset.cover_asset.creator_id'
    DECLARE @root_assetCover_assetH265_hdr_1080 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH265_hdr_1080 OUT, 'root_asset.cover_asset.h265_hdr_1080'
    DECLARE @root_assetCover_assetAutoversion_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetAutoversion_id OUT, 'root_asset.cover_asset.autoversion_id'
    DECLARE @root_assetCover_assetSha256 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetSha256 OUT, 'root_asset.cover_asset.sha256'
    DECLARE @root_assetCover_assetTranscodes_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscodes_type OUT, 'root_asset.cover_asset.transcodes._type'
    DECLARE @root_assetCover_assetTranscodesCodec nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscodesCodec OUT, 'root_asset.cover_asset.transcodes.codec'
    DECLARE @root_assetCover_assetTranscodesId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscodesId OUT, 'root_asset.cover_asset.transcodes.id'
    DECLARE @root_assetCover_assetTranscodesOriginal_height int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscodesOriginal_height OUT, 'root_asset.cover_asset.transcodes.original_height'
    DECLARE @root_assetCover_assetTranscodesOriginal_width int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscodesOriginal_width OUT, 'root_asset.cover_asset.transcodes.original_width'
    DECLARE @root_assetCover_assetTranscodesThumb_height int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscodesThumb_height OUT, 'root_asset.cover_asset.transcodes.thumb_height'
    DECLARE @root_assetCover_assetTranscodesThumb_state nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscodesThumb_state OUT, 'root_asset.cover_asset.transcodes.thumb_state'
    DECLARE @root_assetCover_assetTranscodesThumb_width int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscodesThumb_width OUT, 'root_asset.cover_asset.transcodes.thumb_width'
    DECLARE @root_assetCover_assetTranscodesThumbs int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetTranscodesThumbs OUT, 'root_asset.cover_asset.transcodes.thumbs'
    DECLARE @root_assetCover_assetTranscodesTotal_audio_tracks nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscodesTotal_audio_tracks OUT, 'root_asset.cover_asset.transcodes.total_audio_tracks'
    DECLARE @root_assetCover_assetCover nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetCover OUT, 'root_asset.cover_asset.cover'
    DECLARE @root_assetCover_assetFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetFps OUT, 'root_asset.cover_asset.fps'
    DECLARE @root_assetCover_assetFrames int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetFrames OUT, 'root_asset.cover_asset.frames'
    DECLARE @root_assetCover_assetAccount_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetAccount_id OUT, 'root_asset.cover_asset.account_id'
    DECLARE @root_assetCover_assetH264_540 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH264_540 OUT, 'root_asset.cover_asset.h264_540'
    DECLARE @root_assetCover_assetRating nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetRating OUT, 'root_asset.cover_asset.rating'
    DECLARE @root_assetCover_assetTranscoded_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetTranscoded_at OUT, 'root_asset.cover_asset.transcoded_at'
    DECLARE @root_assetCover_assetH264_360 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetH264_360 OUT, 'root_asset.cover_asset.h264_360'
    DECLARE @root_assetCover_assetSource nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetSource OUT, 'root_asset.cover_asset.source'
    DECLARE @root_assetCover_assetId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetId OUT, 'root_asset.cover_asset.id'
    DECLARE @root_assetCover_assetCopy int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetCopy OUT, 'root_asset.cover_asset.copy'
    DECLARE @root_assetCover_assetView_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetView_count OUT, 'root_asset.cover_asset.view_count'
    DECLARE @root_assetCover_assetDeleted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetDeleted_at OUT, 'root_asset.cover_asset.deleted_at'
    DECLARE @root_assetCover_assetPage_high nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetPage_high OUT, 'root_asset.cover_asset.page_high'
    DECLARE @root_assetCover_assetUser_permissionsCan_download int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_download OUT, 'root_asset.cover_asset.user_permissions.can_download'
    DECLARE @root_assetCover_assetUser_permissionsCan_modify_template int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_modify_template OUT, 'root_asset.cover_asset.user_permissions.can_modify_template'
    DECLARE @root_assetCover_assetUser_permissionsCan_public_share_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_public_share_presentation OUT, 'root_asset.cover_asset.user_permissions.can_public_share_presentation'
    DECLARE @root_assetCover_assetUser_permissionsCan_public_share_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_public_share_review_link OUT, 'root_asset.cover_asset.user_permissions.can_public_share_review_link'
    DECLARE @root_assetCover_assetUser_permissionsCan_share_downloadable_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_share_downloadable_presentation OUT, 'root_asset.cover_asset.user_permissions.can_share_downloadable_presentation'
    DECLARE @root_assetCover_assetUser_permissionsCan_share_downloadable_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_share_downloadable_review_link OUT, 'root_asset.cover_asset.user_permissions.can_share_downloadable_review_link'
    DECLARE @root_assetCover_assetUser_permissionsCan_share_unwatermarked_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_share_unwatermarked_presentation OUT, 'root_asset.cover_asset.user_permissions.can_share_unwatermarked_presentation'
    DECLARE @root_assetCover_assetUser_permissionsCan_share_unwatermarked_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCover_assetUser_permissionsCan_share_unwatermarked_review_link OUT, 'root_asset.cover_asset.user_permissions.can_share_unwatermarked_review_link'
    DECLARE @root_assetCover_assetWebm_540 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetWebm_540 OUT, 'root_asset.cover_asset.webm_540'
    DECLARE @root_assetCover_assetItem_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetCover_assetItem_count OUT, 'root_asset.cover_asset.item_count'
    DECLARE @root_assetCover_assetInserted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetInserted_at OUT, 'root_asset.cover_asset.inserted_at'
    DECLARE @root_assetCover_assetArchive_from nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCover_assetArchive_from OUT, 'root_asset.cover_asset.archive_from'
    DECLARE @root_asset_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_asset_type OUT, 'root_asset._type'
    DECLARE @root_assetIs_360 int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetIs_360 OUT, 'root_asset.is_360'
    DECLARE @root_assetPrivate int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetPrivate OUT, 'root_asset.private'
    DECLARE @root_assetType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetType OUT, 'root_asset.type'
    DECLARE @root_assetAudio_tracks nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetAudio_tracks OUT, 'root_asset.audio_tracks'
    DECLARE @root_assetIs_session_watermarked int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetIs_session_watermarked OUT, 'root_asset.is_session_watermarked'
    DECLARE @root_assetArchive_status nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetArchive_status OUT, 'root_asset.archive_status'
    DECLARE @root_assetProject_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetProject_id OUT, 'root_asset.project_id'
    DECLARE @root_assetIs_hls_required int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetIs_hls_required OUT, 'root_asset.is_hls_required'
    DECLARE @root_assetSubtitle_tracks nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetSubtitle_tracks OUT, 'root_asset.subtitle_tracks'
    DECLARE @root_assetCreator_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetCreator_id OUT, 'root_asset.creator_id'
    DECLARE @root_assetAutoversion_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetAutoversion_id OUT, 'root_asset.autoversion_id'
    DECLARE @root_assetFps nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetFps OUT, 'root_asset.fps'
    DECLARE @root_assetFrames int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetFrames OUT, 'root_asset.frames'
    DECLARE @root_assetAccount_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetAccount_id OUT, 'root_asset.account_id'
    DECLARE @root_assetRating nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetRating OUT, 'root_asset.rating'
    DECLARE @root_assetId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetId OUT, 'root_asset.id'
    DECLARE @root_assetCopy int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetCopy OUT, 'root_asset.copy'
    DECLARE @root_assetDeleted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetDeleted_at OUT, 'root_asset.deleted_at'
    DECLARE @root_assetUser_permissionsCan_download int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_download OUT, 'root_asset.user_permissions.can_download'
    DECLARE @root_assetUser_permissionsCan_modify_template int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_modify_template OUT, 'root_asset.user_permissions.can_modify_template'
    DECLARE @root_assetUser_permissionsCan_public_share_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_public_share_presentation OUT, 'root_asset.user_permissions.can_public_share_presentation'
    DECLARE @root_assetUser_permissionsCan_public_share_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_public_share_review_link OUT, 'root_asset.user_permissions.can_public_share_review_link'
    DECLARE @root_assetUser_permissionsCan_share_downloadable_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_share_downloadable_presentation OUT, 'root_asset.user_permissions.can_share_downloadable_presentation'
    DECLARE @root_assetUser_permissionsCan_share_downloadable_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_share_downloadable_review_link OUT, 'root_asset.user_permissions.can_share_downloadable_review_link'
    DECLARE @root_assetUser_permissionsCan_share_unwatermarked_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_share_unwatermarked_presentation OUT, 'root_asset.user_permissions.can_share_unwatermarked_presentation'
    DECLARE @root_assetUser_permissionsCan_share_unwatermarked_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @root_assetUser_permissionsCan_share_unwatermarked_review_link OUT, 'root_asset.user_permissions.can_share_unwatermarked_review_link'
    DECLARE @root_assetItem_count int
    EXEC sp_OAMethod @jResp, 'IntOf', @root_assetItem_count OUT, 'root_asset.item_count'
    DECLARE @root_assetInserted_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_assetInserted_at OUT, 'root_asset.inserted_at'
    DECLARE @root_asset_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @root_asset_id OUT, 'root_asset_id'
    DECLARE @shared int
    EXEC sp_OAMethod @jResp, 'BoolOf', @shared OUT, 'shared'
    DECLARE @storage int
    EXEC sp_OAMethod @jResp, 'IntOf', @storage OUT, 'storage'
    DECLARE @team_id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @team_id OUT, 'team_id'
    DECLARE @updated_at nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @updated_at OUT, 'updated_at'
    DECLARE @user_permissionsCan_download int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_download OUT, 'user_permissions.can_download'
    DECLARE @user_permissionsCan_modify_template int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_modify_template OUT, 'user_permissions.can_modify_template'
    DECLARE @user_permissionsCan_public_share_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_public_share_presentation OUT, 'user_permissions.can_public_share_presentation'
    DECLARE @user_permissionsCan_public_share_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_public_share_review_link OUT, 'user_permissions.can_public_share_review_link'
    DECLARE @user_permissionsCan_share_downloadable_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_share_downloadable_presentation OUT, 'user_permissions.can_share_downloadable_presentation'
    DECLARE @user_permissionsCan_share_downloadable_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_share_downloadable_review_link OUT, 'user_permissions.can_share_downloadable_review_link'
    DECLARE @user_permissionsCan_share_unwatermarked_presentation int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_share_unwatermarked_presentation OUT, 'user_permissions.can_share_unwatermarked_presentation'
    DECLARE @user_permissionsCan_share_unwatermarked_review_link int
    EXEC sp_OAMethod @jResp, 'BoolOf', @user_permissionsCan_share_unwatermarked_review_link OUT, 'user_permissions.can_share_unwatermarked_review_link'
    DECLARE @user_preferences nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @user_preferences OUT, 'user_preferences'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'root_asset.cover_asset.required_transcodes'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'root_asset.cover_asset.required_transcodes[i]'
        SELECT @i = @i + 1
      END
    SELECT @i = 0
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'root_asset.cover_asset.includes'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'root_asset.cover_asset.includes[i]'
        SELECT @i = @i + 1
      END
    SELECT @i = 0
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'root_asset.cover_asset.transcodes.resolutions'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        EXEC sp_OAMethod @jResp, 'IntOf', @intVal OUT, 'root_asset.cover_asset.transcodes.resolutions[i]'
        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @sbResponseBody
    EXEC @hr = sp_OADestroy @jResp


END
GO