EndPoint Update a Customer

Name

put_customer

Description

Updates an existing customer. [API reference]

Parameters

Parameter	Label	Required	Options	Description
Id	Customer Id	YES		The ID of the customer to be updated.

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
Id	`DT_I8`	`bigint`		`False`
FirstName	`DT_WSTR`	`nvarchar(255)`	255	`False`
LastName	`DT_WSTR`	`nvarchar(255)`	255	`False`
Email	`DT_WSTR`	`nvarchar(255)`	255	`False`
Phone	`DT_WSTR`	`nvarchar(30)`	30	`False`
Password	`DT_WSTR`	`nvarchar(255)`	255	`False`
PasswordConfirmation	`DT_WSTR`	`nvarchar(255)`	255	`False`
SendWelcomeEmail	`DT_BOOL`	`bit`		`False`
MultipassIdentifier	`DT_WSTR`	`nvarchar(255)`	255	`False`
Note	`DT_NTEXT`	`nvarchar(MAX)`		`False`
Tags	`DT_NTEXT`	`nvarchar(MAX)`		`False`
TaxExempt	`DT_BOOL`	`bit`		`False`
TaxExemptions	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
DefaultAddressFirstName	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressLastName	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressCompany	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressLine1	`DT_WSTR`	`nvarchar(255)`	255	`False`
DefaultAddressLine2	`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`

Required columns that you need to supply are bolded.

Examples

SSIS

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

Update rows in Customers table using API Destination

This EndPoint belongs to Customers table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Shopify

Customers

Update