Nested Array Conditions in JOLT

Syed0000 — Tue, 24 Sep 2024 19:51:33 GMT

Hi,

I am trying to group webCategoryId and item with yes/no flag with some conditions inside array.

1 - if webCategoryId variable is present and not empty value then only use webCategoryId, ignore item value if present inside array.

2 - if webCategoryId variable is not present or present with empty value then use item if item value is present inside array.

Could you please advice.

Input

{ "correlationId": "3242a7b4-7929-43b3-9fb6-0d7e173373af", "sourceSystemId": "PCS", "messageTimestamp": "2024-05-03T00:00:00", "id": 1234, "promotionId": 2303, "offerId": 2303, "description": "Members Get Tees $15", "customerDescription": "Members Get Tees $15", "levelCode": 0, "typeCode": 3, "templateId": 4, "couponCode": null, "isCouponCodeRequired": 0, "startDatetime": "2024-06-20T00:00:00", "endDatetime": "2024-06-24T23:59:00", "cancelationDatetime": null, "comments": null, "distributionRuleCode": null, "exclusiveDiscountInd": 0, "tiers": [ { "conditions": [ { "conditionId": 1134, "buySpendType": 0, "buySpendValue": 1, "buyUom": "EA", "conditionsMerch": [ { "conditionMerchId": 85339, "merchandiseLevel": 5, "deptClass": 0, "uniqueClass": 0, "subClass": 0, "uniqueSubClass": 0, "item": "613631673", "diffId": "012", "excludeInd": 0, "cancelDatetime": null, "supplierSite": null, "brandName": null, "class": 0 }, { "conditionMerchId": 85339, "merchandiseLevel": 5, "deptClass": 0, "uniqueClass": 0, "subClass": 0, "uniqueSubClass": 0, "item": "613631674", "webCategoryId": "", "diffId": "012", "excludeInd": 0, "cancelDatetime": null, "supplierSite": null, "brandName": null, "class": 0 }, { "conditionMerchId": 85340, "merchandiseLevel": 5, "deptClass": 0, "uniqueClass": 0, "subClass": 0, "uniqueSubClass": 0, "webCategoryId": "613631673", "diffId": "023", "excludeInd": 1, "cancelDatetime": null, "supplierSite": null, "brandName": null, "class": 0 }, { "conditionMerchId": 85341, "merchandiseLevel": 5, "deptClass": 0, "uniqueClass": 0, "subClass": 0, "uniqueSubClass": 0, "item": "12334", "webCategoryId": "613631673", "diffId": "013", "excludeInd": 0, "cancelDatetime": null, "supplierSite": null, "brandName": null, "class": 0 } ] } ], "rewards": [ { "rewardId": 8127, "changeType": 2, "changeAmount": 15, "changePercent": null, "quantityToDiscount": null, "applyInd": 2, "rewardsMerch": [] } ], "priceRuleAttributes": [ { "type": "CFA", "id": "PR_PATH_NAME", "values": [ "MEMBERS" ] }, { "type": "CFA", "id": "PR_PRICE_RULE_PROMO", "valueBoolean": true }, { "type": "CFA", "id": "PR_TARGET_SEGMENT", "values": [ "PAS_LOGGEDIN", "LOGGEDIN", "PAS_NOT_LOGGEDIN" ] }, { "type": "CFA", "id": "PR_CURR_CONDITION", "values": [ "USD" ] } ] }, { "conditions": [ { "conditionId": 1135, "buySpendType": 0, "buySpendValue": 1, "buyUom": "EA", "conditionsMerch": [ { "conditionMerchId": 85342, "merchandiseLevel": 5, "deptClass": 0, "uniqueClass": 0, "subClass": 0, "uniqueSubClass": 0, "item": "", "categoryId": "613631673", "diffId": "012", "excludeInd": 0, "cancelDatetime": null, "supplierSite": null, "brandName": null, "class": 0 }, { "conditionMerchId": 85343, "merchandiseLevel": 5, "deptClass": 0, "uniqueClass": 0, "subClass": 0, "uniqueSubClass": 0, "item": "", "categoryId": "613631674", "diffId": "023", "excludeInd": 1, "cancelDatetime": null, "supplierSite": null, "brandName": null, "class": 0 } ] } ], "rewards": [ { "rewardId": 8128, "changeType": 2, "changeAmount": 18, "changePercent": null, "quantityToDiscount": null, "applyInd": 2, "rewardsMerch": [] } ], "priceRuleAttributes": [ { "type": "CFA", "id": "PR_PATH_NAME", "values": [ "NON MEMBERS" ] }, { "type": "CFA", "id": "PR_EMPTY_PATH_NAME", "values": [ "NON" ] }, { "type": "CFA", "id": "PR_PRICE_RULE_PROMO", "valueBoolean": true } ] } ], "locations": [ { "location": 10051, "cancelDateTime": null, "action": "INSERT", "locationType": "S" } ], "attributes": { "webCategoryInd": false, "currencyCode": "USD", "priceType": "PROMOTION", "createTimestamp": "2024-05-03T00:00:00", "createUserId": "BRANDIE_YAWS@ANFCORP.COM", "approvalId": "BRANDIE_YAWS@ANFCORP.COM", "lastUpdateProgramId": "PCS", "lastUpdateTimestamp": "2024-05-03T00:00:00", "lastUpdateUserId": "BRANDIE_YAWS@ANFCORP.COM", "emergencyInd": false, "promoTypeCode": "TP" }, "customAttributes": [ { "type": "CFA", "id": "PR_PRICE_RULE_PROMO", "valueBoolean": true } ] }

