Salsify

Salsify ELT connector for data replication

Locating the API keys & Organisation ID

API Key

1. Log into Salsify (https://app.salsify.com/users/sign_in)

2. Click on your profile name -> My profile

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

The portion in red underline.

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

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

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

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

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