JDBC Driver for GMO MakeShop

Build 24.0.9062

OrderLineItems

Returns data regarding order details.

Select

The 本製品 will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • OrderNumber column supports the = operator.
  • Date column supports the >,>=,=,<=,< operators. When no column filters are specified, we will default to retrieving information related to orders from the last 6 months.
  • Canceled pseudo-column supports the = operator.
For example, the following queries are processed server side:
SELECT * FROM OrderLineItems WHERE OrderNumber = 'ORD12345' AND Date >= '2018-09-04 22:54:43+01:00' AND Date <= '2018-09-04 23:54:43+01:00' 

SELECT * FROM OrderLineItems WHERE Date > '2018-09-04 22:54:43+01:00' AND Date < '2018-09-04 23:54:43+01:00' 

SELECT * FROM OrderLineItems WHERE Date = '2018-09-04 23:54:43+01:00' AND Canceled = 1 

Columns

Name Type Description
OrderNumber [KEY] String Order number.
Date Datetime Order date.
BrandCode [KEY] String System product code.
OriginalCode String Original product code.
Name String Product name.
JanCode String JAN code.
DiscountRate Integer Discount percentage.
Price Integer Product price.
ShopPoints Integer Shop use points.
GMOPoints Integer GMO use points.
YahooPoints Integer Yahoo use points.
Amount Integer Order quantity.
ConsumptionTaxRate Integer Sales tax rate.
Option String Product option names.
OriginalOptionCode String Original option code.
NameOptions String Item name options.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Canceled Integer Specify this as 1 to acquire cancelled orders. Defaults to 0 and cancelled orders will not be retrieved.

使用できる値は次のとおりです。0, 1

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