ADO.NET Provider for Yahoo! Ads

Build 23.0.8839

SearchAdsBaseAccount

Get lists of all accounts (MCC and ad accounts).

Table Specific Information

Select

The 本製品 will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The ManagerAccountId 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'.
  • AuthType supports the '='.
  • IncludeAdminAuth supports the '='.
  • IncludeMccAccount supports the '='.
  • IncludeTestAccount supports the '='.

For example: 

SELECT * FROM SearchAdsBaseAccount
SELECT * FROM SearchAdsBaseAccount WHERE AccountId = '1001987917'
SELECT * FROM SearchAdsBaseAccount WHERE AccountName = 'CData Software Japan 株式会社'
SELECT * FROM SearchAdsBaseAccount WHERE IncludeMccAccount = 'ONLY_MCC'

Columns

Name Type References Description
AccountId [KEY] Int64

SearchAdsAccounts.AccountId

Account ID.
AccountName String Account name.
AccountStatus String Displays the account registration status.
AuthType String Access Roles.
HasAdminAuth String It indicates whether admin access is available for this account.
IsRootMccAccount String It indicates whether it is an root MCC account.
IsMccAccount String It indicates whether it is an MCC account.
IsTestAccount String It indicates whether it is a test account.

Pseudo-Columns

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

Name Type Description
IncludeAdminAuth String It indicates whether to include accounts with admin access for accounts you get.

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

IncludeMccAccount String It represents whether the account to be retrieved includes an MCC account.

使用できる値は次のとおりです。ONLY_MCC, ONLY_ROOT_MCC, ONLY_ADS_ACCOUNT, ALL, UNKNOWN

IncludeTestAccount String It represents whether the account to be retrieved includes an test account.

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

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