Endpoint

Update a Location

Name

put_location

Description

Updates an existing location. [API reference]

Parameters

Parameter	Label	Required	Options	Description
Id	Location Id	YES		The ID of the location to be updated.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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
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`

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 a Location using API Source

Shopify

Update a Location

SSIS API Source - Read from table or endpoint

Update a Location using API Destination

Shopify

Update a Location

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Update a Location

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

SQL Server

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

Update a Location

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];