SSIS Components for Yahoo Shopping

Build 20.0.7587

Categories

Retrieve the list of store categories.

Select

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.

Columns

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.7587