Yahoo! Ads への接続を追加

1. アプリケーションコンソールで、接続ページに移動します。
2. 接続の追加パネルで、追加したい接続のアイコンを選択します。
3. Yahoo! Ads アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからYahoo! Ads コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Yahoo! Ads への接続

以下をオプションで設定して、Yahoo! Ads から返されたデータを絞り込むことができます。

• DisplayAdsAccountId：お使いのYahoo! Ads のDisplayAds アカウントに関連付けられた一意の識別子に設定。指定しない場合は、デフォルトでドライバーがID を取得します。
• SearchAdsAccountId：お使いのYahoo! Ads のSearchAds アカウントに関連付けられた一意の識別子に設定。指定しない場合は、デフォルトでドライバーがID を取得します。

Yahoo! Ads への認証

アクセストークンの期限が切れたときは、Sync App は自動でアクセストークンをリフレッシュします。

OAuth 認証

カスタムアプリケーションを作成した場合は、接続する前に以下の変数を設定してください。

• OAuthClientId：カスタムOAuth アプリケーションの登録時に割り当てられたクライアントId。
• OAuthClientSecret：カスタムOAuth アプリケーションの登録時に割り当てられたクライアントシークレット。

Yahoo! Ads への接続 をクリックして、デフォルトブラウザでOAuth エンドポイントを開きます。ログインして、アプリケーションにアクセス許可を与えます。

ドライバーは、以下のようにOAuth プロセスを完了します。

• コールバックURL からアクセストークンを取得します。
• 古いトークンの期限が切れたときは、新しいアクセストークンを取得します。
• OAuth 値を保存し、接続間で永続化します。

CData はOAuth アプリケーション認証情報を製品に組み込んでおり、デスクトップアプリケーションまたはヘッドレスマシン経由でYahoo! Ads に接続する際に使用できます。埋め込みOAuth アプリケーションを使用する場合、接続するために必要なことは以下のみです。

• AuthScheme をOAuth に設定し、
• OAuthAccessToken を取得して設定し、
• 必要な設定パラメータを設定します。

（OAuthAccessToken およびその他の設定パラメータを取得および設定する方法についての情報は、 「Yahoo! Ads への接続」のデスクトップ認証セクションを参照してください。）

ただし、Web 経由で接続するには、カスタムOAuth アプリケーションの作成が必要です。また、カスタムOAuth アプリケーションは、一般的に使用される3つの認証フローをすべてシームレスにサポートするため、これらの認証フロー用にカスタムOAuth アプリケーションを作成（独自のOAuth アプリケーションクレデンシャルを使用）することもできます。

カスタムOAuth アプリケーションは、次のような場合に有用です。

• 認証ダイアログのブランディングをコントロールしたいとき
• ユーザー認証後にアプリケーションがユーザーをリダイレクトするためのリダイレクトURI をコントロールしたいとき
• ユーザーからのリクエストに対する許可をカスタマイズしたいとき

プロシージャ

カスタムOAuth アプリケーションを登録してOAuth クライアントクレデンシャル、クライアントID、およびクライアントシークレットを取得するには：

1. Yahoo! 広告API 管理ツール に、Yahoo! 広告API の管理権限を持つYahoo! JAPAN ビジネスID でログインします。
2. アプリケーション一覧画面で登録アプリケーションをクリックします。
3. 登録アプリケーションの画面で登録ボタンをクリックします。
4. 必須フィールドをすべて入力します。
5. 新しいアプリケーションのリダイレクトURI を指定します。
   • デスクトップアプリケーションの場合は、コールバックURL を http://localhost:33333 か任意の別のポート番号に設定してください。
   • Web アプリケーションの場合は、コールバックURL をユーザーがアプリケーションを認可した後に表示したいWeb アプリケーションのページに設定してください。
6. 入力が完了したら、確認をクリックします。
7. 確認画面で内容に問題がないか確認します。問題がなければ、登録をクリックします。 入力したアプリケーションが一覧に表示され、登録が完了します。

新しいカスタムOAuth アプリケーションのクライアントID とクライアントシークレットが、登録プロセスで入力された情報とともに表示されます。あとで使用するためにOAutheClientId およびClientSecret を記録します。

このセクションでは、Yahoo! Ads Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。 このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。 カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

詳しくは、クエリ処理 を参照してください。

ログ

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

• ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
• ProxyPort：プロキシサーバーが起動しているTCP ポート。
• ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
• ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
• ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

DisplayAds API の使用

