ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

SearchAdsAccounts

Read Or Update account information.

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 '=,IN'.
  • AccountName supports the '='.
  • AccountStatus supports the '=,IN'.
  • AccountType supports the '=,IN'.
  • IncludeTestAccount supports the '='.
  • IncludeManagerAccount supports the '='.

For example:

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436'

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436' AND AccountName='Test'	

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436' AND AccountStatus IN ('INPROGRESS')

SELECT * FROM SearchAdsAccounts WHERE AccountId='123436' AND AccountType IN ('Regular')

UPDATE

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

UPDATE SearchAdsAccounts SET AccountName = 'Test Account' WHERE AccountId = '123436'

Columns

Name Type ReadOnly References Description
AccountId [KEY] Int64 True

Account ID.

AccountName String False

Account Name.

AccountStatus String False

Account status.

使用できる値は次のとおりです。INPROGRESS, WAIT_DECIDE, SUSPENDED, SERVING, ENDED, UNKNOWN

AccountType String False

Payment type of the account.

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

AutoTaggingEnabled String False

The Management flag for whether or not to set auto tag.

ContactBizId String False

Contact Business ID.

DeliveryStatus String False

Delivery status.

StartDate Date False

Start date of ad serving.

EndDate Date False

End date of ad serving.

IsMccAccount String False

Describes whether it is an MCC account.

IsTestAccount String False

Describes whether it is a Test account.

Pseudo-Columns

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

Name Type Description
IncludeTestAccount String

Accounts to retrieve.

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

デフォルト値はEXCLUDE_TESTです。

IncludeManagerAccount String

Represents whether the account to be retrieved includes an MCC account.

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

デフォルト値はEXCLUDE_MANAGERです。

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