SSIS Components for Qoo10

Build 22.0.8397

ShippingInfo

Returns data regarding shipping info. ShippingStatus column is required to be specified for this view.

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.

  • ShippingStatus supports the '=' operator.
  • SearchCondition supports the '=' operator.
  • Date supports the '=', '<' and '>' operators.
For example, the following query is processed server side:
SELECT * FROM ShippingInfo WHERE ShippingStatus = '1'
SELECT * FROM ShippingInfo WHERE ShippingStatus = '3' AND SearchCondition = '2' AND Date > '2017-04-24' AND Date < '2019-04-23'
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.

Columns

Name Type Description
ShippingStatus String Status of the shipping. 1 : Waiting for Shipping 2 : Request Shipping 3 : Check Order.
SellerID String Id of the seller.
OrderNo [KEY] String Code of the order.
DeliveredDate Datetime Date of the delivery.
SellerItemCode String The code of seller.
SellerDiscount Decimal The code of seller.
ItemTitle String Title of the item.
ShippingCountry String Country specified for shipping.
EstShippingDate Datetime Est Shipping date.
ShippingDate Datetime Shipping date.
ZipCode String ZipCode.
ShippingAddr String Shipping address.
Addr1 String First address.
Addr2 String Second address.
HopeDate String Hope date.
ShippingWay String ShippingWay.
ShippingMsg String Message of the shipping.
ShippingRate Decimal Rate of the shipping.
ShippingRateType String Rate type of the shipping.
SellerDeliveryNo String Number of the delivery.
DeliveryCompany String Delivery company.
TrackingNo String Invoice number.
Gift String Gift.
BranchName String Branch name.
PickupAddress String Pickup address.
PickupzipCode String Pick up zip code.
SearchCondition String Inquiry Date Type. 1: (Order date), 2:(Payment date), 3 :(Shipping date), 4 :(Delivered date). Default :1.
Date Date Date range.

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