DisplayAds データモデルで利用可能なエンティティについては、DisplayAds データモデル を参照してください。

SearchAds API の使用

SearchAds データモデルで利用可能なエンティティについては、SearchAds データモデル を参照してください。

概要

このセクションでは、利用可能なAPI オブジェクトを示し、Yahoo! Ads API へのSQL の実行について詳しく説明します。

主要機能

• Sync App はドキュメント、フォルダ、およびグループなどのYahoo! Ads エンティティをリレーショナルビューとしてモデル化し、SQL を記述してYahoo! Ads データをクエリできるようにします。
• ストアドプロシージャを使用するとYahoo! Ads の操作を実行できます。
• これらのオブジェクトへのライブ接続により、Sync App を使用するとYahoo! Ads アカウントへのあらゆる変更が即座に反映されます。
• レポート：

  レポートは、一度作成すると変更ができないビューとして表示されます。ただし、従来のデータベースビューとは異なり、特定のテーブルですべてのメトリクスとディメンションを選択することはあまり役に立ちません。このためプロバイダーは、SELECT * クエリはデフォルトのメトリクスとディメンションのセットが要求されていると解釈します。これは、明示的にすべてのカラムを選択しているクエリにも適用されます。

  さらにYahoo! Ads API は、データに投影できるまたは返される結果を制限するために使用する、カラムの数や組み合わせを制限します。

Sync App はYahoo! Ads のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

Yahoo! Ads Connector for CData Sync テーブル

Create, Read, Update and Remove A/B test information.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• AbTestId supports the '=,IN'.

SELECT * FROM AbTest WHERE AccountId = '1002504155'

SELECT * FROM AbTest WHERE AccountId = '1002504155' AND AbTestId = '1000000651'

INSERT

Insert can be executed by specifying the AccountId, AbTestName, ACampaignId, BCampaignId, StartDate and EndDate 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 AbTest(AbTestName, ACampaignId, AccountId, BCampaignId, StartDate, EndDate) VALUES ('TestingName', 30825919, 1002504155, 30825917, '2023-04-19', '2023-04-21')

UPDATE

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

UPDATE AbTest SET AbTestName = 'TestingName2' WHERE AbTestId = '1000000643' AND AccountId = '1002504155'

DELETE

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

DELETE FROM AbTest WHERE AbTestId = '1000000643' AND AccountId = '1002504155'

Columns

Perform targeting settings operations for the ad group, including Get, Add, Set, Replace, and Remove.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• AdGroupId supports the '=,IN'.
• CampaignId supports the '=,IN'.
• TargetType supports the '=,IN'.

SELECT * FROM AdGroupTargets WHERE AccountId = '1002504155'

SELECT * FROM AdGroupTargets WHERE AccountId = '1002504155' AND AdGroupId IN ('437154455', '437154455')

SELECT * FROM AdGroupTargets WHERE AccountId = '1002504155' AND CampaignId = '30799754'

INSERT

Insert can be executed by specifying the AccountId, AdGroupId, CampaignId, AdScheduleTargetDayOfWeek, AdScheduleTargetStartHour, AdScheduleTargetEndHour and TargetType 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 AdGroupTargets (AccountId, AdGroupId, CampaignId, TargetType, AdScheduleTargetStartHour, AdScheduleTargetEndHour, AdScheduleTargetDayOfWeek) VALUES ('1002504155', '437154455', '30799754', 'AD_SCHEDULE_TARGET', '10', '12', 'MONDAY')

UPDATE

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

UPDATE AdGroupTargets SET BidMultiplier = '1.0', AgeTargetAge = 'GT_RANGE13_14'  WHERE AccountId = '1002504155' AND AdGroupId = '437154455' AND CampaignId = '30799754' AND TargetId = 'as010104'  AND TargetType = 'AD_SCHEDULE_TARGET'

DELETE

Delete can be executed by specifying the AccountId, AdGroupId, TargetId, CampaignId and TargetType in the WHERE Clause. For example:

DELETE FROM AdGroupTargets WHERE AccountId = '1002504155' AND AdGroupId = '437154455' AND CampaignId = '30799754' AND TargetId = 'as011012'  AND TargetType = 'AD_SCHEDULE_TARGET'

Columns

Manage the audience list for site retargeting by using Create, Read, Update, or Delete for entries.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• AudienceListId supports the '=,IN'.
• AudienceListType supports the '=,IN'.

For example:

