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.

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

Edit Integrations

Yes

Replication Type Selection

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

PreviousRelease Notes NextRelease Notes

Last updated 1 year ago