Spec

[ { "operation": "shift", "spec": { "description": "priceRuleName", "startDateTime": "startDate", "endDateTime": "enddate", "locations": { "0": { "location": "storeLocation" } }, "customAttributes": { "*": { "id": { "PR_PRICE_RULE_PROMO": { "@(2,valueBoolean)": "priceRulePromo" } } } }, "tiers": { "*": { "priceRuleAttributes": { "*": { "id": { "PR_EMPTY_PATH_NAME": { "@(2,values[0])": "emptyPathName" }, "PR_PATH_NAME": { "@(2,values[0])": "pricePaths.paths.[&5].pathName" }, "PR_TARGET_SEGMENT": { "@(2,values)": "pricePaths.paths.[&5].customerCondition[#2].targetSegments" }, "PR_CURR_CD": { "@(2,values[0])": "pricePaths.paths.[&5].currencyCondition[#2].currency" } } } }, "conditions": { "*": { "conditionsMerch": { "*": { "item": { "": { "@(2,excludeInd)": { "0": { "@(4,webCategoryId)": "pricePaths.paths[&9].catalogCondition.category.yes.categoryList[]" }, "1": { "@(4,webCategoryId)": "pricePaths.paths[&9].catalogCondition.category.no.categoryList[]" } } }, "*": { "@(2,excludeInd)": { "0": { "@(4,item)": "pricePaths.paths[&9].catalogCondition.products.yes.productList[]" }, "1": { "@(4,item)": "pricePaths.paths[&9].catalogCondition.products.no.productList[]" } } } } } } } }, "rewards": { "*": { "changeType": "pricePaths.paths.[&3].calculatePrice[&1].calculationType", "changeAmount": "pricePaths.paths.[&3].calculatePrice[&1].amount", "changePercent": "pricePaths.paths.[&3].calculatePrice[&1].percentage", "@(4,promotionId)": "pricePaths.paths.[&3].calculatePrice[&1].RPMPromoId", "@(4,offerId)": "pricePaths.paths.[&3].calculatePrice[&1].RPMCompId", "@(2,priceRuleAttributes)": { "*": { "id": { "PR_CURR_CD": { "@(2,values[0])": "pricePaths.paths.[&7].calculatePrice[&4].currency" } } } } } } } } } } , { "operation": "shift", "spec": { "*": "&", "pricePaths": { "paths": { "*": { "*": "&3.&2[&1].&", "catalogCondition": { "*": { "*": { "*": "&6.&5[&4].&3.&2[#2].&", "$": "&6.&5[&4].&3.&2[#2].include" } } } } } } } } ]

Re: Nested Array Conditions in JOLT

Syed0000 — Thu, 26 Sep 2024 15:31:28 GMT

@SAMSAL did you get a chance to look into it ?

question Nested Array Conditions in JOLT in Support Questions

Nested Array Conditions in JOLT

Re: Nested Array Conditions in JOLT