Customers

Returns data from Customers table.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Unique numeric ID of this customer.
Company	String	False	The name of the company for which the customer works.
FirstName	String	False	First name of the customer.
LastName	String	False	Last name of the customer.
Email	String	False	Email address of the customer.
Phone	String	False	Phone number of the customer.
DateCreated	Datetime	True	Date on which the customer registered from the storefront or was created in the control panel.
DateModified	Datetime	True	The date on which the customer was modified.
CustomerGroup	Integer	False	The group to which the customer belongs.
Notes	String	False	Store Owner notes on the customer.
TaxExemptCategory	String	False	Used to identify customers who fall into special sales-tax categories.
StoreCreditAmounts	String	False	Amount of Store Credit
RegistrationIpAddress	String	False	The IP address from which this customer was registered.
AcceptsProductReviewAbandonedCartEmails	Boolean	True	Determines if the customer is signed up to receive either product review or abandoned cart emails or receive both emails.
ForcePasswordReset	Boolean	True	If true,this customer will be forced to change password on next login.