SQL Server
SQL Server
Frame.io - Get Root Asset ID
See more Frame.io Examples
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:Chilkat SQL Server Downloads
-- 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)
DECLARE @success int
SELECT @success = 0
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
-- 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
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
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