Endpoint Update a Location
Name
put_location
Description
Updates an existing location. [API reference]
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: Location Id The ID of the location to be updated. |
YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_I8
|
bigint
|
||
| Name |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Active |
DT_BOOL
|
bit
|
||
| Address1 |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Address2 |
DT_WSTR
|
nvarchar(255)
|
255 | |
| City |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Province |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Zip |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Country |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Phone |
DT_WSTR
|
nvarchar(255)
|
255 | |
| ProvinceCode |
DT_WSTR
|
nvarchar(255)
|
255 | |
| CountryCode |
DT_WSTR
|
nvarchar(255)
|
255 | |
| CountryName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| LocalizedProvinceName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| LocalizedCountryName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Legacy |
DT_BOOL
|
bit
|
||
| CreatedAt |
DT_DBTIMESTAMP
|
datetime
|
||
| UpdatedAt |
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 |
|---|---|---|---|---|
| Id |
DT_I8
|
bigint
|
||
| Name |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Active |
DT_BOOL
|
bit
|
||
| Address1 |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Address2 |
DT_WSTR
|
nvarchar(255)
|
255 | |
| City |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Province |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Zip |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Country |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Phone |
DT_WSTR
|
nvarchar(255)
|
255 | |
| ProvinceCode |
DT_WSTR
|
nvarchar(255)
|
255 | |
| CountryCode |
DT_WSTR
|
nvarchar(255)
|
255 | |
| CountryName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| LocalizedProvinceName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| LocalizedCountryName |
DT_WSTR
|
nvarchar(255)
|
255 |
Required columns that you need to supply are bolded.
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
Update a Location
| There are no parameters to configure. |
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
Update a Location
| There are no parameters to configure. |
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];