SELECT * FROM AudienceLists WHERE AccountId = '1234339'
SELECT * FROM AudienceLists WHERE AccountId = '1234339' AND AudienceListId = '1003039071'
SELECT * FROM AudienceLists WHERE AccountId = '1234339' AND AudienceListId = '1003039071' AND AudienceListType = 'DEFAULT_LIST'

INSERT

Insert in AudienceLists can be done using temp tables.

INSERT INTO AudienceListContentWebsiteVisitorsAudienceListRulesRuleConditions#TEMP (CompareOperator, RuleType, Value) VALUES ('EQUAL', 'URL', 'Cdata.com');
INSERT INTO AudienceListContentWebsiteVisitorsAudienceListRules#TEMP (RuleConditions) VALUES (  AudienceListContentWebsiteVisitorsAudienceListRulesRuleConditions#TEMP);
INSERT INTO AudienceLists(AccountId, AudienceListType, AudienceListName, ContentWebsiteVisitorsAudienceListIsOpen, ContentWebsiteVisitorsAudienceListIsPreset, ContentWebsiteVisitorsAudienceListDataDuration, ContentWebsiteVisitorsAudienceListRules,ContentWebsiteVisitorsAudienceListRetargetingTagId) VALUES (100135346, 'WEBSITE_VISITORS', 'AudName', TRUE, FALSE, 7, AudienceListContentWebsiteVisitorsAudienceListRules#TEMP,'YWQ9T6KH22');

UPDATE

Update can be executed by specifying the AccountId, AudienceListId, AudienceListName AND AudienceListType in the WHERE Clause. For example:

UPDATE AudienceLists SET AudienceListName = 'UpdatingRetargetingListFour' WHERE AudienceListId = 1003411978 AND AccountId = 1002504155 AND AudienceListName = 'UpdatingRetargetingListThrice' AND AudienceListType = 'RULE'

DELETE

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

DELETE FROM AudienceLists WHERE AudienceListId = 1003411978 AND AccountId = 1002504155

Columns

Pseudo-Columns

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

Get the contents keyeord list

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• ContentsKeywordListId supports the '=,IN'.

For example:

SELECT * FROM ContentsKeywordLists WHERE AccountId = '1002504155'

SELECT * FROM ContentsKeywordLists WHERE ContentsKeywordListId = '1000010795'

INSERT

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)

UPADTE

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

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'

Columns

Get ConversionGroup information of specified account

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• ConversionGroupId supports the '='.
• ConversionGroupName supports the '='.
• ConversionTrackerId supports the '='.

For example:

SELECT * FROM ConversionGroups WHERE AccountId = '1002504155'

SELECT * FROM ConversionGroups WHERE ConversionGroupId = '1000010795'

SELECT * FROM ConversionGroups WHERE ConversionGroupName = 'test'

SELECT * FROM ConversionGroups WHERE ConversionTrackerId = '1000010795'

INSERT

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 DisplayAdsConversionGroupConversions#TEMP(conversionTrackerId, ConversionTrackerType, status) VALUES (1309357, WEB_CONVERSION, ENABLED)
INSERT INTO DisplayAdsConversionGroupConversions#TEMP(conversionTrackerId, ConversionTrackerType, status) VALUES (1309357, WEB_CONVERSION, ENABLED)
INSERT INTO ConversionGroups (ConversionGroupName, accountid, Conversions) VALUES ('testvivek', 1002504155, 'DisplayAdsConversionGroupConversions#TEMP')

UPADTE

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:

UPDATE ConversionGroups SET ConversionGroupName = 'NewTestLabeltest' WHERE AccountId = '1002504155' AND ConversionGroupId = '123456'

DELETE

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

DELETE FROM ConversionGroups WHERE AccountId = '1002504155' AND  ConversionGroupId = '123456'

Columns

Pseudo-Columns

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

Create, Update or Read account information. Restricted to some users

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '=,IN'.
• AccountStatus supports the '=,IN'.
• AccountType supports the '=,IN'.
• IncludeTestAccount supports the '='.

SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' AND AccountStatus = 'INPROGRESS'

SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' AND AccountType = 'PREPAY'

SELECT * FROM DisplayAdsAccountManagement WHERE AccountId = '1002504155' AND IncludeTestAccount = 'EXCLUDE_TEST'
	

INSERT

