Add delivery property to delivery log (without using add data in WF and then targetData) | Community
Skip to main content
LukasPe1
Level 3
January 18, 2023
Question

Add delivery property to delivery log (without using add data in WF and then targetData)

  • January 18, 2023
  • 1 reply
  • 1824 views

Hi,

We have added a custom long field to a delivery template, which is saved in the nmsDelivery-table.

I would like to use the custom field like this AddDays([delivery/@customField], GetDate()) and then save it in a custom datetime field in the broadLogRcp-table upon delivery execution.

I would like to avoid making the change on each delivery-WF in our environment.
In other words: I am looking for a solution where I can make the change on one entity (i.e delivery template or targetMapping).


Can this be done without making a post-processing workflow? What is the best way to do this?

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

1 reply

Shubham_Goyal__
Level 6
January 18, 2023

Hi @lukaspe1 ,

 

You can save the additional fields from nms:Delivery to nms:broadLogRcp using Target Mapping too.

Here is the link to a similar query where I'd suggested the steps as to use Target Mapping,

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-can-i-log-the-final-message-that-show-to-customer-into-nms/m-p/564613#M16951 

 

Let me know if you have any futher questions while achieving this. 🙂

 

Br,

Shubham

LukasPe1
LukasPe1Author
Level 3
January 19, 2023

Thanks for such fast reply.

Do I add this in the nms:recipient target mapping? Or do I need a nms:delivery mapping for this?

Because when trying your suggestion on the nms:recipient mapping, I am stuck on how to reference fields in the delivery-table.

Shubham_Goyal__
Level 6
January 19, 2023

Hi @lukaspe1 ,

 

Yes, the fields you like to pass to your nms:broadLogRcp needs to be added to "nms:recipient" (mapRecipient) Target mapping.

In mapRecipients you need to add the fields (under: Soruce Expression) e.g. [targetData/@feildName] that will be passed from the targeting schema like nms:delivery and then map them to the actual fields (under: Destination) that you have extended in broadLogsRcp table to store this additional data e.g. (@feilds).

Also, you can include information permanently from other tables like the Recipient table by using [recpient/@email].

 

Below screenshot might help you to understand this better. 🙂

 

In the below screenshot the values of emailType, emailSubject is picked from the targeting workflow that is used to send the delivery, and when delivery is processed these data get automatically stored to the destination path of nms:broadLogRcp

 

 

Br,

Shubham