MFG Salesforce Products System API - Implementation Template

(0 reviews)

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.

ModuleDescription
assign-pricebookentry-recordsGlobal and Standard Pricebook Entry Records Assign Mapping
create-pricebookentry-requestPricebooks Create Mapping for Manufacturing Cloud
create-product-category-requestProduct Category Create Mapping
pricebook-entries-selectPricebooks Query Mapping for Manufacturing Cloud
pricebook-put-pricebookentrybodyPricebooks Create Mapping for Manufacturing Cloud
product-image-prepare-entries-to-be-createdProductMedia Create Mapping for Manufacturing Cloud
product-media-selectProductMedia Query Mapping for Manufacturing Cloud
product-primarycategory-selectProductCatalog Query Mapping for Manufacturing Cloud
product-response-getProduct Query Mapping for Manufacturing Cloud
product-var-put-payloadProduct Upsert Mapping for Manufacturing Cloud
search-products-responseProduct Query Mapping for Manufacturing Cloud
update-pricebookentry-requestPricebooks 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

(back to top)

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 CloudCIMDescription
IsActivetrueIndicates whether or not the pricebookEntry is active
Pricebook2IdPricebook2IdThe id of the pricebookEntry
Product2IdproductIdThe id of the product
UnitPriceunitListPriceThe unitListPrice of the pricebookEntry

(back to top)

create-product-category-request

Product Category Create Mapping

Source: ./src/main/resources/dwl/create-product-category-request.dwl

(back to top)

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

CIMManufacturing CloudDescription
idPricebook2IdThe id of the pricebookEntry in Manufacturing Cloud
unitListPriceUnitPriceThe unit price of the pricebookEntry in Manufacturing Cloud
auditInfo.createdByCreatedByIdIdentifies the system or user which created the pricebookEntry entry
auditInfo.createdOnCreatedDateTimestamp of when the pricebookEntry entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the pricebookEntry entry
auditInfo.updatedOnLastModifiedDateTimestamp of when the pricebookEntry entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the pricebookEntry has been soft-deleted

(back to top)

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 CloudCIMDescription
IsActivetrueIndicates whether or not the pricebookEntry is active
Pricebook2IdPricebook2IdThe id of the pricebookEntry
Product2IdproductIdThe id of the product
UnitPriceunitListPriceThe unitListPrice of the pricebookEntry

(back to top)

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 CloudCIMDescription
ProductIdproductIdThe product code of the product to be updated
ElectronicMediaGroupIdElectronicMediaGroupIdThe Electronic Media Group Id of the Product image
ElectronicMediaIdElectronicMediaIdThe Electronic Media Id of the Product image

(back to top)

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

CIMManufacturing CloudDescription
idIdThe id of the product image in Manufacturing Cloud
nameNameThe name of the product image in Manufacturing Cloud
isDefaultImageisDefaultImageIndicates whether or not the product image is default image - default set to false
auditInfo.createdByCreatedByIdIdentifies the system or user which created the product image entry
auditInfo.createdOnCreatedDateTimestamp of when the product image entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the product image entry
auditInfo.updatedOnLastModifiedDateTimestamp of when the product image entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the product image has been soft-deleted

(back to top)

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

CIMManufacturing CloudDescription
idProductCategoryProduct.ProductCategory.IdThe identifier of the product category
nameProductCategoryProduct.ProductCategory.NameThe name of the product category
activeFromDateProductCategoryProduct.ProductCategory.CreatedDateTimestamp of when the product category entry was created
parentCategoryProductCategoryProduct.ParentCategoryIdThe parent category id of the product category
productCatalog.idProductCatalog.CatalogIdThe identifier of the product catalog
productCatalog.nameProductCatalog.NameThe name of the product catalog
productCatalog.activeFromDateProductCatalog.CreatedDateTimestamp of when the product catalog entry was created

(back to top)

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

CIMManufacturing CloudDescription
idIDThe id of the Product in Manufacturing Cloud
nameNameThe name of the Product in Manufacturing Cloud
longDescriptionDescriptionThe description of the Product in Manufacturing Cloud
descriptionShort_Description__cThe description of the Product in Manufacturing Cloud
externalSourceRecordExternal_ID__cThe external id of the Product in Manufacturing Cloud
isSellableIsActiveIndicates whether or not the product is active
typeFamilyThe family of the Product in Manufacturing Cloud
productCategory.idProductCategory.IdId of Product Category
productCategory.nameProductCategory.NameName of Product Category
productCategory.activeFromDateProductCategory.CreatedDateCreated Date of Product Category
productCategory.parentCategoryProductCategory.ParentCategoryIdProduct Category Id
productCategory.productCatalogCatalog.NameProduct Category Catalog Name
productCatalog.idCatalogIdId of Product Catalog
productCatalog.nameCatalog.NameName of Product Catalog
productCatalog.activeFromDateCatalog.CreatedDateCreated Date of Product Catalog
priceBookEntry.idIdId of Price Book Entry
priceBookEntry.useStandardPriceUseStandardPriceStandard Price of Price Book Entry
priceBookEntry.unitListPriceUnitPriceUnit Price of Price Book Entry
primaryProductCategoryproductCategoryThe product category of the product retrieved using a separate call
productIdProductCodeThe id of the Product in Manufacturing Cloud
productSKUStockKeepingUnitThe sku of the Product in Manufacturing Cloud
productStatusStatus__cThe status of the Product in Manufacturing Cloud
externalIds.externalIdType"MDM"Master data management
externalIds.externalIdGlobal_Product_Id__cGlobal Product id
externalIds.idIdExternal Id
externalIds.statusLastChangedDateLastModifiedDateLast Modified Date of Product
externalIds.status"VALID"Status of External Id
externalIds.externalIdType"SAP_4HANA"SAP4HANA Id
externalIds.externalIdSAP_4HANA_Id__cSAP4HANA Id
externalIds.idIdExternal Id
externalIds.status"VALID"Status of SAP4HANA Id
auditInfo.createdByCreatedByIdIdentifies the system or user which created the product entry
auditInfo.createdDateCreatedDateTimestamp of when the product entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the product entry
auditInfo.updatedDateLastModifiedDateTimestamp of when the product entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the product has been soft-deleted

