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