Endpoint Get Customers

Name

get_customers

Description

Gets a list of customers. [API reference]

Related Tables

Customers

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Shopify Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Customers table, therefore it is better to use it, instead of accessing the endpoint directly:

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

Customers

Optional Parameters
Customer Id(s) - Comma separated

API Destination

This Endpoint belongs to the Customers table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get customers:

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

Customers

Select, Lookup

Optional Parameters
Customer Id(s) - Comma separated

ODBC application

Use these SQL queries in your ODBC application data source:

Get list of customers

SELECT * FROM Customers

Get multiple specific customers by their IDs

SELECT * FROM Customers
WITH (ids='1111111111111,2222222222222,3333333333333')

Get a specific customer by its ID

SELECT * FROM Customers Where Id=12345

SQL Server

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

Get list of customers

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

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Get multiple specific customers by their IDs

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Customers
WITH (ids=''1111111111111,2222222222222,3333333333333'')';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

Get a specific customer by its ID

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Customers Where Id=12345';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];