MFG Salesforce 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 |
---|---|
assign-pricebookentry-records | Global and Standard Pricebook Entry Records Assign Mapping |
create-pricebookentry-request | Pricebooks Create Mapping for Manufacturing Cloud |
create-product-category-request | Product Category Create Mapping |
pricebook-entries-select | Pricebooks Query Mapping for Manufacturing Cloud |
pricebook-put-pricebookentrybody | Pricebooks Create Mapping for Manufacturing Cloud |
product-image-prepare-entries-to-be-created | ProductMedia Create Mapping for Manufacturing Cloud |
product-media-select | ProductMedia Query Mapping for Manufacturing Cloud |
product-primarycategory-select | ProductCatalog Query Mapping for Manufacturing Cloud |
product-response-get | Product Query Mapping for Manufacturing Cloud |
product-var-put-payload | Product Upsert Mapping for Manufacturing Cloud |
search-products-response | Product Query Mapping for Manufacturing Cloud |
update-pricebookentry-request | Pricebooks Update Mapping for Manufacturing Cloud |
assign-pricebookentry-records
Global and Standard Pricebook Entry Records Assign Mapping
Source:
./src/main/resources/dwl/assign-pricebookentry-records.dwl
create-pricebookentry-request
Pricebooks Create Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/create-pricebookentry-request.dwl
Mapping Tables
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
Manufacturing Cloud | CIM | Description |
---|---|---|
IsActive | true | Indicates whether or not the pricebookEntry is active |
Pricebook2Id | Pricebook2Id | The id of the pricebookEntry |
Product2Id | productId | The id of the product |
UnitPrice | unitListPrice | The unitListPrice of the pricebookEntry |
create-product-category-request
Product Category Create Mapping
Source:
./src/main/resources/dwl/create-product-category-request.dwl
pricebook-entries-select
Pricebooks Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/pricebook-entries-select.dwl
Mapping Tables
Maps Manufacturing Cloud PricebookEntry to CIM PricebookEntry format
CIM | Manufacturing Cloud | Description |
---|---|---|
id | Pricebook2Id | The id of the pricebookEntry in Manufacturing Cloud |
unitListPrice | UnitPrice | The unit price of the pricebookEntry in Manufacturing Cloud |
auditInfo.createdBy | CreatedById | Identifies the system or user which created the pricebookEntry entry |
auditInfo.createdOn | CreatedDate | Timestamp of when the pricebookEntry entry was created |
auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the pricebookEntry entry |
auditInfo.updatedOn | LastModifiedDate | Timestamp of when the pricebookEntry entry was last updated |
auditInfo.isDeleted | IsDeleted | Indicates whether or not the pricebookEntry has been soft-deleted |
pricebook-put-pricebookentrybody
Pricebooks Create Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/pricebook-put-pricebookentrybody.dwl
Variables
var s
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
Mapping Tables
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
Manufacturing Cloud | CIM | Description |
---|---|---|
IsActive | true | Indicates whether or not the pricebookEntry is active |
Pricebook2Id | Pricebook2Id | The id of the pricebookEntry |
Product2Id | productId | The id of the product |
UnitPrice | unitListPrice | The unitListPrice of the pricebookEntry |
product-image-prepare-entries-to-be-created
ProductMedia Create Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-image-prepare-entries-to-be-created.dwl
Variables
var s
Maps CIM ProductImage to Manufacturing Cloud ProductMedia format
Mapping Tables
Maps CIM ProductImage to Manufacturing Cloud ProductMedia format
Manufacturing Cloud | CIM | Description |
---|---|---|
ProductId | productId | The product code of the product to be updated |
ElectronicMediaGroupId | ElectronicMediaGroupId | The Electronic Media Group Id of the Product image |
ElectronicMediaId | ElectronicMediaId | The Electronic Media Id of the Product image |
product-media-select
ProductMedia Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-media-select.dwl
Mapping Tables
Maps Manufacturing Cloud ProductMedia to CIM ProductImage format
CIM | Manufacturing Cloud | Description |
---|---|---|
id | Id | The id of the product image in Manufacturing Cloud |
name | Name | The name of the product image in Manufacturing Cloud |
isDefaultImage | isDefaultImage | Indicates whether or not the product image is default image - default set to false |
auditInfo.createdBy | CreatedById | Identifies the system or user which created the product image entry |
auditInfo.createdOn | CreatedDate | Timestamp of when the product image entry was created |
auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the product image entry |
auditInfo.updatedOn | LastModifiedDate | Timestamp of when the product image entry was last updated |
auditInfo.isDeleted | IsDeleted | Indicates whether or not the product image has been soft-deleted |
product-primarycategory-select
ProductCatalog Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-primarycategory-select.dwl
Mapping Tables
Maps Manufacturing Cloud to CIM product.primaryProductCategory
CIM | Manufacturing Cloud | Description |
---|---|---|
id | ProductCategoryProduct.ProductCategory.Id | The identifier of the product category |
name | ProductCategoryProduct.ProductCategory.Name | The name of the product category |
activeFromDate | ProductCategoryProduct.ProductCategory.CreatedDate | Timestamp of when the product category entry was created |
parentCategory | ProductCategoryProduct.ParentCategoryId | The parent category id of the product category |
productCatalog.id | ProductCatalog.CatalogId | The identifier of the product catalog |
productCatalog.name | ProductCatalog.Name | The name of the product catalog |
productCatalog.activeFromDate | ProductCatalog.CreatedDate | Timestamp of when the product catalog entry was created |
product-response-get
Product Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-response-get.dwl
Mapping Tables
Maps Manufacturing Cloud Product2 to CIM Product format
CIM | Manufacturing Cloud | Description |
---|---|---|
id | ID | The id of the Product in Manufacturing Cloud |
name | Name | The name of the Product in Manufacturing Cloud |
longDescription | Description | The description of the Product in Manufacturing Cloud |
description | Short_Description__c | The description of the Product in Manufacturing Cloud |
externalSourceRecord | External_ID__c | The external id of the Product in Manufacturing Cloud |
isSellable | IsActive | Indicates whether or not the product is active |
type | Family | The family of the Product in Manufacturing Cloud |
productCategory.id | ProductCategory.Id | Id of Product Category |
productCategory.name | ProductCategory.Name | Name of Product Category |
productCategory.activeFromDate | ProductCategory.CreatedDate | Created Date of Product Category |
productCategory.parentCategory | ProductCategory.ParentCategoryId | Product Category Id |
productCategory.productCatalog | Catalog.Name | Product Category Catalog Name |
productCatalog.id | CatalogId | Id of Product Catalog |
productCatalog.name | Catalog.Name | Name of Product Catalog |
productCatalog.activeFromDate | Catalog.CreatedDate | Created Date of Product Catalog |
priceBookEntry.id | Id | Id of Price Book Entry |
priceBookEntry.useStandardPrice | UseStandardPrice | Standard Price of Price Book Entry |
priceBookEntry.unitListPrice | UnitPrice | Unit Price of Price Book Entry |
primaryProductCategory | productCategory | The product category of the product retrieved using a separate call |
productId | ProductCode | The id of the Product in Manufacturing Cloud |
productSKU | StockKeepingUnit | The sku of the Product in Manufacturing Cloud |
productStatus | Status__c | The status of the Product in Manufacturing Cloud |
externalIds.externalIdType | "MDM" | Master data management |
externalIds.externalId | Global_Product_Id__c | Global Product id |
externalIds.id | Id | External Id |
externalIds.statusLastChangedDate | LastModifiedDate | Last Modified Date of Product |
externalIds.status | "VALID" | Status of External Id |
externalIds.externalIdType | "SAP_4HANA" | SAP4HANA Id |
externalIds.externalId | SAP_4HANA_Id__c | SAP4HANA Id |
externalIds.id | Id | External Id |
externalIds.status | "VALID" | Status of SAP4HANA Id |
auditInfo.createdBy | CreatedById | Identifies the system or user which created the product entry |
auditInfo.createdDate | CreatedDate | Timestamp of when the product entry was created |
auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the product entry |
auditInfo.updatedDate | LastModifiedDate | Timestamp of when the product entry was last updated |
auditInfo.isDeleted | IsDeleted | Indicates whether or not the product has been soft-deleted |
product-var-put-payload
Product Upsert Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-var-put-payload.dwl
Mapping Tables
Maps CIM Product to Manufacturing Cloud Product2 format
Manufacturing Cloud | CIM | Description |
---|---|---|
Id | productId | Id of the product |
Name | name | Name of the product |
ProductCode | productSKU | The product code of the product to be updated |
Product_Catalog__c | "All Products" | Product catalog set to "All products" |
Description | longDescription | The long description of the product |
Item_Long_Description__c | longDescription | The long description of the product |
Short_Description__c | description | The description of the product |
Item_Short_Description__c | description | The description of the product |
Status__c | productStatus | The status of the product |
External_ID__c | externalSourceRecord | The external id of the product |
ExternalId | externalSourceRecord | The external id of the product |
SAP_4HANA_Id__c | sapId | SAP4HANA Product Id |
Family | type | The type of the product |
IsActive | isSellable | Indicates whether or not the product is active |
StockKeepingUnit | productSKU | The sku of the product |
Global_Product_Id__c | mdmGlobalProductId | Global product Id |
search-products-response
Product Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/search-products-response.dwl
Variables
var s
Maps Manufacturing Cloud Product2 to CIM Product format
Mapping Tables
Maps Manufacturing Cloud Product2 to CIM Product format
CIM | Manufacturing Cloud | Description |
---|---|---|
id | ID | The id of the Product in Manufacturing Cloud |
name | Name | The name of the Product in Manufacturing Cloud |
longDescription | Description | The description of the Product in Manufacturing Cloud |
description | Short_Description__c | The description of the Product in Manufacturing Cloud |
externalSourceRecord | External_ID__c | The external id of the Product in Manufacturing Cloud |
isSellable | IsActive | Indicates whether or not the product is active |
type | Family | The family of the Product in Manufacturing Cloud |
productCategory.id | ProductCategory.Id | Id of Product Category |
productCategory.name | ProductCategory.Name | Name of Product Category |
productCategory.activeFromDate | ProductCategory.CreatedDate | Created Date of Product Category |
productCategory.parentCategory | ProductCategory.ParentCategoryId | Product Category Id |
productCategory.productCatalog | Catalog.Name | Product Category Catalog Name |
productCatalog.id | CatalogId | Id of Product Catalog |
productCatalog.name | Catalog.Name | Name of Product Catalog |
productCatalog.activeFromDate | Catalog.CreatedDate | Created Date of Product Catalog |
priceBookEntry.id | Id | Id of Price Book Entry |
priceBookEntry.useStandardPrice | UseStandardPrice | Standard Price of Price Book Entry |
priceBookEntry.unitListPrice | UnitPrice | Unit Price of Price Book Entry |
primaryProductCategory | productCategory | The product category of the product retrieved using a separate call |
productId | ProductCode | The id of the Product in Manufacturing Cloud |
productSKU | StockKeepingUnit | The sku of the Product in Manufacturing Cloud |
productStatus | Status__c | The status of the Product in Manufacturing Cloud |
externalIds.externalIdType | "MDM" | Master data management |
externalIds.externalId | Global_Product_Id__c | Global Product id |
externalIds.id | Id | External Id |
externalIds.statusLastChangedDate | LastModifiedDate | Last Modified Date of Product |
externalIds.status | "VALID" | Status of External Id |
externalIds.externalIdType | "SAP_4HANA" | SAP4HANA Id |
externalIds.externalId | SAP_4HANA_Id__c | SAP4HANA Id |
externalIds.id | Id | External Id |
externalIds.status | "VALID" | Status of SAP4HANA Id |
auditInfo.createdBy | CreatedById | Identifies the system or user which created the product entry |
auditInfo.createdDate | CreatedDate | Timestamp of when the product entry was created |
auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the product entry |
auditInfo.updatedDate | LastModifiedDate | Timestamp of when the product entry was last updated |
auditInfo.isDeleted | IsDeleted | Indicates whether or not the product has been soft-deleted |
update-pricebookentry-request
Pricebooks Update Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/update-pricebookentry-request.dwl
Mapping Tables
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
Manufacturing Cloud | CIM | Description |
---|---|---|
Id | vars.pricebookEntryRecordList[0].Id | The Identifier of the existing standard pricebook entry |
IsActive | true | Indicates whether or not the pricebookEntry is active |
UnitPrice | unitListPrice | The unitListPrice of the pricebookEntry |