SSIS Components for Yahoo Shopping

Build 20.0.7656


Retrieve the list of store categories.


The {i will use the Yahoo Shopping API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the {i.

  • PageKey and SellerId support the = operator.
For example, the following queries are processed server side:
SELECT * FROM Categories WHERE PageKey = 'key' 
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an unfiltered data to be pushed.


Name Type References Description
PageKey [KEY] String Product code.
SellerId String Seller ID.
Name String The name of the product.
HiddenPageFlag Integer Hidden page flag. 0: normal page, 1: hidden page.
SortOrder String Child store category display order within designated store category.
EditingFlag Integer Edit flag. 0: Reflected, 1: State not reflected at the front after being edited.
UpdateTime Datetime Update date.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656