Asset

Retrieves, adds, or updates asset information.

Table Specific Information

SELECT

The 本製品 uses 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 '='.
ApprovalStatus supports the '=,IN'.
AssetId supports the '=,IN'.

For example:

SELECT * FROM Asset WHERE AccountId = '1234339'
SELECT * FROM Asset WHERE AccountId = '1234339' AND ApprovalStatus = 'APPROVED'
SELECT * FROM Asset WHERE AccountId = '1234339' AND ApprovalStatus = 'APPROVED' AND AssetId = '3460269'

INSERT

To execute an INSERT query, specify the AccountId, AssetDataType, and AssetDataCalloutAssetCalloutText columns. You can also choose to insert other columns that are not read-only.

For example:

INSERT INTO Asset (AccountId, AssetDataType, AssetDataCalloutAssetCalloutText) VALUES (1234339, 'CALLOUT', 'Yogesh')

UPDATE

To execute an UPDATE query, specify the AccountId, AssetId AND AssetDataType.

For example:

UPDATE Asset SET AssetDataCalloutAssetCalloutText = 'Mangal' WHERE AccountId = 1234339 AND AssetId = 3460151 AND AssetDataType = 'CALLOUT'

DELETE

To execute a DELETE query, specify the AccountId and AssetId.

For example:

DELETE FROM Asset WHERE AccountId = '1234339' AND AssetId = '25683';

Columns


Name	Type	ReadOnly	References	Description
AccountId	Int64	False	SearchAdsAccounts.AccountId	Account ID.
ApprovalStatus	String	False		Displays Editorial Status.
AssetDataCallAssetPhoneNumber	String	False		Phone Number.
AssetDataCallAssetReviewPhoneNumber	String	False		Phone Number on editorial review.
AssetDataCallAssetSchedules	String	False		Describes display schedule from Ad Display Option.
AssetDataCalloutAssetCalloutText	String	False		Callout text.
AssetDataCalloutAssetEndDate	String	False		End date of ad display.
AssetDataCalloutAssetReviewCalloutText	String	False		Callout text on editorial review.
AssetDataCalloutAssetSchedules	String	False		Display schedule from Ad Display Option.
AssetDataCalloutAssetStartDate	String	False		Start date of ad display
AssetDataQuickLinkAssetDescription1	String	False		Description 1.
AssetDataQuickLinkAssetDescription2	String	False		Description 2.
AssetDataQuickLinkAssetEndDate	String	False		End date of ad display.
AssetDataQuickLinkAssetLinkText	String	False		Link text.
AssetDataQuickLinkAssetReviewDescription1	String	False		Description 1 on editorial review.
AssetDataQuickLinkAssetReviewDescription2	String	False		Description 2 on editorial review.
AssetDataQuickLinkAssetReviewLinkText	String	False		Link text on editorial review.
AssetDataQuickLinkAssetSchedules	String	False		Describes display schedule from Ad Display Option.
AssetDataQuickLinkAssetStartDate	String	False		Start date of ad display
AssetDataStructuredSnippetAssetHeader	String	False		Header.
AssetDataStructuredSnippetAssetReviewHeader	String	False		Header on editorial review.
AssetDataStructuredSnippetAssetReviewValues	String	False		Value on editorial review.
AssetDataStructuredSnippetAssetValues	String	False		Value.
AssetDataType	String	False		Asset information type. 使用できる値は次のとおりです。QUICKLINK, CALL, CALLOUT, STRUCTURED_SNIPPET, IMAGE, FAVICON, UNKNOWN
AssetId	Int64	True		Asset ID.
AssetTrackId	Int64	True		Asset ID for tracking.
CustomParametersIsRemove	String	False		AssetServiceIsRemove
CustomParametersParameters	String	False		Displays the element of custom parameters.
DisapprovalReasonCodes	String	False		Reject reason on editorial review.
FinalUrl	String	False		Landing Page URL.
InvalidedTrademarks	String	False		Invalided trademarks.
ReviewCustomParametersIsRemove	String	False		AssetServiceIsRemove
ReviewCustomParametersParameters	String	False		Displays the element of custom parameters.
ReviewFinalUrl	String	False		Landing Page URL on editorial review.
ReviewSmartphoneFinalUrl	String	False		Landing Page URL (Smartphone) on editorial review.
ReviewTrackingUrl	String	False		Tracking URL on editorial review.
SmartphoneFinalUrl	String	False		Landing Page URL (Smartphone).
TrackingUrl	String	False		Tracking URL.
TrademarkStatus	String	False		Describes the status of trademark.
AssetDataImageAssetImageName	String	True		Image name.
AssetDataImageAssetAspectRatio	String	True		The type of aspect ratio.
AssetDataImageAssetFileSize	Int64	True		The file size of image.
AssetDataImageAssetHeight	Int64	True		The height of image.
AssetDataImageAssetWidth	Int64	True		The width of image.
AssetDataImageAssetFileType	String	True		The file type of image. 使用できる値は次のとおりです。PNG, JPEG, UNKNOWN
AssetDataFaviconAssetFaviconName	String	True		Favicon name.
AssetDataFaviconAssetAspectRatio	String	True		The type of aspect ratio.
AssetDataFaviconAssetFileSize	Int64	True		The file size of Favicon.
AssetDataFaviconAssetHeight	Int64	True		The height of Favicon.
AssetDataFaviconAssetWidth	Int64	True		The width of Favicon.
AssetDataFaviconAssetFileType	String	True		The file type of Favicon. 使用できる値は次のとおりです。PNG, JPEG, UNKNOWN

JDBC Driver for Yahoo! Ads

Asset

Table Specific Information

SELECT

INSERT

UPDATE

DELETE

Columns