EndPoint Get Customers
Name
get_customers
Description
Gets a list of customers.
Parameters
Output Columns
Label | DataType | Length | Raw | Description |
---|---|---|---|---|
Id | DT_I8 | 0 | False | |
DT_WSTR | 255 | False | ||
AcceptsMarketing | DT_BOOL | 0 | False | |
CreatedAt | DT_DBTIMESTAMP | 0 | False | |
UpdatedAt | DT_DBTIMESTAMP | 0 | False | |
FirstName | DT_WSTR | 255 | False | |
LastName | DT_WSTR | 255 | False | |
OrdersCount | DT_I4 | 0 | False | |
State | DT_WSTR | 255 | False | |
TotalSpent | DT_WSTR | 50 | False | |
LastOrderId | DT_I8 | 0 | False | |
Note | DT_WSTR | 4000 | False | |
VerifiedEmail | DT_BOOL | 0 | False | |
MultipassIdentifier | DT_WSTR | 255 | False | |
TaxExempt | DT_BOOL | 0 | False | |
TaxExemptions | DT_WSTR | 4000 | True | |
Tags | DT_WSTR | 4000 | False | |
LastOrderName | DT_WSTR | 255 | False | |
Currency | DT_WSTR | 20 | False | |
Phone | DT_WSTR | 30 | False | |
AcceptsMarketingUpdatedAt | DT_DBTIMESTAMP | 0 | False | |
MarketingOptInLevel | DT_WSTR | 255 | False | |
SMSMarketingConsent | DT_WSTR | 255 | False | |
AdminGraphQLApiId | DT_WSTR | 255 | False | |
DefaultAddressId | DT_WSTR | 255 | False | |
DefaultAddressCustomerId | DT_WSTR | 255 | False | |
DefaultAddressFirstName | DT_WSTR | 255 | False | |
DefaultAddressLastName | DT_WSTR | 255 | False | |
DefaultAddressCompany | DT_WSTR | 255 | False | |
DefaultAddressAddress1 | DT_WSTR | 255 | False | |
DefaultAddressAddress2 | DT_WSTR | 255 | False | |
DefaultAddressCity | DT_WSTR | 255 | False | |
DefaultAddressProvince | DT_WSTR | 255 | False | |
DefaultAddressCountry | DT_WSTR | 255 | False | |
DefaultAddressZip | DT_WSTR | 255 | False | |
DefaultAddressPhone | DT_WSTR | 255 | False | |
DefaultAddressName | DT_WSTR | 255 | False | |
DefaultAddressProvinceCode | DT_WSTR | 255 | False | |
DefaultAddressCountryCode | DT_WSTR | 255 | False | |
DefaultAddressCountryName | DT_WSTR | 255 | False | |
EmailMarketingConsentState | DT_WSTR | 255 | False | |
EmailMarketingConsentOptInLevel | DT_WSTR | 255 | False | |
EmailMarketingConsentUpdatedAt | DT_DBTIMESTAMP | 0 | False |
Input Columns
Label | DataType | Length | Raw | Description |
---|---|---|---|---|
CustomerId | DT_I8 | 0 | False |