Shopify Connector
Documentation
Version: 2
Documentation
Endpoint

Get Locations


Name

get_locations

Description

Gets a list of locations. [API reference]

Related Tables

Locations

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_I8 bigint False
Name DT_WSTR nvarchar(255) 255 False
Active DT_BOOL bit False
Address1 DT_WSTR nvarchar(255) 255 False
Address2 DT_WSTR nvarchar(255) 255 False
City DT_WSTR nvarchar(255) 255 False
Province DT_WSTR nvarchar(255) 255 False
Zip DT_WSTR nvarchar(255) 255 False
Country DT_WSTR nvarchar(255) 255 False
Phone DT_WSTR nvarchar(255) 255 False
ProvinceCode DT_WSTR nvarchar(255) 255 False
CountryCode DT_WSTR nvarchar(255) 255 False
CountryName DT_WSTR nvarchar(255) 255 False
LocalizedProvinceName DT_WSTR nvarchar(255) 255 False
LocalizedCountryName DT_WSTR nvarchar(255) 255 False
Legacy DT_BOOL bit False
CreatedAt DT_DBTIMESTAMP datetime False
UpdatedAt DT_DBTIMESTAMP datetime False
If the column you are looking for is missing, consider customizing Shopify Connector.

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:

Read from Locations table using API Destination

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

Shopify
Locations
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get locations

SELECT * FROM get_locations

get_locations endpoint belongs to Locations table(s), and can therefore be used via those table(s).

SQL Server

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

Get locations

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

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

get_locations endpoint belongs to Locations table(s), and can therefore be used via those table(s).