Insert can be executed by specifying the AccountName,AccountPaymentInvoiceBudgetAmount,AccountPaymentPaymentType,ClientBuilding,ClientCity,ClientCompanyName,ClientCompanyNameKana,ClientEnterpriseType,ClientPhoneNumber,ClientStreet1,ClientStreet2,ClientUrl,ClientUrlType,ClientZip,ClientType columns. The columns that are not read-only can be inserted optionally.

INSERT INTO DisplayAdsAccountManagement (AccountName,AccountPaymentInvoiceBudgetAmount,AccountPaymentPaymentType,ClientBuilding,ClientCity,ClientCompanyName,ClientCompanyNameKana,ClientEnterpriseType,ClientPhoneNumber,ClientStreet1,ClientStreet2,ClientUrl,ClientUrlType,ClientZip,ClientType ) VALUES ('test',1234,'PREPAY','cdata','blr','infosys','cd','GOMEI','98765-98765-98765','street1','street2','ClientUrl','PC','123-1234','AGENT');

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 DisplayAdsAccountManagement SET AccountName='TestAccount' WHERE AccountId='1002504155'

Columns

Pseudo-Columns

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

Read Or Update account information.

Table Specific Information

Select

The Sync App will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the Sync App.

• AccountId supports the '=,IN'.
• AccountName supports the '='.
• AccountStatus supports the '=,IN'.
• AccountType supports the '=,IN'.
• IncludeTestAccount supports the '='.
• IncludeManagerAccount supports the '='.

SELECT * FROM DisplayAdsAccounts WHERE AccountName = 'TestAccount'

SELECT * FROM DisplayAdsAccounts WHERE AccountStatus = 'SERVING'

SELECT * FROM DisplayAdsAccounts WHERE AccountType = 'PREPAY'

SELECT * FROM DisplayAdsAccounts WHERE IncludeTestAccount = 'ALL'

SELECT * FROM DisplayAdsAccounts WHERE IncludeManagerAccount = 'ALL'

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 DisplayAdsAccounts SET AccountName = 'TestAccount' WHERE AccountId = '1002504155'

Columns

Pseudo-Columns

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

Get Information related to account tracking.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.

For example:

SELECT * FROM DisplayAdsAccountTrackingUrl WHERE AccountId = '1002504155'

UPADTE

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 DisplayAdsAccountTrackingUrl SET AccountName = 'Test' WHERE Accountid = '1002504155'

Columns

Create, Read, Update or Delete ad information

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• AdGroupId supports the '=,IN'.
• AdId supports the '=,IN'.
• AdType supports the '=,IN'.
• MainMediaFormat supports the '=,IN'.
• ApprovalStatus supports the '=,IN'.
• CampaignId supports the '=,IN'.
• MediaId supports the '=,IN'.
• UserStatus supports the '=,IN'.
• CampaignGoalFilterType supports the '='.
• ContainsLabel supports the '='.
• LabelId supports the '=,IN'.
• StartDate supports the '='.
• EndDate supports the '='.

SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '125466'

SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '123436' AND AdId IN ('4561','6996')
     
SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '123436' AND ApprovalStatus IN ('APPROVED','APPROVED_WITH_REVIEW')

SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '123436' AND MediaId IN ('12644','325687') AND UserStatus IN ('ACTIVE', 'PAUSED')

SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '123436' AND CampaignGoalFilterType = 'ALL'

SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '123436' AND ContainsLabel = 'True' AND LabelId IN ('5697122')

SELECT * FROM DisplayAdsAdGroupAds WHERE AccountId = '123436' AND StartDate = '2021-06-03' AND EndDate = '2021-06-03'

INSERT

Insert can be executed by specifying the AccountId, AdGroupId, AdAdType, CampaignId and UserStatus 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 DisplayAdsAdGroupAds (AccountId, AdGroupId, AdType, TextAdDescription, TextAdDescription2, TextAdDisplayUrl, TextAdHeadline, Name, ApprovalStatus, CampaignId, UserStatus) values ('1002504155','437279778','TEXT_LONG_AD1','Test1','Test2','itunes.apple.com','TestHeadlines','TestName','REVIEW','30820477','ACTIVE')

UPDATE

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

UPDATE DisplayAdsAdGroupAds SET MediaId='10' WHERE AccountId = '1234' AND AdGroupId = '256' AND AdId = '562' AND CampaignId = '12533'

DELETE

Delete can be executed by specifying the AccountId, AdGroupId, AdId and CampaignId in the WHERE Clause. For example:

DELETE FROM DisplayAdsAdGroupAds WHERE AccountId = '1234' AND AdGroupId = '256' AND AdId = '562' AND CampaignId = '12533'

