SSIS Components for Qoo10

Build 22.0.8397

GoodsOption

Retrieve and query information related ItemOption info.

Select

The {i will use the Qoo10 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.

  • ItemNo supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM GoodsOption WHERE ItemNo=621052282
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 error.

Insert

Required fields for an insert are ItemNo, Name, Value and Price. Optional: OptionCode.

INSERT INTO GoodsOption (ItemNo,Name,Value,Price) values ('624988017','test-92','p33',3)

Update

Qoo10 allows updates for the Price and Qty columns.

UPDATE GoodsOption SET Price = '200', OptionCode='FFJ4HFH8HS8H' WHERE ItemNo='624988017' AND OptionNo='Jacket:-:CDATA'

Columns

Name Type ReadOnly Description
ItemNo [KEY] String True

The item code of Qoo10.

OptionNo [KEY] String True

Code of the option.

Name String True

OptionName

Value String True

OptionValue

Price Decimal False

OptionPrice

OptionCode String False

OptionCode

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8397