How message id is dynamically mapped to couponValue table | Community
Skip to main content
P
Poonam_Dogra
Level 4
January 28, 2022
Question

How message id is dynamically mapped to couponValue table

  • January 28, 2022
  • 1 reply
  • 854 views

Greetings All,

We have a custom broadLog table which is separate from recipient table. In order to set up individual-coupons in the custom broadlog schema, I am currently stuck in how to populate message-id from custom broadlog schema to the foreign key of coupon value table.

Kindly help me understand how message- id from nmsBroadlogRcp table is populated in coupon value table once coupons are associated with it, I have checked the target mappings and related stuff but no luck.

Any related information would also be extremely helpful.

Thanks in advanvce!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Kishore_Padamata
Adobe Employee
Kishore_PadamataAdobe Employee
Adobe Employee
February 4, 2022

Hello @poonam_dogra 
From what I can see - when the delivery starts processing, the entries are initially inserted to temp:forecastLog and nms:couponValue. The allocation of broadlogRcp-id (or the message-id in couponValue) is  based on the running sequence (xtkNewId) and it blocks the next x (target) numbers.
Upon the delivery target, the entries will be inserted to broadlogRcp schema from temp:forecastLog.

In your case, maybe you could use an enrichment within the workflow to assign coupons and use targetData.coupon[x] in the delivery. Instead of using coupon module.

Hope this helps!

Terms & ConditionsAccessibility statement

Loading footer...