ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

Videos

Read, Update or Delete Video Ads.

Table Specific Information

Select

The 本製品 will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • AccountId supports the '='.
  • MediaId supports the '=,IN'.
  • ApprovalStatus supports the '=,IN'.
  • ProcessStatus supports the '=,IN'.
  • UserStatus supports the '='.
  • StartDate supports the '='.
  • EndDate supports the '='.

For example:

SELECT * FROM Videos WHERE AccountId = '1002504155';

SELECT * FROM Videos WHERE AccountId = '1002504155' AND MediaId = '123456'

SELECT * FROM Videos WHERE AccountId = '1002504155' AND StartDate = '20210703'

SELECT * FROM Videos WHERE AccountId = '1002504155' AND EndDate = '20210703'

UPDATE

Update can be executed by specifying the AccountId and MediaId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Videos SET VideoName = 'Testvideo' WHERE AccountId = '1002504155' AND MediaId = '123456'

DELETE

Delete can be executed by specifying the AccountId and MediaId in the WHERE Clause. For example:

DELETE FROM Videos WHERE AccountId = '1002504155' AND MediaId = '123456'

Columns

Name Type ReadOnly References Description
MediaId [KEY] Int64 True

Media.MediaId

Media ID.

AccountId Int64 True

DisplayAdsAccounts.AccountId

Account ID.

ApprovalStatus String False

Editorial status.

使用できる値は次のとおりです。APPROVED, REVIEW, PRE_DISAPPROVED, POST_DISAPPROVED, UNKNOWN

CreatedDate Date True

Date when the video was made.

CreatedDateTime String False

Time and date when the video was submitted.

DisapprovalReasonCodes String False

Disapproval reason of the video.

ProcessStatus String False

process status of videos

使用できる値は次のとおりです。PROCESSING, FINISHED, FAILED, UNKNOWN

UserStatus String False

Ad delivery status that can be set by an user.

使用できる値は次のとおりです。ACTIVE, PAUSED, UNKNOWN

VideoName String False

Video file name.

VideoSettingExtraSpecs String False

It is an additional video quality that can be used other than the regular video qualities.

VideoSettingFileSize Int64 False

File size of the video.

VideoSettingFileType String False

File type of videos.

使用できる値は次のとおりです。MP4, UNKNOWN

VideoSettingHeight Int64 False

Height (vertical length) of the video.

VideoSettingPlaybackTime Int64 False

Play time (sec) of the video.

VideoSettingVideoAdFormat String False

Ad format type of the video ad.

VideoSettingVideoAspectRatio String False

Type of aspect ratio.

VideoSettingWidth Int64 False

Width of the video.

VideoTitle String False

Video name.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
StartDate Date

start date of the search target period.

EndDate Date

end date of the search target period.

ReferenceNumber String

This column will be used in Bulk operations to get specific values from the Temp tables.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062