Reference

Endpoint Get Customer

Name

get_customer

Description

Gets a specific customer. [API reference]

Parameters

Parameter Required Options
Name: Id

Label: Customer Id

The ID of the customer for which data should be read. 		YES
Name: fields

Label: Only Fields to Show

Limit data retrieval to only the selected customer-related fields.
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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_I8 bigint
Email DT_WSTR nvarchar(255) 255
AcceptsMarketing DT_BOOL bit
CreatedAt DT_DBTIMESTAMP datetime
UpdatedAt DT_DBTIMESTAMP datetime
FirstName DT_WSTR nvarchar(255) 255
LastName DT_WSTR nvarchar(255) 255
OrdersCount DT_I4 int
State DT_WSTR nvarchar(255) 255
TotalSpent DT_WSTR nvarchar(50) 50
LastOrderId DT_I8 bigint
Note DT_WSTR nvarchar(4000) 4000
VerifiedEmail DT_BOOL bit
MultipassIdentifier DT_WSTR nvarchar(255) 255
TaxExempt DT_BOOL bit
TaxExemptions DT_WSTR nvarchar(4000) 4000
Tags DT_WSTR nvarchar(4000) 4000
LastOrderName DT_WSTR nvarchar(255) 255
Currency DT_WSTR nvarchar(20) 20
Phone DT_WSTR nvarchar(30) 30
AcceptsMarketingUpdatedAt DT_DBTIMESTAMP datetime
MarketingOptInLevel DT_WSTR nvarchar(255) 255
SMSMarketingConsent DT_WSTR nvarchar(255) 255
AdminGraphQLApiId DT_WSTR nvarchar(255) 255
DefaultAddressId DT_WSTR nvarchar(255) 255
DefaultAddressCustomerId DT_WSTR nvarchar(255) 255
DefaultAddressFirstName DT_WSTR nvarchar(255) 255
DefaultAddressLastName DT_WSTR nvarchar(255) 255
DefaultAddressCompany DT_WSTR nvarchar(255) 255
DefaultAddressAddress1 DT_WSTR nvarchar(255) 255
DefaultAddressAddress2 DT_WSTR nvarchar(255) 255
DefaultAddressCity DT_WSTR nvarchar(255) 255
DefaultAddressProvince DT_WSTR nvarchar(255) 255
DefaultAddressCountry DT_WSTR nvarchar(255) 255
DefaultAddressZip DT_WSTR nvarchar(255) 255
DefaultAddressPhone DT_WSTR nvarchar(255) 255
DefaultAddressName DT_WSTR nvarchar(255) 255
DefaultAddressProvinceCode DT_WSTR nvarchar(255) 255
DefaultAddressCountryCode DT_WSTR nvarchar(255) 255
DefaultAddressCountryName DT_WSTR nvarchar(255) 255
EmailMarketingConsentState DT_WSTR nvarchar(255) 255
EmailMarketingConsentOptInLevel DT_WSTR nvarchar(255) 255
EmailMarketingConsentUpdatedAt DT_DBTIMESTAMP datetime
If the column you are looking for is missing, consider customizing Shopify Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
Get Customer
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Shopify
Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Shopify
Get Customer
There are no parameters to configure.
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get customer 

SELECT * FROM get_customer

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get customer 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_customer';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];