JDBC Driver for GMO MakeShop

Build 23.0.8839

ProductOptionItems

Returns data related to item selection options for product.

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 本製品.

  • BrandCode column supports the = operator.
For example, the following queries are processed server side:
SELECT * FROM ProductOptionItems WHERE BrandCode = 'CD12345'

Columns

Name Type Description
BrandCode [KEY] String System product code.
OptionNumber String Option item number (Option item 1 or 2).
ItemId [KEY] Integer Selection item ID.
ItemName String Selection item name.
Default String Indicator if option item is initial selection - Y: Selected in initial display N: Not selected in initial display.

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