(back to top)

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 CloudCIMDescription
IdproductIdId of the product
NamenameName of the product
ProductCodeproductSKUThe product code of the product to be updated
Product_Catalog__c"All Products"Product catalog set to "All products"
DescriptionlongDescriptionThe long description of the product
Item_Long_Description__clongDescriptionThe long description of the product
Short_Description__cdescriptionThe description of the product
Item_Short_Description__cdescriptionThe description of the product
Status__cproductStatusThe status of the product
External_ID__cexternalSourceRecordThe external id of the product
ExternalIdexternalSourceRecordThe external id of the product
SAP_4HANA_Id__csapIdSAP4HANA Product Id
FamilytypeThe type of the product
IsActiveisSellableIndicates whether or not the product is active
StockKeepingUnitproductSKUThe sku of the product
Global_Product_Id__cmdmGlobalProductIdGlobal product Id

(back to top)

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

CIMManufacturing CloudDescription
idIDThe id of the Product in Manufacturing Cloud
nameNameThe name of the Product in Manufacturing Cloud
longDescriptionDescriptionThe description of the Product in Manufacturing Cloud
descriptionShort_Description__cThe description of the Product in Manufacturing Cloud
externalSourceRecordExternal_ID__cThe external id of the Product in Manufacturing Cloud
isSellableIsActiveIndicates whether or not the product is active
typeFamilyThe family of the Product in Manufacturing Cloud
productCategory.idProductCategory.IdId of Product Category
productCategory.nameProductCategory.NameName of Product Category
productCategory.activeFromDateProductCategory.CreatedDateCreated Date of Product Category
productCategory.parentCategoryProductCategory.ParentCategoryIdProduct Category Id
productCategory.productCatalogCatalog.NameProduct Category Catalog Name
productCatalog.idCatalogIdId of Product Catalog
productCatalog.nameCatalog.NameName of Product Catalog
productCatalog.activeFromDateCatalog.CreatedDateCreated Date of Product Catalog
priceBookEntry.idIdId of Price Book Entry
priceBookEntry.useStandardPriceUseStandardPriceStandard Price of Price Book Entry
priceBookEntry.unitListPriceUnitPriceUnit Price of Price Book Entry
primaryProductCategoryproductCategoryThe product category of the product retrieved using a separate call
productIdProductCodeThe id of the Product in Manufacturing Cloud
productSKUStockKeepingUnitThe sku of the Product in Manufacturing Cloud
productStatusStatus__cThe status of the Product in Manufacturing Cloud
externalIds.externalIdType"MDM"Master data management
externalIds.externalIdGlobal_Product_Id__cGlobal Product id
externalIds.idIdExternal Id
externalIds.statusLastChangedDateLastModifiedDateLast Modified Date of Product
externalIds.status"VALID"Status of External Id
externalIds.externalIdType"SAP_4HANA"SAP4HANA Id
externalIds.externalIdSAP_4HANA_Id__cSAP4HANA Id
externalIds.idIdExternal Id
externalIds.status"VALID"Status of SAP4HANA Id
auditInfo.createdByCreatedByIdIdentifies the system or user which created the product entry
auditInfo.createdDateCreatedDateTimestamp of when the product entry was created
auditInfo.updatedByLastModifiedByIdIdentifies the system or user which last updated the product entry
auditInfo.updatedDateLastModifiedDateTimestamp of when the product entry was last updated
auditInfo.isDeletedIsDeletedIndicates whether or not the product has been soft-deleted

(back to top)

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 CloudCIMDescription
Idvars.pricebookEntryRecordList[0].IdThe Identifier of the existing standard pricebook entry
IsActivetrueIndicates whether or not the pricebookEntry is active
UnitPriceunitListPriceThe unitListPrice of the pricebookEntry

(back to top)


Reviews

TypeTemplate
OrganizationMulesoft Inc.
Published by
MuleSoft Solutions
Published onOct 27, 2023
Asset overview

Asset versions for 1.0.x

Asset versions
VersionActions
1.0.1
1.0.0