Columns

Pseudo-Columns

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

Manage the ad group by using the Create, Read, Update, or Delete operations.

Table Specific Information

Select

The Sync App 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 The rest of the filter is executed client side within the Sync App.

• AdGroupId supports the '=,IN'.
• AccountId supports the '='.
• CampaignId supports the '=,IN'.
• UserStatus supports the '=,IN'.
• CampaignGoalFilterType supports the '='.
• ContainsLabel supports the '='.
• LabelId supports the '=,IN'.
• StartDate supports the '='.
• EndDate supports the '='.

SELECT * FROM DisplayAdsAdGroups WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsAdGroups WHERE AccountId = '1002504155' AND AdGroupId = '437264177'

INSERT

Insert can be executed by specifying the AccountId, AdGroupId, AdType, Name, CampaignId, UserStatus 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 DisplayAdsAdGroups (AdGroupName, AccountId, CampaignId,device,UserStatus,DeviceApp,DeviceOs) values('Testgroup','1002504155','30799754','SMARTPHONE','ACTIVE','APP','ANDROID');

UPDATE

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

UPDATE DisplayAdsAdGroups SET AdGroupName = 'NewTest' WHERE AccountId = '1002504155' AND CampaignId = '30799754' AND AdGroupId = '437264190' AND UserStatus = 'ACTIVE'

DELETE

Delete can be executed by specifying the AccountId, AdGroupId, CampaignId, AdId and UserStatus in the WHERE Clause. For example:

DELETE FROM DisplayAdsAdGroups WHERE AccountId = '1002504155' AND CampaignId = '30799754' AND AdGroupId = '437264190' AND UserStatus = 'ACTIVE'

Columns

Pseudo-Columns

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

Create or Read the download result information of operation history data file.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• JobId supports the '=,IN'.
• JobStatus supports the '=,IN'.

SELECT * FROM DisplayAdsAuditLogs WHERE AccountId = '1002504155'


SELECT * FROM DisplayAdsAuditLogs WHERE AccountId = '1002504155' AND JobId = '4508692'

INSERT

Insert can be executed by specifying the AccountId 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 DisplayAdsAuditLogs (AccountId) VALUES ('1002504155')

Columns

Read or Update budget information for the account.

Table Specific Information

SELECT

The Sync App 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 Sync App.

• AccountId supports the '=,IN'.

SELECT * FROM DisplayAdsBudgets WHERE AccountId = '1234'

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 DisplayAdsBudgets SET AccountType = 'PREPAY' WHERE AccountId = '1234'

Columns

Create, Read, Update or Delete information related campaigns.

Table Specific Information

SELECT

The Sync App 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 Sync App.

• AccountId supports the '='.
• CampaignId supports the '=,IN'.
• EndDate supports the '='.
• FeedId supports the '=,IN'.
• StartDate supports the '='.
• UserStatus supports the '=,IN'.
• CampaignGoalFilterType supports the '='.
• CampaignType supports the '='.
• ContainsLabel supports the '='.
• LabelId supports the '=,IN'.
• UpdatedDate supports the '=,>,<,<=,>='.

SELECT * FROM DisplayAdsCampaigns WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsCampaigns WHERE AccountId = '1002504155' AND CampaignId = '30799754'

SELECT * FROM DisplayAdsCampaigns WHERE AccountId = '1002504155' AND LabelId = '1000158197'

Select * from DisplayAdsCampaigns where UpdatedDate>='2023-10-13'

INSERT

Insert can be executed by specifying the AccountId, BudgetAmount, BiddingStrategyType, CampaignGoal, CampaignName, UserStatus, CpcBiddingSchemeCpc and CpcBiddingSchemeEnhancedCpcEnabled 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 DisplayAdsCampaigns (AccountId, AppId, AppName, AppOsType, BudgetAmount, BiddingStrategyType, CampaignGoal, CampaignName, UserStatus, CpcBiddingSchemeCpc, CpcBiddingSchemeEnhancedCpcEnabled) VALUES ('1002504155', 'Test_214', 'TestApp', 'ANDROID', 1500000, 'CPC', 'APP_PROMOTION', 'TestCampaign2', 'ACTIVE', 800, 'TRUE')

UPDATE

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

UPDATE DisplayAdsCampaigns SET CampaignName = 'Test', BiddingStrategyType = 'MANUAL_CPC', BudgetAmount = '100' WHERE AccountId = '1002504155'AND CampaignId = '30799754'

DELETE

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

