ADO.NET Provider for Yahoo! Ads

Build 23.0.8839


Get the contents keyeord list

Table Specific Information


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 '='.
  • ContentsKeywordListId supports the '=,IN'.

For example:

SELECT * FROM ContentsKeywordLists WHERE AccountId = '1002504155'

SELECT * FROM ContentsKeywordLists WHERE ContentsKeywordListId = '1000010795'


Insert can be executed by specifying the AccountId, ContentsKeywordListName, ContentsKeyword and ContentsKeywordId 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 ContentsKeywordListsContentsKeyword#TEMP (ContentsKeywordId) VALUES (181202)
INSERT INTO ContentsKeywordLists (ContentsKeywordListName, ContentsKeyword, accountid) VALUES ('testvickyy', 'ContentsKeywordListsContentsKeyword#TEMP', 1002504155)


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

INSERT INTO ContentsKeywordListsContentsKeyword#TEMP (ContentsKeywordId) VALUES (181202)
UPDATE ContentsKeywordLists SET ContentsKeywordListName = 'NewTestLabeltest' WHERE AccountId = '1002504155' AND ContentsKeyword = 'ContentsKeywordListsContentsKeyword#TEMP' AND ContentsKeywordListId = '1000010795'


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

DELETE FROM ContentsKeywordLists WHERE AccountId = '1002504155' AND ContentsKeywordListId = '1000010795'


Name Type ReadOnly References Description
ContentsKeywordListId [KEY] Int64 True

Contents keyword list ID.This field is required in SET and REMOVE operation.

AccountId Int64 True


Account ID.

BrandSafetyDenyListFlg Boolean False

A flag that indicates whether it is an exclusion list.This field is optional in ADD operation (default value will be FALSE), and cannot be specified in SET operation

使用できる値は次のとおりです。TRUE, FALSE

ContentsKeyword String False

Contents keyword.This field is required in ADD and SET operation

ContentsKeywordListDescription String False

Description of Contents keyword list

ContentsKeywordListName String False

Name of Contents keyword list.This field is required in ADD operation

IsRemoveContentsKeywordListDescription String False

ContentsKeywordListServiceIsRemoveFlg is a flag for removing an information item

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