JDBC Driver for GMO MakeShop

Build 24.0.9062

Members

Retrieve and query information related to members.

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

  • MemberId, MemberNameKana columns support the = operator.
  • JoinDate column supports the >,>=,=,<=,< operators.
  • GetDeleted pseudo-column supports the = operator.

Ordering is supported for JoinDate. For example, the following queries are processed server side:

SELECT * FROM Members WHERE MemberId = 'MemberIdHere' AND JoinDate >= '2018-09-04 22:54:43+01:00' AND JoinDate <= '2018-09-04 23:54:43+01:00' ORDER BY JoinDate ASC

SELECT * FROM Members WHERE MemberNameKana = 'Firstname Lastname' AND JoinDate > '2018-09-04 22:54:43+01:00' AND JoinDate < '2018-09-04 23:54:43+01:00'  ORDER BY JoinDate DESC

SELECT * FROM Members WHERE JoinDate = '2018-09-04 23:54:43+01:00' AND GetDeleted = '1' 

Insert

All columns except JoinDate can be specified. MemberId, MemberName, MemberNameKana, Email, MemberPassword, HomePost, HomePrefecture, HomePrefectureCode, HomeAddress1, HomePhone are required for an insert.

INSERT INTO Members (MEmberId, MemberName, MemberNameKana, Email, MemberPassword, HomePost, HomePrefecture, HomePrefectureCode, HomeAddress1, HomePhone) VALUES ('mymemberid', 'the name', 'Firstname Lastname', '[email protected]', 'Passw0rd', '1508512', 'Prefecture', '13', 'Address here', '453-345') 

Update

All columns except JoinDate can be updated. MemberId is required in the criteria for an update.

UPDATE Members SET MemberName = 'updName' WHERE MemberId = 'MemberIdHere'  

Delete

A member can be deleted by specifying MemberId.

DELETE FROM Members WHERE MemberId = 'MemberIdHere'  

Columns

Name Type ReadOnly Description
MemberId [KEY] String False

Member ID.

MemberName String False

Member name.

MemberNameKana String False

Member name phonetic.

JoinDate Date True

Date of registration.

GroupId Integer False

Member group ID.

GroupName String False

Member group name.

Email String False

Member email address.

MemberPassword String False

Member password - specified on an Insert.

EmailMagazineReceive String False

Indicator whether to receive mail magazine - Y: Wish to distribute e-mail newsletter, N: I do not wish to deliver e-mail newsletters.

使用できる値は次のとおりです。Y, N

Sex Integer False

Member gender - 0: Male 1: Female.

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

Birthday Date False

Member birthday.

MemberPoint Integer False

Store shop points owned by members.

MemberPointExpireDate Date False

Owned shop point expiration date.

RecommendMemberId String False

Store introducer's member ID.

HomePost String False

Home zip code.

HomePrefectureCode String False

Home prefecture code.

HomePrefecture String False

Home prefecture name.

HomeAddress1 String False

Home address.

HomeAddress2 String False

Other address.

HomePhone String False

Home phone number.

HomeFax String False

Home fax number.

MobilePhone String False

Mobile phone number.

MobileEmail String False

Mobile email address.

OfficeName String False

Company name.

OfficeNameKana String False

Company name phonetic.

OfficeDepartment String False

Company department.

OfficePost String False

Company zip code.

OfficePrefectureCode String False

Company prefecture code.

OfficePrefecture String False

Company prefecture name.

OfficeAddress String False

Company address.

OfficePhone String False

Company phone number.

AdditionalOption1 String False

Additional input item 1.

AdditionalOption2 String False

Additional input item 2.

AdditionalOption3 String False

Additional input item 3.

AdditionalOption4 String False

Additional input item 4.

AdditionalOption5 String False

Additional input item 5.

AdditionalOption6 String False

Additional input item 6.

AdditionalOption7 String False

Additional input item 7.

LoginEmail String False

Mail address authentication setting - Y: allow member login with e-mail address N: do not allow member login with e-mail address.

Memo String False

Member information memo.

使用できる値は次のとおりです。Y, N

Pseudo-Columns

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

Name Type Description
GetDeleted Integer

Specify this as 1 to acquire deleted members. Defaults to 0 and deleted members will not be retrieved.

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

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