DELETE FROM DisplayAdsCampaigns WHERE AccountId = '1002504155' AND CampaignId = '30799754'

Columns

Pseudo-Columns

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

Create, Read or Update ConversionTracker information.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• AppConversionAppConversionPlatform supports the '='.
• AppConversionAppId supports the '=,IN'.
• Category supports the '=,IN'.
• ConversionTrackerId supports the '=,IN'.
• ConversionTrackerType supports the '=,IN'.
• CountingType supports the '='.
• ExcludeFromBidding supports the '='.
• Status supports the '=,IN'.
• StatsEndDate supports the '='.
• StatsStartDate supports the '='.
• StatsPeriod supports the '='.

SELECT * FROM DisplayAdsConversionTrackers WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsConversionTrackers WHERE AccountId = '1002504155' AND ConversionTrackerId = '1307071'

INSERT

Insert can be executed by specifying the AccountId, ConversionTrackerName, Status, Category, ConversionTrackerType, AppConversionPlatform 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 DisplayAdsConversionTrackers (AccountId, ConversionTrackerName, Status, Category, ConversionTrackerType, AppConversionPlatform) VALUES ('1002504155', 'vtest', 'ENABLED', 'DEFAULT', 'WEB_CONVERSION', 'ANDROID_MARKET')

UPDATE

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

UPDATE DisplayAdsConversionTrackers SET ConversionTrackerName = 'test' WHERE AccountId = '1002504155' AND ConversionTrackerId = '1307071'

Columns

Pseudo-Columns

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

Create, Read, Update or delete Feed information

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• FeedId supports the '=,IN'.

For example, the following queries are processed server side:

SELECT * FROM DisplayAdsFeeds WHERE AccountId = '1002504155'

SELECT * FROM DisplayAdsFeeds WHERE AccountId = '1002504155' AND FeedId = '1002504'

Insert

Insert can be executed by specifying the AccountId and FeedName 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 DisplayAdsFeeds (AccountId,FeedName) VALUES ('1002504155','Testfeed')

Update

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

UPDATE DisplayAdsFeeds SET FeedName = 'Testfeed' WHERE AccountId = '1002504155' AND FeedId = '1002504155'

Delete

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

DELETE FROM DisplayAdsFeeds WHERE AccountId = '1002504155' AND FeedId = '1002504155'

Columns

Create, Read, Update or Delete information of label.

Table Specific Information

SELECT

The Sync App 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 Sync App.Note: AccountId is required for select on this table.

• AccountId supports the '='.
• LabelId supports the '=,IN'.

For example:

SELECT * from DisplayAdsLabels WHERE AccountId = '1234'

SELECT * from DisplayAdsLabels WHERE AccountId = '1234' AND LabelId = '266841'

INSERT

Insert can be executed by specifying the AccountId and LabelName 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 DisplayAdsLabels (AccountId,LabelName) VALUES ('1234','New label') 

UPDATE

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

UPDATE DisplayAdsLabels SET Color='#FFFFFF' WHERE AccountId = '1002504155' AND LabelId = '266841'

DELETE

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

DELETE DisplayAdsLabels WHERE AccountId = '1234' AND LabelId = '266841'

Columns

Create, Read or Delete a Report.

Table Specific Information

SELECT

The Sync App 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 Sync App.

• ReportJobId supports the '=,IN'.
• ReportJobStatus supports the '=,IN'.
• AccountId supports the '='.

SELECT * from DisplayAdsReports WHERE AccountId = '1234'

INSERT

Insert can be executed by specifying the AccountId,Fields,ReportName 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 DisplayAdsReportReportTypeConditionCrossCampaignReachesReportConditionCrossCampaignIds#TEMP (CampaignId) VALUES ('1836679')
INSERT INTO DisplayAdsReports (AccountId,Fields,ReportDateRangeType,ReportName,CrossCampaignReachesReportConditionCrossCampaignType,CrossCampaignReachesReportConditionCrossCampaignIds) VALUES ('1002504155','ACCOUNT_ID,ACCOUNT_NAME,CAMPAIGN_ID,ADGROUP_ID,AD_ID','TODAY','MyAdReport','CAMPAIGN_ID','DisplayAdsReportReportTypeConditionCrossCampaignReachesReportConditionCrossCampaignIds#TEMP')

DELETE

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

DELETE DisplayAdsReports WHERE AccountId = '1234' AND ReportJobId = '266841'

Columns

Pseudo-Columns

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

