Get, Add or Update Asset Information.

Table Specific Information

Select

The connector 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 connector.

• 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

Insert can be executed by specifying the AccountId, AssetDataType, AssetDataCalloutAssetCalloutText columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table

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

UPDATE

Update can be executed by specifying the AccountId, AssetId AND AssetDataType in the WHERE Clause. For example:

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

Columns