Salsify
Salsify ELT connector for data replication
Salsify
Salsify ELT connector for data replication
Locating the API keys & Organisation ID
API Key
- Log into Salsify (https://app.salsify.com/users/sign_in)
- Click on your profile name -> My profile
- Click on API Access and then click on Show API Keys, you'll have your API key!
Organisation ID
After you login to Salsify, the organisation ID can be found in the URL.
In here the red underlined portion is the Organisation ID.
URL would resemble something like:
https://app.salsify.com/app/orgs/s-9693c0b9-550e-xxxx-xxxx-xxxxxxxx/products?content_locales [] =en-GB
The part in red is your Organisation ID.
Snapshot
Features |
Details |
Release Status |
Released |
Source API Version |
v1.0 |
Table Selection |
Yes |
Column Selection |
No |
Edit Integrations |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
API Key |
Replication Type |
Full Load |
Replication Key |
- |
Suggested Replication Frequency |
1 hr |
Salsify Tables
Source documentation: https://developers.salsify.com/reference
-
Product
Purpose: To get all your products and their related information.
Replication: Full Load
Replication Key: NA
Fields
Name |
Data Type |
ProductID |
STRING |
ProductName |
STRING |
Imagery_en_GB |
STRING |
Brand |
STRING |
BrandFamily |
STRING |
BrandManager |
STRING |
CartonCBM |
STRING |
CartonDimensionsHeight |
STRING |
CartonDimensionsLength |
STRING |
CartonDimensionsWidth |
STRING |
CartonsGrossWeight |
STRING |
CartonsPerPalletEuro |
STRING |
CartonsPerPalletStandard |
STRING |
CategoryL1Name |
STRING |
CategoryL2Name |
STRING |
CategoryL3Name |
STRING |
Composition |
STRING |
ControlledRestricted |
STRING |
DutyPercentageAU |
STRING |
DutyPercentageCA |
STRING |
DutyPercentageEU |
STRING |
DutyPercentageJP |
STRING |
DutyPercentageUK |
STRING |
DutyPercentageUS |
STRING |
HazardousDG |
STRING |
HsCodeAU |
STRING |
HsCodeCA |
STRING |
HsCodeEU |
STRING |
HsCodeJP |
STRING |
HsCodeUK |
STRING |
HsCodeUS |
STRING |
IndividualProductPackagingNW |
STRING |
IsAdultProduct |
STRING |
ItemHeight |
STRING |
ItemHeightUnit |
STRING |
ItemLength |
STRING |
ItemLengthUnit |
STRING |
ItemWeight |
STRING |
ItemWeightUnit |
STRING |
ItemWidth |
STRING |
ItemWidthUnit |
STRING |
MOQ |
STRING |
NonDomesticSuppliers |
STRING |
PackageHeight |
STRING |
PackageHeightUnit |
STRING |
PackageLength |
STRING |
PackageLengthUnit |
STRING |
-
Product Images
Purpose: To get all your product images along with product names.
Replication: Full Load
Replication Key: NA
Fields
Name |
Data Type |
salsify_id |
STRING |
salsify_name |
STRING |
salsify_url |
STRING |
salsify_source_url |
STRING |
salsify_asset_resource_type |
STRING |
salsify_asset_height |
INTEGER |
salsify_asset_width |
INTEGER |
salsify_asset_size |
INTEGER |
salsify_etag |
STRING |
salsify_created_at |
TIMESTAMP |
salsify_updated_at |
TIMESTAMP |
ProductID |
STRING |
salsify_asset_height_st |
STRING |
salsify_asset_width_st |
STRING |
salsify_asset_size_st |
STRING |
-
Attribute
Purpose: To get all your attributes related to all the products.
Replication: Full Load
Replication Key: NA
Fields
Name |
Data Type |
salsify_id |
STRING |
salsify_name |
STRING |
salsify_data_type |
STRING |
salsify_is_facetable |
STRING |
salsify_attribute_group |
STRING |
salsify_position |
STRING |
salsify_help_text |
STRING |
salsify_searchable |
STRING |
salsify_manage_permissions |
STRING |
salsify_read_permissions |
STRING |
salsify_type |
STRING |
salsify_formula |
STRING |
salsify_entity_types |
STRING |
salsify_localizable |
STRING |
salsify_entity_scope |
STRING |
-
Attribute Values
Purpose: To get all your attribute values for all the products.
Replication: Full Load
Replication Key: NA
Fields
Name |
Data Type |
salsify_id |
STRING |
salsify_name |
STRING |
salsify_attribute_id |
STRING |
salsify_parent_id |
STRING |
salsify_localized_name_de_DE |
STRING |
salsify_localized_name_en_GB |
STRING |
salsify_localized_name_en_US |
STRING |
salsify_localized_name_es_ES |
STRING |
salsify_localized_name_es_MX |
STRING |
salsify_localized_name_fr_FR |
STRING |
salsify_localized_name_it_IT |
STRING |
salsify_localized_name_ja_JP |
STRING |
salsify_localized_name_pl_PL |
STRING |
salsify_localized_name_sv_SE |
STRING |
