EndPoint Get Customer

Name

get_customer

Description

Gets a specific customer. [API reference]

Parameters

Parameter

Label

Required

Options

Description

Customer Id

YES

The ID of the customer for which data should be read.

fields

Only Fields to Show

Option	Value
id	id
email	email
accepts_marketing	accepts_marketing
created_at	created_at
updated_at	updated_at
first_name	first_name
last_name	last_name
orders_count	orders_count
state	state
total_spent	total_spent
last_order_id	last_order_id
note	note
verified_email	verified_email
multipass_identifier	multipass_identifier
tax_exempt	tax_exempt
tags	tags
last_order_name	last_order_name
currency	currency
phone	phone
accepts_marketing_updated_at	accepts_marketing_updated_at
marketing_opt_in_level	marketing_opt_in_level
sms_marketing_consent	sms_marketing_consent
admin_graphql_api_id	admin_graphql_api_id

Limit data retrieval to only the selected customer-related fields.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I8`	`bigint`		`False`
Email	`DT_WSTR`	`nvarchar(255)`	255	`False`
AcceptsMarketing	`DT_BOOL`	`bit`		`False`
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
UpdatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
FirstName	`DT_WSTR`	`nvarchar(255)`	255	`False`
LastName	`DT_WSTR`	`nvarchar(255)`	255	`False`
OrdersCount	`DT_I4`	`int`		`False`
State	`DT_WSTR`	`nvarchar(255)`	255	`False`
TotalSpent	`DT_WSTR`	`nvarchar(50)`	50	`False`
LastOrderId	`DT_I8`	`bigint`		`False`
Note	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
VerifiedEmail	`DT_BOOL`	`bit`		`False`
MultipassIdentifier	`DT_WSTR`	`nvarchar(255)`	255	`False`
TaxExempt	`DT_BOOL`	`bit`		`False`
TaxExemptions	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
Tags	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
LastOrderName	`DT_WSTR`	`nvarchar(255)`	255	`False`
Currency	`DT_WSTR`	`nvarchar(20)`	20	`False`
Phone	`DT_WSTR`	`nvarchar(30)`	30	`False`
AcceptsMarketingUpdatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
MarketingOptInLevel	`DT_WSTR`	`nvarchar(255)`	255	`False`
SMSMarketingConsent	`DT_WSTR`	`nvarchar(255)`	255	`False`
AdminGraphQLApiId	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressId	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCustomerId	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressFirstName	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressLastName	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCompany	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressAddress1	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressAddress2	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCity	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressProvince	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCountry	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressZip	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressPhone	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressName	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressProvinceCode	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCountryCode	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCountryName	`DT_WSTR`	`nvarchar(255)`	255	`False`
EmailMarketingConsentState	`DT_WSTR`	`nvarchar(255)`	255	`False`
EmailMarketingConsentOptInLevel	`DT_WSTR`	`nvarchar(255)`	255	`False`
EmailMarketingConsentUpdatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:

Get Customer using API Source

Shopify

Get Customer

SSIS API Source - Read from table or endpoint

Get Customer using API Destination

Shopify

Get Customer