Shopify Connector
Documentation
Version: 2
Documentation

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 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

Input 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
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