Create, Read or Update FTP setting information.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• FeedId supports the '=,IN'.

For example, the following queries are processed server side:

SELECT * FROM FeedFtp WHERE AccountId = '123436'

Insert

Insert can be executed by specifying the AccountId, FeedId, FeedUrl, ScheduleScheduleDailyTime, ScheduleScheduleHourlyInterval, ScheduleScheduleType, ScheduleScheduleWeeklyScheduleWeek, ScheduleScheduleWeeklyTime, UserName and UserPassword columns. The columns that are not read-only can be inserted optionally.

INSERT INTO FeedFtp (AccountId, UserName, UserPassword, FeedId, FeedUrl, ItemListUploadType, ScheduleDailyTime, ScheduleHourlyInterval, ScheduleType, ScheduleWeeklyScheduleWeek, ScheduleWeeklyTime) VALUES ('123436', '1002504155', 'Admin', 'Admin', 1132453, 'www.feedftp.com', 'UPDATE_ALL', 500, 10, 'DAILY', 'SUN', '10')

Update

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

UPDATE FeedFtp SET UserName = 'Admin@123', UserPassword = 'password' WHERE AccountId = '1002504155' AND FeedId = '1132453'

Columns

Pseudo-Columns

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

Create, Read or delete Item Set information.

Table Specific Information

Select

The Sync App will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId, FeedId is required to make a request and the rest of the filter is executed client-side within the Sync App.

• AccountId supports the '='.
• FeedId supports the '='.
• FeedSetId supports the '=,IN'.
• IncludeItemCount supports the '='.

SELECT * FROM FeedSets WHERE AccountId = '1002504155' AND FeedId = '1132453'

INSERT

Insert can be executed by specifying the AccountId, FeedId, ConditionSets and FeedSetName 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 FeedSetConditionSetsOrCondition#TEMP (CompareOperator, Value) VALUES ('EQUAL', '10000')
INSERT INTO FeedSetConditionSets#TEMP (ConditionType, OrConditions) VALUES ('PRICE', 'FeedSetConditionSetsOrCondition#TEMP')
INSERT INTO FeedSets (AccountId, FeedId, ConditionSets, FeedSetName) VALUES ('1002504155', '1132453', 'FeedSetConditionSets#TEMP', 'TestFeedSet')

DELETE

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

DELETE FROM FeedSets WHERE AccountId = '1234' AND FeedSetId = '3573618' AND FeedId = '25644'

Columns

Pseudo-Columns

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

Read or Update guaranteed campaign.

Table Specific Information

SELECT

The Sync App 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 Sync App.

• AccountId supports the '='.
• CampaignId supports the '=,IN'.
• ContainsLabelIdFlg supports the '='.
• LabelId supports the '=,IN'.

For example:

SELECT * FROM GuaranteedCampaigns WHERE AccountId = '1002504155'

SELECT * FROM GuaranteedCampaigns WHERE AccountId = '1002504155' AND CampaignId = '1833923'

SELECT * FROM GuaranteedCampaigns WHERE AccountId = '1002504155' AND LabelId = '97108'

UPDATE

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

UPDATE GuaranteedCampaigns SET CampaignName = 'Test' WHERE AccountId = '1002504155' AND CampaignId = '1833923'

Columns

Pseudo-Columns

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

Create, Read, Update or delete the media submission.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• MediaId supports the '=,IN'.
• ApprovalStatus supports the '=,IN'.
• UserStatus supports the '=,IN'.
• StartDate supports the '='.
• EndDate supports the '='.

For example:

SELECT * FROM Media WHERE AccountId = '1002504155'

SELECT * FROM Media WHERE AccountId = '1002504155' AND MediaId = '12345'

SELECT * FROM Media WHERE AccountId = '1002504155' AND StartDate = '20210703'

SELECT * FROM Media WHERE AccountId = '1002504155' AND EndDate = '20210703'

INSERT

Insert can be executed by specifying the AccountId, MediaName, MediaTitle, UserStatus and ImageMediaData 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 Media (AccountId, MediaName, MediaTitle, UserStatus, ImageMediaData) VALUES ('1002504155', 'test.JPEG', 'vtest', 'ACTIVE', 'iVBORw0KGgoAAAANSUhEUgAAAcsAAABuCAMAAAB')

UPADTE

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

