SSIS Components for Yahoo! Ads

Build 24.0.9062

FeedSetConditionSets

Retrieve the details of Conditions of Item Set information. The columns values set read-only false can be inserted in the parent table using Temp tables.

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,FeedId is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • AccountId supports the '='.
  • FeedId supports the '='.
  • FeedSetId supports the '=,IN'.
  • IncludeItemCount supports the '='.
For example:
SELECT * FROM FeedSetConditionSets WHERE AccountId = '1002504155' AND FeedId = '1132453'

Columns

Name Type References Description
AccountId Int64

DisplayAdsAccounts.AccountId

Account ID.
FeedSetId Int64 Item Set ID.
FeedId Int64

DisplayAdsFeeds.FeedId

Feed ID.
ConditionType String Type of items available for condition of Item Set.

使用できる値は次のとおりです。CATEGORY_ID, STOCK_QUANTITY, PRICE, SALE_PRICE, RATING, REVIEWS, BADGE, AGE_GROUP, AVAILABILITY_DATE, GENDER_GROUP, GOOGLE_PRODUCT_CATEGORY, LOCATION, SALES_RANK, UNKNOWN

OrConditions String Conditional retrieval of feedset information.
IncludeItemCount Boolean number of items of Item Set.

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