RCG Salsify Products System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| create-salsify-products | Slasify create product request mapping |
| get-salsify-product-response | Slasify get product response mapping |
| get-salsify-products-list-response | Slasify get products list response mapping |
| update-salsify-product | Slasify update product request mapping |
create-salsify-products
Slasify create product request mapping
Source:
./src/main/resources/dwl/create-salsify-products.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
| Salsify | CIM | Description | |
|---|---|---|---|
| id | Product ID | The Product Id | |
| Product Name | name | The product name | |
| type | type | The Product type | |
| Cat_id | productCatalog.'name' | The Product catalog name | |
| Category | productCategory.'name' | The Product Category name | |
| productSKU | productId | The product Id | |
| brand | brand | The product brand | |
| externalIdType | externalIdType | The MDM unique Id | |
| apiName | auditInfo.createdBy | Identifies the system or user which created the entity | |
| createdStamp | auditInfo.createdDate | Timestamp of when the entity was created | |
| apiName | auditInfo.updatedBy | Identifies the system or user which last updated the entity | |
| lastUpdatedStamp | auditInfo.updatedDate | Timestamp of when the entity was last updated | |
| Feature Bullets | description++longDescription | Product tags | |
| Consolidated Feature Bullets | description | The Product Description | |
| Description | longDescription | The product description | |
| size | The ProductSize | The Product Size |
get-salsify-product-response
Slasify get product response mapping
Source:
./src/main/resources/dwl/get-salsify-product-response.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
| CIM | Salsify | Description |
|---|---|---|
| id | externalId | The Mdm Id |
| name | productName | The product name |
| longDescription | longDescription | Detailed product description |
| description | description | Brief product description |
| productSKU | productId | The product Id |
| brand | brand | The product brand |
| productCategory | ProductCategory | The product category Object |
| id | productCategoryId | default to null |
| name | productCategoryName | The Category Name |
| activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
| productCatalog | productCatalog | The product Catalog Object |
| id | productCatalogId | Id value default to null |
| name | productCatalogName | The Catalog Name |
| activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
| priceBookEntry | priceBookEntry | The Price Book Object |
| id | priceBookId | Id value default to null |
| unitListPrice | fixedAmount | The product fixed price |
| isActive | true | default to true |
| masterProduct | isVariant | Is it the master product |
| externalId | externalId | A unique identifier assigned to the product in another system |
| externalIdType | externalIdType | The MDM unique Id |
| auditInfo.createdBy | apiName | Identifies the system or user which created the entity |
| auditInfo.createdDate | createdStamp | Timestamp of when the entity was created |
| auditInfo.updatedBy | apiName | Identifies the system or user which last updated the entity |
| auditInfo.updatedDate | lastUpdatedStamp | Timestamp of when the entity was last updated |
| primaryProductCategory | primaryProductCategoryId | Product Category |
get-salsify-products-list-response
Slasify get products list response mapping
Source:
./src/main/resources/dwl/get-salsify-products-list-response.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
| CIM | Salsify | Description |
|---|---|---|
| id | externalId | The Mdm Id |
| name | productName | The product name |
| longDescription | longDescription | Detailed product description |
| description | description | Brief product description |
| productSKU | productId | The product Id |
| brand | brand | The product brand |
| productCategory | ProductCategory | The product category Object |
| id | productCategoryId | default to null |
| name | productCategoryName | The Category Name |
| activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
| productCatalog | productCatalog | The product Catalog Object |
| id | productCatalogId | Id value default to null |
| name | productCatalogName | The Catalog Name |
| activeFromDate | todays date | default to todays date format "yyyy-MM-dd" |
| priceBookEntry | priceBookEntry | The Price Book Object |
| id | priceBookId | Id value default to null |
| unitListPrice | fixedAmount | The product fixed price |
| isActive | true | default to true |
| masterProduct | isVariant | Is it the master product |
| externalId | externalId | A unique identifier assigned to the product in another system |
| externalIdType | externalIdType | The MDM unique Id |
| auditInfo.createdBy | apiName | Identifies the system or user which created the entity |
| auditInfo.createdDate | createdStamp | Timestamp of when the entity was created |
| auditInfo.updatedBy | apiName | Identifies the system or user which last updated the entity |
| auditInfo.updatedDate | lastUpdatedStamp | Timestamp of when the entity was last updated |
| primaryProductCategory | primaryProductCategoryId | Product Category |
update-salsify-product
Slasify update product request mapping
Source:
./src/main/resources/dwl/update-salsify-product.dwl
Mapping Tables
Maps Salsify Product to CIM Product format
| Salsify | CIM | Description | |
|---|---|---|---|
| id | Product ID | The Product Id | |
| Product Name | name | The product name | |
| type | type | The Product type | |
| Cat_id | productCatalog.'name' | The Product catalog name | |
| Category | productCategory.'name' | The Product Category name | |
| productSKU | productId | The product Id | |
| brand | brand | The product brand | |
| externalIdType | externalIdType | The MDM unique Id | |
| apiName | auditInfo.createdBy | Identifies the system or user which created the entity | |
| createdStamp | auditInfo.createdDate | Timestamp of when the entity was created | |
| apiName | auditInfo.updatedBy | Identifies the system or user which last updated the entity | |
| lastUpdatedStamp | auditInfo.updatedDate | Timestamp of when the entity was last updated | |
| Feature Bullets | description++longDescription | Product tags | |
| Consolidated Feature Bullets | description | The Product Description | |
| Description | longDescription | The product description | |
| size | The ProductSize | The Product Size |