Products
Zuletzt geändert von Dennis Brüseke am 25.11.2022, 08:29
This page contains code samples for products in the feed/export.
Iterator
<#list products as product>
${product.productId}
</#list>
Example result
90XB015P-BSL3M0
5658741
SWV2432W
KL1171GCADS
R-394120
HD8943-11
GS86421-250
AWF1549
4L0019901B
OCCBL-ORG1704
5658741
SWV2432W
KL1171GCADS
R-394120
HD8943-11
GS86421-250
AWF1549
4L0019901B
OCCBL-ORG1704
Typical fields (in CSV format)
productID,status,price
<#list products as product>
${product.productId},${product.statusId},${(product.prices?first.price)!}
</#list>
Example result
productID,status,price
90XB015P-BSL3M0,400,
5658741,400,479
SWV2432W,200,5.5
KL1171GCADS,090,19.9
R-394120,400,269.99
HD8943-11,400,1,189
GS86421-250,700,4.29
AWF1549,400,2.37
4L0019901B,400,239.99
OCCBL-ORG1704,200,36
...
90XB015P-BSL3M0,400,
5658741,400,479
SWV2432W,200,5.5
KL1171GCADS,090,19.9
R-394120,400,269.99
HD8943-11,400,1,189
GS86421-250,700,4.29
AWF1549,400,2.37
4L0019901B,400,239.99
OCCBL-ORG1704,200,36
...
Product relations
<#list products as product>
productId: ${product.productId}
manufacturer.manufacturerId: ${(product.manufacturer!{}).manufacturerId!'-'}
manufacturer.name: ${(product.manufacturer!{}).name!'-'}
manufacturerId: ${product.manufacturerId!''}
<#list product.relations>
relations:
<#items as relation>
RelatedProduct: ${relation.relatedProductId}
typeId: ${relation.typeId}
orderNo: ${relation.type.orderNo!'-'}
<#list relation.type.translations as languageId, translation>
languageId: ${languageId}
description: ${translation.description!'-'}
sourceTargetName: ${translation.sourceTargetName!'-'}
targetSourceName: ${translation.targetSourceName!'-'}
</#list>
</#items>
</#list>
</#list>
Example result
productId: R-394120
manufacturer.manufacturerId: goodyear
manufacturer.name: Goodyear
manufacturerId: goodyear
relations:
RelatedProduct: BAV764
typeId: Cross-Selling
orderNo: -
languageId: de
description: Cross-Selling
sourceTargetName: Kunden kauften auch
targetSourceName: Kunden kauften auch
languageId: de-DE
description: Cross-Selling
sourceTargetName: Kunden kauften auch
targetSourceName: Kunden kauften auch
languageId: en
description: Cross-Selling
sourceTargetName: Customers also bought
targetSourceName: Customers also bought
languageId: en-GB
...
manufacturer.manufacturerId: goodyear
manufacturer.name: Goodyear
manufacturerId: goodyear
relations:
RelatedProduct: BAV764
typeId: Cross-Selling
orderNo: -
languageId: de
description: Cross-Selling
sourceTargetName: Kunden kauften auch
targetSourceName: Kunden kauften auch
languageId: de-DE
description: Cross-Selling
sourceTargetName: Kunden kauften auch
targetSourceName: Kunden kauften auch
languageId: en
description: Cross-Selling
sourceTargetName: Customers also bought
targetSourceName: Customers also bought
languageId: en-GB
...
Filtered attribute values
Attribute values filtered to ShortDescription in language "de-DE" and variants excluded.
ProductID,AttributeId,AttributeValueLanguage,AttributeValue
<#list products as product>
<#list product.attributeValues as attributeValue>
<#list attributeValue.values! as value>
<#if attributeValue.variant! == "" && attributeValue.attribute.attributeId == "ShortDescription" && attributeValue.language == "de-DE">
${product.productId},${(attributeValue.attribute.attributeId)!},${attributeValue.language!},${value}
</#if>
</#list>
</#list>
</#list>
<#list products as product>
<#list product.attributeValues as attributeValue>
<#list attributeValue.values! as value>
<#if attributeValue.variant! == "" && attributeValue.attribute.attributeId == "ShortDescription" && attributeValue.language == "de-DE">
${product.productId},${(attributeValue.attribute.attributeId)!},${attributeValue.language!},${value}
</#if>
</#list>
</#list>
</#list>
Example result
ProductID,AttributeId,AttributeValueLanguage,AttributeValue
OCSNSR-ORG1704,ShortDescription,de-DE,SensorFactory Universal Temperatur Sensor
OCSNSR-ORG1704,ShortDescription,de-DE,SensorFactory Universal Temperatur Sensor
All Fields (in JSON Format)
<#macro escapeJson text>${text?js_string?replace("\\'", "\'")?replace("\\>",">")}</#macro>
<#assign languages = ["de-DE", "en-GB"]>
{
"products" : [ <#list products as product><#if product??>{
"createdOn" : "${(product.createdOn!)}",
"changedOn" : "${(product.changedOn!)}",
"productId" : "${product.productId!}",
"catalogId" : "${product.catalogId!}",
"supplierId" : "${product.supplierId!}",
"statusId" : ${product.statusId!},
"mfgProductId" : "${product.mfgProductId!}",
"manufacturerId" : "${product.manufacturerId!}",
"manufacturerName" : "${product.manufacturerName!}",
"extProductId" : "${product.extProductId!}",
"productIdExtension" : "${product.productIdExtension!}",
"unitOfMeasureId" : "${product.unitOfMeasureId!}",
"salesUnitOfMeasureId" : "${product.salesUnitOfMeasureId!}",
"keywords" : "<@escapeJson product.keywords!""/>",
"validFrom" : "${product.validFrom!}",
"validTo" : "${product.validTo!}",
"variants" : [ <#list product.variants! as variant>{
"createdOn" : "${(variant.createdOn)!}",
"changedOn" : "${(variant.changedOn)!}",
"variantId" : "${variant.variantId!}",
"statusId" : ${variant.statusId!}
}<#sep>,</#list> ],
"prices" : [ <#list product.prices! as price>{
"createdOn" : "${price.createdOn!}",
"changedOn" : "${price.changedOn!}",
"contractId" : "${price.contractId!}",
"statusId" : ${price.statusId!},
"variant" : "${price.variant!}",
"currencyId" : "${price.currencyId!}",
"priceTypeId" : "${price.priceTypeId!}",
"price" : ${price.price!},
"validFromQuantity" : "${price.validFromQuantity!}",
"validFrom" : "${price.validFrom!}",
"validTo" : "${price.validTo!}",
"priceUnit" : "${price.priceUnit!}",
"description" : "${price.description!}",
"vatPercentage" : ${(price.vatPercentage)!},
"isPreferred" : "${(price.isPreferred?string('true', 'false'))!}",
"unitOfMeasureId" : "${price.unitOfMeasureId!}",
"productIdExtensionForUom" : "${price.productIdExtensionForUom!}"
<#if price.contract??>
{
"conractId": "${price.contract.conractId!""}",
"contractCategoryId": "${price.contract.contractCategoryId!""}",
"statusId": "${price.contract.statusId!""}",
"description": "${price.contract.description!""}",
"validFrom": "${price.contract.validFrom!""}",
"validTo": "${price.contract.validTo!""}"
"longDescription": "${price.contract.longDescription("en-GB")!""}"
}
</#if>
}<#sep>,</#list> ],
"relations" : [ <#list product.relations! as relation>{
"createdOn" : "${(relation.createdOn)!}",
"changedOn" : "${(relation.changedOn)!}",
"productId" : "${relation.productId!}",
"catalogId" : "${relation.catalogId!}",
"relatedProductId" : "${relation.relatedProductId!}",
"relatedCatalogId" : "${relation.relatedCatalogId!}",
"relatedVariant" : "${relation.relatedVariant!}",
"typeId" : "${relation.typeId!}",
"validFrom" : "${relation.validFrom!}",
"validTo" : "${relation.validTo!}",
<#if relation.quantity?has_content>
"quantity" : ${(relation.quantity)!},
</#if>
"statusId" : ${relation.statusId!},
"variant" : "${relation.variant!}",
"seqNo" : "${relation.seqNo!}",
"udxText1" : {
"expression" : "<@escapeJson (relation.udxText1.expression)!""/>"
},
"udxText2" : {
"expression" : "<@escapeJson (relation.udxText2.expression)!""/>"
},
"udxText3" : {
"expression" : "<@escapeJson (relation.udxText3.expression)!""/>"
},
"udxText4" : {
"expression" : "<@escapeJson (relation.udxText4.expression)!""/>"
},
"udxText5" : {
"expression" : "<@escapeJson (relation.udxText5.expression)!""/>}"
},
<#if relation.udxNum1?has_content>
"udxNum1" : ${(relation.udxNum1)!},
</#if>
<#if relation.udxNum2?has_content>
"udxNum2" : ${(relation.udxNum2)!},
</#if>
<#if relation.udxNum3?has_content>
"udxNum3" : ${(relation.udxNum3)!},
</#if>
"udxSortKey1" : "${relation.udxSortKey1!}",
"udxSortKey2" : "${relation.udxSortKey2!}",
"udxSortKey3" : "${relation.udxSortKey3!}",
"syncTypeId" : "${relation.syncTypeId!}",
"isMandatory" : ${relation.isMandatory!?string('true', 'false')},
"selectionGroupId" : "${relation.selectionGroupId!}",
"isDefaultSelected" : ${relation.isDefaultSelected!?string('true', 'false')},
"descriptions" : [<#list relation.descriptions?filter(rdesc -> languages?seq_contains(rdesc.languageId)) as description> {
"createdOn" : "${(description.createdOn?number_to_datetime?iso_utc)!}",
"changedOn" : "${(description.changedOn?number_to_datetime?iso_utc)!}",
"language" : "${description.languageId!}",
"description" : "<@escapeJson description.description!""/>"
}<#sep>,</#list>
]
}<#sep>,</#list> ],
"reverseRelations" : [ <#list product.reverseRelations! as reverseRelation>{
"createdOn" : "${reverseRelation.createdOn!}",
"changedOn" : "${reverseRelation.changedOn!}",
"productId" : "${reverseRelation.productId!}",
"catalogId" : ${reverseRelation.catalogId!},
"relatedProductId" : "${reverseRelation.relatedProductId!}",
"relatedCatalogId" : "${reverseRelation.relatedCatalogId!}",
"relatedVariant" : "${reverseRelation.relatedVariant!}",
"typeId" : "${reverseRelation.typeId!}",
"validFrom" : "${reverseRelation.validFrom!}",
"validTo" : "${reverseRelation.validTo!}",
<#if reverseRelation.quantity?has_content>
"quantity" : ${(reverseRelation.quantity)!},
</#if>
"statusId" : ${reverseRelation.statusId!},
"variant" : "${reverseRelation.variant!}",
"seqNo" : "${reverseRelation.seqNo!}",
"udxText1" : {
"expression" : "<@escapeJson (reverseRelation.udxText1.expression)!""/>"
},
"udxText2" : {
"expression" : "<@escapeJson (reverseRelation.udxText2.expression)!""/>"
},
"udxText3" : {
"expression" : "<@escapeJson (reverseRelation.udxText3.expression)!""/>"
},
"udxText4" : {
"expression" : "<@escapeJson (reverseRelation.udxText4.expression)!""/>"
},
"udxText5" : {
"expression" : "<@escapeJson (reverseRelation.udxText5.expression)!""/>"
},
<#if reverseRelation.udxNum1?has_content>
"udxNum1" : ${(reverseRelation.udxNum1)!},
</#if>
<#if reverseRelation.udxNum2?has_content>
"udxNum2" : ${(reverseRelation.udxNum2)!},
</#if>
<#if reverseRelation.udxNum3?has_content>
"udxNum3" : ${(reverseRelation.udxNum3)!},
</#if>
"udxSortKey1" : "${reverseRelation.udxSortKey1!}",
"udxSortKey2" : "${reverseRelation.udxSortKey2!}",
"udxSortKey3" : "${reverseRelation.udxSortKey3!}",
"syncTypeId" : "${reverseRelation.syncTypeId!}",
"isMandatory" : ${reverseRelation.isMandatory!?string('true', 'false')},
"selectionGroupId" : "${reverseRelation.selectionGroupId!}",
"isDefaultSelected" : ${reverseRelation.isDefaultSelected!?string('true', 'false')},
<#assign commaNeeded = false>
"descriptions" : [<#list reverseRelation.descriptions as description><#if languages?seq_contains(description.languageId)><#if commaNeeded>,<#else><#assign commaNeeded = true></#if> {
"createdOn" : "${(description.createdOn?number_to_datetime?iso_utc)!}",
"changedOn" : "${(description.changedOn?number_to_datetime?iso_utc)!}",
"language" : "${description.languageId!}",
"description" : "<@escapeJson description.description!""/>"
}</#if></#list> ]
}<#sep>,</#list> ],
"contractedProducts" : [ <#list product.contractedProducts! as contractedProduct>{
"createdOn" : "${(contractedProduct.createdOn)!}",
"changedOn" : "${(contractedProduct.changedOn)!}",
"contractId" : "${contractedProduct.contractId!}",
"statusId" : ${contractedProduct.statusId!},
"variant" : "${contractedProduct.variant!}",
"extProductId" : "${contractedProduct.extProductId!}",
"altExtProductId" : "${contractedProduct.altExtProductId!}",
"extClassificationId" : "${contractedProduct.extClassificationId!}",
"extClassificationGroupId" : "${contractedProduct.extClassificationGroupId!}",
"descShort" : "<@escapeJson contractedProduct.descShort!""/>",
"descLong" : "<@escapeJson contractedProduct.descLong!""/>",
"extGlAccountId" : "${contractedProduct.extGlAccountId!}",
<#if contractedProduct.priceQuantity?has_content>
"priceQuantity" : ${(contractedProduct.priceQuantity)!},
</#if>
<#if contractedProduct.quantityInterval?has_content>
"quantityInterval" : ${(contractedProduct.quantityInterval)!},
</#if>
<#if contractedProduct.maxQuantity?has_content>
"maxQuantity" : ${(contractedProduct.maxQuantity)!},
</#if>
<#if contractedProduct.minQuantity?has_content>
"minQuantity" : ${(contractedProduct.minQuantity)!},
</#if>
<#if contractedProduct.leadtimeInDays?has_content>
"leadtimeInDays" : ${(contractedProduct.leadtimeInDays)!},
</#if>
"salesUnitOfMeasureId" : "${contractedProduct.salesUnitOfMeasureId!}",
"timePeriod" : "${contractedProduct.timePeriod!}",
<#if contractedProduct.visibility?has_content>
"visibility" : ${(contractedProduct.visibility)!},
</#if>
"unitOfMeasureId" : "${contractedProduct.unitOfMeasureId!}",
<#if contractedProduct.cost?has_content>
"cost" : ${(contractedProduct.cost)!},
</#if>
"currencyId" : "${contractedProduct.currencyId!}",
<#if contractedProduct.amount?has_content>
"amount" : ${(contractedProduct.amount)!},
</#if>
"statusDate" : "${contractedProduct.statusDate!}"<#if contractedProduct.discount?has_content>,
"discount" : ${(contractedProduct.discount)!}
</#if>
<#if contractedProduct.contract??>
{
"conractId": "${contractedProduct.contract.conractId!""}",
"contractCategoryId": "${contractedProduct.contract.contractCategoryId!""}",
"statusId": "${contractedProduct.contract.statusId!""}",
"description": "${contractedProduct.contract.description!""}",
"validFrom": "${contractedProduct.contract.validFrom!""}",
"validTo": "${contractedProduct.contract.validTo!""}"
"longDescription": "${contractedProduct.contract.longDescription("en")!""}"
}
</#if>
}<#sep>,</#list> ],
"classificationGroupAssociations" : [ <#list product.classificationGroupAssociations! as classGroupAssociation>{
"createdOn" : "${(classGroupAssociation.createdOn)!}",
"changedOn" : "${(classGroupAssociation.changedOn)!}",
"classificationId" : "${classGroupAssociation.classificationId!}",
"classificationGroupId" : "${classGroupAssociation.classificationGroupId!}",
"orderNo" : "${classGroupAssociation.orderNo!}",
"variant" : "${classGroupAssociation.variant!}"
}<#sep>,</#list> ],
"docAssociations" : [ <#list product.docAssociations! as docAssociation>{
"createdOn" : "${(docAssociation.createdOn)!}",
"changedOn" : "${(docAssociation.changedOn)!}",
"path" : "${docAssociation.path!}",
"documentViewTypeId" : "${docAssociation.documentViewTypeId!}",
<#if docAssociation.caption?has_content>
"caption" : "<@escapeJson docAssociation.caption.getValue()!""/>",
</#if>
<#if docAssociation.orderNo?has_content>
"orderNo" : ${(docAssociation.orderNo)!},
</#if>
"language" : "${docAssociation.languageId!}",
"description" : "<@escapeJson docAssociation.description!""/>",
"validFrom" : "${docAssociation.validFrom!}",
"validTo" : "${docAssociation.validTo!}",
"status" : ${docAssociation.status!},
"variant" : "${docAssociation.variant!}",
"tags" : [<#list docAssociation.tags! as tag>
"${tag}"<#sep>,</#list>
],
"extDocumentId" : "${docAssociation.extDocumentId!}",
"udxText1" : "<@escapeJson docAssociation.udxText1!""/>",
"udxText2" : "<@escapeJson docAssociation.udxText2!""/>",
"udxText3" : "<@escapeJson docAssociation.udxText3!""/>",
<#if docAssociation.udxNum1?has_content>
"udxNum1" : ${(docAssociation.udxNum1)!},
</#if>
<#if docAssociation.udxNum2?has_content>
"udxNum2" : ${(docAssociation.udxNum2)!},
</#if>
<#if docAssociation.udxNum3?has_content>
"udxNum3" : ${(docAssociation.udxNum3)!},
</#if>
"udxSortKey1" : "${docAssociation.udxSortKey1!}",
"udxSortKey2" : "${docAssociation.udxSortKey2!}",
"udxSortKey3" : "${docAssociation.udxSortKey3!}"
}<#sep>,</#list> ],
"attributeValues" : [ <#list product.attributeValues! as attributeValue><#if attributeValue.attribute??>{
"attribute" : "${(attributeValue.attribute.id)!}",
"status" : ${attributeValue.status!},
"variant" : "${attributeValue.variant!}",
"language" : "${attributeValue.language!}",
"values" : [ <#list attributeValue.values! as value>"<@escapeJson value!""/>"<#sep>, </#list> ]
}<#sep>,</#sep></#if></#list> ]
}<#sep>,</#sep></#if></#list> ]
}
<#assign languages = ["de-DE", "en-GB"]>
{
"products" : [ <#list products as product><#if product??>{
"createdOn" : "${(product.createdOn!)}",
"changedOn" : "${(product.changedOn!)}",
"productId" : "${product.productId!}",
"catalogId" : "${product.catalogId!}",
"supplierId" : "${product.supplierId!}",
"statusId" : ${product.statusId!},
"mfgProductId" : "${product.mfgProductId!}",
"manufacturerId" : "${product.manufacturerId!}",
"manufacturerName" : "${product.manufacturerName!}",
"extProductId" : "${product.extProductId!}",
"productIdExtension" : "${product.productIdExtension!}",
"unitOfMeasureId" : "${product.unitOfMeasureId!}",
"salesUnitOfMeasureId" : "${product.salesUnitOfMeasureId!}",
"keywords" : "<@escapeJson product.keywords!""/>",
"validFrom" : "${product.validFrom!}",
"validTo" : "${product.validTo!}",
"variants" : [ <#list product.variants! as variant>{
"createdOn" : "${(variant.createdOn)!}",
"changedOn" : "${(variant.changedOn)!}",
"variantId" : "${variant.variantId!}",
"statusId" : ${variant.statusId!}
}<#sep>,</#list> ],
"prices" : [ <#list product.prices! as price>{
"createdOn" : "${price.createdOn!}",
"changedOn" : "${price.changedOn!}",
"contractId" : "${price.contractId!}",
"statusId" : ${price.statusId!},
"variant" : "${price.variant!}",
"currencyId" : "${price.currencyId!}",
"priceTypeId" : "${price.priceTypeId!}",
"price" : ${price.price!},
"validFromQuantity" : "${price.validFromQuantity!}",
"validFrom" : "${price.validFrom!}",
"validTo" : "${price.validTo!}",
"priceUnit" : "${price.priceUnit!}",
"description" : "${price.description!}",
"vatPercentage" : ${(price.vatPercentage)!},
"isPreferred" : "${(price.isPreferred?string('true', 'false'))!}",
"unitOfMeasureId" : "${price.unitOfMeasureId!}",
"productIdExtensionForUom" : "${price.productIdExtensionForUom!}"
<#if price.contract??>
{
"conractId": "${price.contract.conractId!""}",
"contractCategoryId": "${price.contract.contractCategoryId!""}",
"statusId": "${price.contract.statusId!""}",
"description": "${price.contract.description!""}",
"validFrom": "${price.contract.validFrom!""}",
"validTo": "${price.contract.validTo!""}"
"longDescription": "${price.contract.longDescription("en-GB")!""}"
}
</#if>
}<#sep>,</#list> ],
"relations" : [ <#list product.relations! as relation>{
"createdOn" : "${(relation.createdOn)!}",
"changedOn" : "${(relation.changedOn)!}",
"productId" : "${relation.productId!}",
"catalogId" : "${relation.catalogId!}",
"relatedProductId" : "${relation.relatedProductId!}",
"relatedCatalogId" : "${relation.relatedCatalogId!}",
"relatedVariant" : "${relation.relatedVariant!}",
"typeId" : "${relation.typeId!}",
"validFrom" : "${relation.validFrom!}",
"validTo" : "${relation.validTo!}",
<#if relation.quantity?has_content>
"quantity" : ${(relation.quantity)!},
</#if>
"statusId" : ${relation.statusId!},
"variant" : "${relation.variant!}",
"seqNo" : "${relation.seqNo!}",
"udxText1" : {
"expression" : "<@escapeJson (relation.udxText1.expression)!""/>"
},
"udxText2" : {
"expression" : "<@escapeJson (relation.udxText2.expression)!""/>"
},
"udxText3" : {
"expression" : "<@escapeJson (relation.udxText3.expression)!""/>"
},
"udxText4" : {
"expression" : "<@escapeJson (relation.udxText4.expression)!""/>"
},
"udxText5" : {
"expression" : "<@escapeJson (relation.udxText5.expression)!""/>}"
},
<#if relation.udxNum1?has_content>
"udxNum1" : ${(relation.udxNum1)!},
</#if>
<#if relation.udxNum2?has_content>
"udxNum2" : ${(relation.udxNum2)!},
</#if>
<#if relation.udxNum3?has_content>
"udxNum3" : ${(relation.udxNum3)!},
</#if>
"udxSortKey1" : "${relation.udxSortKey1!}",
"udxSortKey2" : "${relation.udxSortKey2!}",
"udxSortKey3" : "${relation.udxSortKey3!}",
"syncTypeId" : "${relation.syncTypeId!}",
"isMandatory" : ${relation.isMandatory!?string('true', 'false')},
"selectionGroupId" : "${relation.selectionGroupId!}",
"isDefaultSelected" : ${relation.isDefaultSelected!?string('true', 'false')},
"descriptions" : [<#list relation.descriptions?filter(rdesc -> languages?seq_contains(rdesc.languageId)) as description> {
"createdOn" : "${(description.createdOn?number_to_datetime?iso_utc)!}",
"changedOn" : "${(description.changedOn?number_to_datetime?iso_utc)!}",
"language" : "${description.languageId!}",
"description" : "<@escapeJson description.description!""/>"
}<#sep>,</#list>
]
}<#sep>,</#list> ],
"reverseRelations" : [ <#list product.reverseRelations! as reverseRelation>{
"createdOn" : "${reverseRelation.createdOn!}",
"changedOn" : "${reverseRelation.changedOn!}",
"productId" : "${reverseRelation.productId!}",
"catalogId" : ${reverseRelation.catalogId!},
"relatedProductId" : "${reverseRelation.relatedProductId!}",
"relatedCatalogId" : "${reverseRelation.relatedCatalogId!}",
"relatedVariant" : "${reverseRelation.relatedVariant!}",
"typeId" : "${reverseRelation.typeId!}",
"validFrom" : "${reverseRelation.validFrom!}",
"validTo" : "${reverseRelation.validTo!}",
<#if reverseRelation.quantity?has_content>
"quantity" : ${(reverseRelation.quantity)!},
</#if>
"statusId" : ${reverseRelation.statusId!},
"variant" : "${reverseRelation.variant!}",
"seqNo" : "${reverseRelation.seqNo!}",
"udxText1" : {
"expression" : "<@escapeJson (reverseRelation.udxText1.expression)!""/>"
},
"udxText2" : {
"expression" : "<@escapeJson (reverseRelation.udxText2.expression)!""/>"
},
"udxText3" : {
"expression" : "<@escapeJson (reverseRelation.udxText3.expression)!""/>"
},
"udxText4" : {
"expression" : "<@escapeJson (reverseRelation.udxText4.expression)!""/>"
},
"udxText5" : {
"expression" : "<@escapeJson (reverseRelation.udxText5.expression)!""/>"
},
<#if reverseRelation.udxNum1?has_content>
"udxNum1" : ${(reverseRelation.udxNum1)!},
</#if>
<#if reverseRelation.udxNum2?has_content>
"udxNum2" : ${(reverseRelation.udxNum2)!},
</#if>
<#if reverseRelation.udxNum3?has_content>
"udxNum3" : ${(reverseRelation.udxNum3)!},
</#if>
"udxSortKey1" : "${reverseRelation.udxSortKey1!}",
"udxSortKey2" : "${reverseRelation.udxSortKey2!}",
"udxSortKey3" : "${reverseRelation.udxSortKey3!}",
"syncTypeId" : "${reverseRelation.syncTypeId!}",
"isMandatory" : ${reverseRelation.isMandatory!?string('true', 'false')},
"selectionGroupId" : "${reverseRelation.selectionGroupId!}",
"isDefaultSelected" : ${reverseRelation.isDefaultSelected!?string('true', 'false')},
<#assign commaNeeded = false>
"descriptions" : [<#list reverseRelation.descriptions as description><#if languages?seq_contains(description.languageId)><#if commaNeeded>,<#else><#assign commaNeeded = true></#if> {
"createdOn" : "${(description.createdOn?number_to_datetime?iso_utc)!}",
"changedOn" : "${(description.changedOn?number_to_datetime?iso_utc)!}",
"language" : "${description.languageId!}",
"description" : "<@escapeJson description.description!""/>"
}</#if></#list> ]
}<#sep>,</#list> ],
"contractedProducts" : [ <#list product.contractedProducts! as contractedProduct>{
"createdOn" : "${(contractedProduct.createdOn)!}",
"changedOn" : "${(contractedProduct.changedOn)!}",
"contractId" : "${contractedProduct.contractId!}",
"statusId" : ${contractedProduct.statusId!},
"variant" : "${contractedProduct.variant!}",
"extProductId" : "${contractedProduct.extProductId!}",
"altExtProductId" : "${contractedProduct.altExtProductId!}",
"extClassificationId" : "${contractedProduct.extClassificationId!}",
"extClassificationGroupId" : "${contractedProduct.extClassificationGroupId!}",
"descShort" : "<@escapeJson contractedProduct.descShort!""/>",
"descLong" : "<@escapeJson contractedProduct.descLong!""/>",
"extGlAccountId" : "${contractedProduct.extGlAccountId!}",
<#if contractedProduct.priceQuantity?has_content>
"priceQuantity" : ${(contractedProduct.priceQuantity)!},
</#if>
<#if contractedProduct.quantityInterval?has_content>
"quantityInterval" : ${(contractedProduct.quantityInterval)!},
</#if>
<#if contractedProduct.maxQuantity?has_content>
"maxQuantity" : ${(contractedProduct.maxQuantity)!},
</#if>
<#if contractedProduct.minQuantity?has_content>
"minQuantity" : ${(contractedProduct.minQuantity)!},
</#if>
<#if contractedProduct.leadtimeInDays?has_content>
"leadtimeInDays" : ${(contractedProduct.leadtimeInDays)!},
</#if>
"salesUnitOfMeasureId" : "${contractedProduct.salesUnitOfMeasureId!}",
"timePeriod" : "${contractedProduct.timePeriod!}",
<#if contractedProduct.visibility?has_content>
"visibility" : ${(contractedProduct.visibility)!},
</#if>
"unitOfMeasureId" : "${contractedProduct.unitOfMeasureId!}",
<#if contractedProduct.cost?has_content>
"cost" : ${(contractedProduct.cost)!},
</#if>
"currencyId" : "${contractedProduct.currencyId!}",
<#if contractedProduct.amount?has_content>
"amount" : ${(contractedProduct.amount)!},
</#if>
"statusDate" : "${contractedProduct.statusDate!}"<#if contractedProduct.discount?has_content>,
"discount" : ${(contractedProduct.discount)!}
</#if>
<#if contractedProduct.contract??>
{
"conractId": "${contractedProduct.contract.conractId!""}",
"contractCategoryId": "${contractedProduct.contract.contractCategoryId!""}",
"statusId": "${contractedProduct.contract.statusId!""}",
"description": "${contractedProduct.contract.description!""}",
"validFrom": "${contractedProduct.contract.validFrom!""}",
"validTo": "${contractedProduct.contract.validTo!""}"
"longDescription": "${contractedProduct.contract.longDescription("en")!""}"
}
</#if>
}<#sep>,</#list> ],
"classificationGroupAssociations" : [ <#list product.classificationGroupAssociations! as classGroupAssociation>{
"createdOn" : "${(classGroupAssociation.createdOn)!}",
"changedOn" : "${(classGroupAssociation.changedOn)!}",
"classificationId" : "${classGroupAssociation.classificationId!}",
"classificationGroupId" : "${classGroupAssociation.classificationGroupId!}",
"orderNo" : "${classGroupAssociation.orderNo!}",
"variant" : "${classGroupAssociation.variant!}"
}<#sep>,</#list> ],
"docAssociations" : [ <#list product.docAssociations! as docAssociation>{
"createdOn" : "${(docAssociation.createdOn)!}",
"changedOn" : "${(docAssociation.changedOn)!}",
"path" : "${docAssociation.path!}",
"documentViewTypeId" : "${docAssociation.documentViewTypeId!}",
<#if docAssociation.caption?has_content>
"caption" : "<@escapeJson docAssociation.caption.getValue()!""/>",
</#if>
<#if docAssociation.orderNo?has_content>
"orderNo" : ${(docAssociation.orderNo)!},
</#if>
"language" : "${docAssociation.languageId!}",
"description" : "<@escapeJson docAssociation.description!""/>",
"validFrom" : "${docAssociation.validFrom!}",
"validTo" : "${docAssociation.validTo!}",
"status" : ${docAssociation.status!},
"variant" : "${docAssociation.variant!}",
"tags" : [<#list docAssociation.tags! as tag>
"${tag}"<#sep>,</#list>
],
"extDocumentId" : "${docAssociation.extDocumentId!}",
"udxText1" : "<@escapeJson docAssociation.udxText1!""/>",
"udxText2" : "<@escapeJson docAssociation.udxText2!""/>",
"udxText3" : "<@escapeJson docAssociation.udxText3!""/>",
<#if docAssociation.udxNum1?has_content>
"udxNum1" : ${(docAssociation.udxNum1)!},
</#if>
<#if docAssociation.udxNum2?has_content>
"udxNum2" : ${(docAssociation.udxNum2)!},
</#if>
<#if docAssociation.udxNum3?has_content>
"udxNum3" : ${(docAssociation.udxNum3)!},
</#if>
"udxSortKey1" : "${docAssociation.udxSortKey1!}",
"udxSortKey2" : "${docAssociation.udxSortKey2!}",
"udxSortKey3" : "${docAssociation.udxSortKey3!}"
}<#sep>,</#list> ],
"attributeValues" : [ <#list product.attributeValues! as attributeValue><#if attributeValue.attribute??>{
"attribute" : "${(attributeValue.attribute.id)!}",
"status" : ${attributeValue.status!},
"variant" : "${attributeValue.variant!}",
"language" : "${attributeValue.language!}",
"values" : [ <#list attributeValue.values! as value>"<@escapeJson value!""/>"<#sep>, </#list> ]
}<#sep>,</#sep></#if></#list> ]
}<#sep>,</#sep></#if></#list> ]
}
Example result
{
"products" : [ {
"createdOn" : "May 5, 2022 2:13:23 PM",
"changedOn" : "May 9, 2022 10:35:21 AM",
"productId" : "TestProductAll",
"catalogId" : "car001",
"supplierId" : "AmazonDe",
"statusId" : "400",
"mfgProductId" : "12345",
"manufacturerId" : "amazon",
"manufacturerName" : "Manufactor",
"extProductId" : "Test",
"productIdExtension" : "Test",
"unitOfMeasureId" : "C62",
"salesUnitOfMeasureId" : "C62",
"keywords" : "TestProductAll",
"validFrom" : "May 10, 2022 12:00:00 AM",
"validTo" : "May 27, 2022 12:00:00 AM",
"variants" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"variantId" : "TestVariant",
"statusId" : "400"
} ],
"prices" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 10:27:58 AM",
"contractId" : "car001",
"statusId" : "100",
"variant" : "",
"currencyId" : "EUR",
"priceTypeId" : "default",
"price" : "10",
"validFromQuantity" : "1",
"validFrom" : "",
"validTo" : "",
"priceUnit" : "1",
"description" : "Test",
"vatPercentage" : 10,
"isPreferred" : "true",
"unitOfMeasureId" : "PCE",
"productIdExtensionForUom" : "test"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"contractId" : "car001",
"statusId" : "100",
"variant" : "TestVariant",
"currencyId" : "CHF",
"priceTypeId" : "Gross",
"price" : "10",
"validFromQuantity" : "1",
"validFrom" : "",
"validTo" : "",
"priceUnit" : "1",
"description" : "price",
"vatPercentage" : 50,
"isPreferred" : "",
"unitOfMeasureId" : "C62",
"productIdExtensionForUom" : "12345"
} ],
"relations" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"productId" : "TestProductAll",
"catalogId" : "car001",
"relatedProductId" : "SJL2134M0XEU",
"relatedCatalogId" : "MasterCatalog",
"relatedVariant" : "",
"typeId" : "Fahrdienste",
"validFrom" : "May 2, 2022 12:00:00 AM",
"validTo" : "May 27, 2047 12:00:00 AM",
"quantity" : 1,
"statusId" : "400",
"variant" : "",
"seqNo" : "1",
"udxText1" : {
"expression" : "1"
},
"udxText2" : {
"expression" : "2"
},
"udxText3" : {
"expression" : "3"
},
"udxText4" : {
"expression" : "4"
},
"udxText5" : {
"expression" : "5}"
},
"udxNum1" : 2,
"udxNum2" : 1,
"udxNum3" : 3,
"udxSortKey1" : "4",
"udxSortKey2" : "5",
"udxSortKey3" : "6",
"syncTypeId" : "",
"isMandatory" : true,
"selectionGroupId" : "12345",
"isDefaultSelected" : true,
"descriptions" : [ ]
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"productId" : "TestProductAll",
"catalogId" : "car001",
"relatedProductId" : "P14AT0020121111",
"relatedCatalogId" : "MasterCatalog",
"relatedVariant" : "",
"typeId" : "Elektro",
"validFrom" : "May 16, 2022 12:00:00 AM",
"validTo" : "May 25, 2022 12:00:00 AM",
"quantity" : 1,
"statusId" : "100",
"variant" : "TestVariant",
"seqNo" : "2",
"udxText1" : {
"expression" : "1"
},
"udxText2" : {
"expression" : "2"
},
"udxText3" : {
"expression" : "3"
},
"udxText4" : {
"expression" : "4"
},
"udxText5" : {
"expression" : "5}"
},
"udxNum1" : 1,
"udxNum2" : 2,
"udxNum3" : 3,
"udxSortKey1" : "4",
"udxSortKey2" : "5",
"udxSortKey3" : "1",
"syncTypeId" : "",
"isMandatory" : true,
"selectionGroupId" : "12345",
"isDefaultSelected" : true,
"descriptions" : [ ]
} ],
"reverseRelations" : [ ],
"contractedProducts" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"contractId" : "int001quote",
"statusId" : "600",
"variant" : "TestVariant",
"extProductId" : "1",
"altExtProductId" : "test4",
"extClassificationId" : "1",
"extClassificationGroupId" : "1",
"descShort" : "1",
"descLong" : "test1",
"extGlAccountId" : "test2",
"priceQuantity" : 1,
"quantityInterval" : 1,
"maxQuantity" : 2,
"minQuantity" : 1,
"leadtimeInDays" : 1,
"salesUnitOfMeasureId" : "AMP",
"timePeriod" : "week",
"visibility" : 1,
"unitOfMeasureId" : "A99",
"cost" : 11,
"currencyId" : "EUR",
"amount" : 1,
"statusDate" : "May 17, 2022 12:00:00 AM",
"discount" : 1
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 10:28:35 AM",
"contractId" : "car001",
"statusId" : "400",
"variant" : "TestVariant",
"extProductId" : "1",
"altExtProductId" : "1",
"extClassificationId" : "1",
"extClassificationGroupId" : "1",
"descShort" : "1",
"descLong" : "1",
"extGlAccountId" : "1",
"priceQuantity" : 1,
"quantityInterval" : 1,
"maxQuantity" : 10,
"minQuantity" : 1,
"leadtimeInDays" : 1,
"salesUnitOfMeasureId" : "ANN",
"timePeriod" : "month",
"visibility" : 0,
"unitOfMeasureId" : "A99",
"cost" : 10,
"currencyId" : "EUR",
"amount" : 1,
"statusDate" : "Jun 1, 2022 12:00:00 AM",
"discount" : 1
} ],
"classificationGroupAssociations" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "basic",
"classificationGroupId" : "text",
"orderNo" : "",
"variant" : ""
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "basic",
"classificationGroupId" : "productbasic",
"orderNo" : "",
"variant" : ""
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "MasterClassification",
"classificationGroupId" : "Commodities",
"orderNo" : "",
"variant" : "TestVariant"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "MasterClassification",
"classificationGroupId" : "ElectricEngineering",
"orderNo" : "",
"variant" : "TestVariant"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "MasterClassification",
"classificationGroupId" : "WorkshopEquipment",
"orderNo" : "",
"variant" : "TestVariant"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "basic",
"classificationGroupId" : "ProductEnrichmentLevel",
"orderNo" : "",
"variant" : ""
} ],
"docAssociations" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"path" : "documents/hotfolder/testproduct.png",
"documentViewTypeId" : "product_image",
"caption" : "text table: \'Test\'",
"orderNo" : 1,
"language" : "",
"description" : "Test",
"validFrom" : "May 3, 2022 12:00:00 AM",
"validTo" : "May 31, 2079 12:00:00 AM",
"status" : "100",
"variant" : "",
"tags" : [
],
"extDocumentId" : "12345",
"udxText1" : "test1",
"udxText2" : "test2",
"udxText3" : "test3",
"udxNum1" : 1,
"udxNum2" : 2,
"udxNum3" : 3,
"udxSortKey1" : "4",
"udxSortKey2" : "test",
"udxSortKey3" : "test"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"path" : "documents/hotfolder/testproduct.png",
"documentViewTypeId" : "preview",
"caption" : "text table: \'test\'",
"orderNo" : 1,
"language" : "",
"description" : "test",
"validFrom" : "May 25, 2022 12:00:00 AM",
"validTo" : "May 25, 2078 12:00:00 AM",
"status" : "100",
"variant" : "",
"tags" : [
],
"extDocumentId" : "13579",
"udxText1" : "test1",
"udxText2" : "test2",
"udxText3" : "test3",
"udxNum1" : 1,
"udxNum2" : 2,
"udxNum3" : 3,
"udxSortKey1" : "qwr",
"udxSortKey2" : "qwer",
"udxSortKey3" : "qwert"
} ],
"attributeValues" : [ {
"attribute" : "isNew",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "IsChemical",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "ShortDescription",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "TestProductAll" ]
},{
"attribute" : "IsSafety",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "IsNotSearchable",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "Remarks",
"status" : "",
"variant" : "",
"language" : "en-GB",
"values" : [ "Test" ]
},{
"attribute" : "IsEnvironmentallyPreferred",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "LongDescription",
"status" : "",
"variant" : "",
"language" : "de",
"values" : [ "This is a testproduct" ]
},{
"attribute" : "IsFreeShipping",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "convRateSales",
"status" : "400",
"variant" : "",
"language" : "en-GB",
"values" : [ "10" ]
},{
"attribute" : "IsNotStandaloneOrderable",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "false" ]
},{
"attribute" : "PackagingUoMId",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "Yes" ]
} ]
} ]
}
"products" : [ {
"createdOn" : "May 5, 2022 2:13:23 PM",
"changedOn" : "May 9, 2022 10:35:21 AM",
"productId" : "TestProductAll",
"catalogId" : "car001",
"supplierId" : "AmazonDe",
"statusId" : "400",
"mfgProductId" : "12345",
"manufacturerId" : "amazon",
"manufacturerName" : "Manufactor",
"extProductId" : "Test",
"productIdExtension" : "Test",
"unitOfMeasureId" : "C62",
"salesUnitOfMeasureId" : "C62",
"keywords" : "TestProductAll",
"validFrom" : "May 10, 2022 12:00:00 AM",
"validTo" : "May 27, 2022 12:00:00 AM",
"variants" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"variantId" : "TestVariant",
"statusId" : "400"
} ],
"prices" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 10:27:58 AM",
"contractId" : "car001",
"statusId" : "100",
"variant" : "",
"currencyId" : "EUR",
"priceTypeId" : "default",
"price" : "10",
"validFromQuantity" : "1",
"validFrom" : "",
"validTo" : "",
"priceUnit" : "1",
"description" : "Test",
"vatPercentage" : 10,
"isPreferred" : "true",
"unitOfMeasureId" : "PCE",
"productIdExtensionForUom" : "test"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"contractId" : "car001",
"statusId" : "100",
"variant" : "TestVariant",
"currencyId" : "CHF",
"priceTypeId" : "Gross",
"price" : "10",
"validFromQuantity" : "1",
"validFrom" : "",
"validTo" : "",
"priceUnit" : "1",
"description" : "price",
"vatPercentage" : 50,
"isPreferred" : "",
"unitOfMeasureId" : "C62",
"productIdExtensionForUom" : "12345"
} ],
"relations" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"productId" : "TestProductAll",
"catalogId" : "car001",
"relatedProductId" : "SJL2134M0XEU",
"relatedCatalogId" : "MasterCatalog",
"relatedVariant" : "",
"typeId" : "Fahrdienste",
"validFrom" : "May 2, 2022 12:00:00 AM",
"validTo" : "May 27, 2047 12:00:00 AM",
"quantity" : 1,
"statusId" : "400",
"variant" : "",
"seqNo" : "1",
"udxText1" : {
"expression" : "1"
},
"udxText2" : {
"expression" : "2"
},
"udxText3" : {
"expression" : "3"
},
"udxText4" : {
"expression" : "4"
},
"udxText5" : {
"expression" : "5}"
},
"udxNum1" : 2,
"udxNum2" : 1,
"udxNum3" : 3,
"udxSortKey1" : "4",
"udxSortKey2" : "5",
"udxSortKey3" : "6",
"syncTypeId" : "",
"isMandatory" : true,
"selectionGroupId" : "12345",
"isDefaultSelected" : true,
"descriptions" : [ ]
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"productId" : "TestProductAll",
"catalogId" : "car001",
"relatedProductId" : "P14AT0020121111",
"relatedCatalogId" : "MasterCatalog",
"relatedVariant" : "",
"typeId" : "Elektro",
"validFrom" : "May 16, 2022 12:00:00 AM",
"validTo" : "May 25, 2022 12:00:00 AM",
"quantity" : 1,
"statusId" : "100",
"variant" : "TestVariant",
"seqNo" : "2",
"udxText1" : {
"expression" : "1"
},
"udxText2" : {
"expression" : "2"
},
"udxText3" : {
"expression" : "3"
},
"udxText4" : {
"expression" : "4"
},
"udxText5" : {
"expression" : "5}"
},
"udxNum1" : 1,
"udxNum2" : 2,
"udxNum3" : 3,
"udxSortKey1" : "4",
"udxSortKey2" : "5",
"udxSortKey3" : "1",
"syncTypeId" : "",
"isMandatory" : true,
"selectionGroupId" : "12345",
"isDefaultSelected" : true,
"descriptions" : [ ]
} ],
"reverseRelations" : [ ],
"contractedProducts" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"contractId" : "int001quote",
"statusId" : "600",
"variant" : "TestVariant",
"extProductId" : "1",
"altExtProductId" : "test4",
"extClassificationId" : "1",
"extClassificationGroupId" : "1",
"descShort" : "1",
"descLong" : "test1",
"extGlAccountId" : "test2",
"priceQuantity" : 1,
"quantityInterval" : 1,
"maxQuantity" : 2,
"minQuantity" : 1,
"leadtimeInDays" : 1,
"salesUnitOfMeasureId" : "AMP",
"timePeriod" : "week",
"visibility" : 1,
"unitOfMeasureId" : "A99",
"cost" : 11,
"currencyId" : "EUR",
"amount" : 1,
"statusDate" : "May 17, 2022 12:00:00 AM",
"discount" : 1
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 10:28:35 AM",
"contractId" : "car001",
"statusId" : "400",
"variant" : "TestVariant",
"extProductId" : "1",
"altExtProductId" : "1",
"extClassificationId" : "1",
"extClassificationGroupId" : "1",
"descShort" : "1",
"descLong" : "1",
"extGlAccountId" : "1",
"priceQuantity" : 1,
"quantityInterval" : 1,
"maxQuantity" : 10,
"minQuantity" : 1,
"leadtimeInDays" : 1,
"salesUnitOfMeasureId" : "ANN",
"timePeriod" : "month",
"visibility" : 0,
"unitOfMeasureId" : "A99",
"cost" : 10,
"currencyId" : "EUR",
"amount" : 1,
"statusDate" : "Jun 1, 2022 12:00:00 AM",
"discount" : 1
} ],
"classificationGroupAssociations" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "basic",
"classificationGroupId" : "text",
"orderNo" : "",
"variant" : ""
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "basic",
"classificationGroupId" : "productbasic",
"orderNo" : "",
"variant" : ""
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "MasterClassification",
"classificationGroupId" : "Commodities",
"orderNo" : "",
"variant" : "TestVariant"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "MasterClassification",
"classificationGroupId" : "ElectricEngineering",
"orderNo" : "",
"variant" : "TestVariant"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "MasterClassification",
"classificationGroupId" : "WorkshopEquipment",
"orderNo" : "",
"variant" : "TestVariant"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"classificationId" : "basic",
"classificationGroupId" : "ProductEnrichmentLevel",
"orderNo" : "",
"variant" : ""
} ],
"docAssociations" : [ {
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"path" : "documents/hotfolder/testproduct.png",
"documentViewTypeId" : "product_image",
"caption" : "text table: \'Test\'",
"orderNo" : 1,
"language" : "",
"description" : "Test",
"validFrom" : "May 3, 2022 12:00:00 AM",
"validTo" : "May 31, 2079 12:00:00 AM",
"status" : "100",
"variant" : "",
"tags" : [
],
"extDocumentId" : "12345",
"udxText1" : "test1",
"udxText2" : "test2",
"udxText3" : "test3",
"udxNum1" : 1,
"udxNum2" : 2,
"udxNum3" : 3,
"udxSortKey1" : "4",
"udxSortKey2" : "test",
"udxSortKey3" : "test"
},{
"createdOn" : "May 9, 2022 9:44:34 AM",
"changedOn" : "May 9, 2022 9:44:34 AM",
"path" : "documents/hotfolder/testproduct.png",
"documentViewTypeId" : "preview",
"caption" : "text table: \'test\'",
"orderNo" : 1,
"language" : "",
"description" : "test",
"validFrom" : "May 25, 2022 12:00:00 AM",
"validTo" : "May 25, 2078 12:00:00 AM",
"status" : "100",
"variant" : "",
"tags" : [
],
"extDocumentId" : "13579",
"udxText1" : "test1",
"udxText2" : "test2",
"udxText3" : "test3",
"udxNum1" : 1,
"udxNum2" : 2,
"udxNum3" : 3,
"udxSortKey1" : "qwr",
"udxSortKey2" : "qwer",
"udxSortKey3" : "qwert"
} ],
"attributeValues" : [ {
"attribute" : "isNew",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "IsChemical",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "ShortDescription",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "TestProductAll" ]
},{
"attribute" : "IsSafety",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "IsNotSearchable",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "Remarks",
"status" : "",
"variant" : "",
"language" : "en-GB",
"values" : [ "Test" ]
},{
"attribute" : "IsEnvironmentallyPreferred",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "LongDescription",
"status" : "",
"variant" : "",
"language" : "de",
"values" : [ "This is a testproduct" ]
},{
"attribute" : "IsFreeShipping",
"status" : "400",
"variant" : "",
"language" : "de-DE",
"values" : [ "true" ]
},{
"attribute" : "convRateSales",
"status" : "400",
"variant" : "",
"language" : "en-GB",
"values" : [ "10" ]
},{
"attribute" : "IsNotStandaloneOrderable",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "false" ]
},{
"attribute" : "PackagingUoMId",
"status" : "",
"variant" : "",
"language" : "de-DE",
"values" : [ "Yes" ]
} ]
} ]
}