UPDATE Media SET MediaName = 'Test', ImageMediaAspectRatio = '10', ImageMediaData = 'iVBORw0KGgoAAAANSUhEUg', ImageMediaFileSize = '10', ImageMediaHeight = '100', ImageMediaMediaAdFormat = 'png', ImageMediaMediaFileType = 'GIF', ImageMediaMediaType = 'ANIMATION_IMAGE', ImageMediaWidth = '100' WHERE Accountid = '1002504155' AND MediaId = '123456'

DELETE

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

DELETE FROM Media WHERE  Accountid = '1002504155' AND MediaId = '123456'

Columns

Pseudo-Columns

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

Create, Read, Update or Delete the placement URL list.

Table Specific Information

SELECT

The Sync App 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 Sync App.

• AccountId supports the '='.
• UrlListId supports the '=,IN'.

For example:

SELECT * FROM PlacementUrlLists WHERE AccountId = '1002504155'

SELECT * FROM PlacementUrlLists WHERE AccountId = '1002504155' AND UrlListId = '1000908843'

INSERT

Insert can be executed by specifying the AccountId, UrlListName and Urls 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 DisplayAdsPlacementUrlListUrls#TEMP(PlacementUrl) VALUES ('cdata.com')
INSERT INTO PlacementUrlLists(AccountId, UrlListName, Urls) VALUES ('1002504155', 'Testurl', 'DisplayAdsPlacementUrlListUrls#TEMP')

UPDATE

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

INSERT INTO DisplayAdsPlacementUrlListUrls#TEMP(PlacementUrl) VALUES ('cdata.com');
UPDATE PlacementUrlLists SET UrlListName = 'Cdata' WHERE AccountId = '1002504155' AND UrlListId = '1000908844'

DELETE

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

DELETE FROM PlacementUrlLists  WHERE AccountId = '1002504155' AND UrlListId = '1000908844'

Columns

Pseudo-Columns

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

Create or Read site retargeting tag information.

Table Specific Information

SELECT

The Sync App 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 Sync App.

• AccountId supports the '='.

For example:

SELECT * FROM RetargetingTags WHERE AccountId = '1002504155'

INSERT

Insert can be executed by specifying the AccountId 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 RetargetingTags(AccountId) VALUES ('1002504155')

Columns

Read, add, update or delete the search keyword list.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• SearchKeywordListId supports the 'IN,='.

For example:

SELECT * FROM SearchKeywordList WHERE AccountId = '1002504155'

SELECT * FROM SearchKeywordList WHERE AccountId = '1002504155' AND SearchKeywordListId = '1002346070'

INSERT

Insert can be executed by specifying the AccountId, SearchKeyword and SearchKeywordListName 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 SearchKeywordListSearchKeywords#TEMP (SearchKeywordId) VALUES ('1000023142')
INSERT INTO SearchKeywordList(AccountId, SearchKeyword, SearchKeywordListName) VALUES ('1002504155', 'SearchKeywordListSearchKeywords#TEMP', 'test')

UPDATE

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

INSERT INTO SearchKeywordListSearchKeywords#TEMP (SearchKeywordId) VALUES ('1000023142')
UPDATE SearchKeywordList SET SearchKeywordListName = 'TestSearch', SearchKeyword = 'SearchKeywordListSearchKeywords#TEMP' WHERE AccountId = '1002504155' AND SearchKeywordListId = '1002346070'

DELETE

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

DELETE SearchKeywordList  WHERE AccountId = '1002504155' AND SearchKeywordListId = '1002346070'

Columns

Pseudo-Columns

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

Read, Update or Delete Video Ads.

Table Specific Information

Select

The Sync App 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 Sync App.

• AccountId supports the '='.
• MediaId supports the '=,IN'.
• ApprovalStatus supports the '=,IN'.
• ProcessStatus supports the '=,IN'.
• UserStatus supports the '='.
• StartDate supports the '='.
• EndDate supports the '='.

For example:

SELECT * FROM Videos WHERE AccountId = '1002504155';

SELECT * FROM Videos WHERE AccountId = '1002504155' AND MediaId = '123456'

SELECT * FROM Videos WHERE AccountId = '1002504155' AND StartDate = '20210703'

SELECT * FROM Videos WHERE AccountId = '1002504155' AND EndDate = '20210703'

UPDATE

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

UPDATE Videos SET VideoName = 'Testvideo' WHERE AccountId = '1002504155' AND MediaId = '123456'

DELETE

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

DELETE FROM Videos WHERE AccountId = '1002504155' AND MediaId = '123456'

Columns

Pseudo-Columns

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

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

Yahoo! Ads Connector for CData Sync ビュー