Insert records into Recipient and Custom Table | Community
Skip to main content
S
sreev97350841
Level 2
June 26, 2019
Solved

Insert records into Recipient and Custom Table

  • June 26, 2019
  • 4 replies
  • 3262 views

Hello,

We are using the Recipient table to store the customer attributes and also created a custom table to store several customer extension attributes. This is a 1:1 relationship.

I'm trying to insert records into the Recipient and the Custom table in a single workflow. Is this possible or do i need separate workflows for each Target dimension?

Any other suggestions on how to insert records into Recipients and the Custom table??

Thanks for your help

Sree

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

    Use reconciliation on key, or straight insert (no update) if that’s your use case.

    4 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor
    Community Advisor
    June 26, 2019

    Hi,

    Have the 'Update data' activity for nms:recipient output a transition, then connect it to a 2nd update activity for your custom table.

    The outgoing transition will have the pk's of the upserted nms:recipient rows to use for your custom table's recipient-id fk.

    If the relationship is the other way (recipient table has fk's to custom table), reverse the above order.

    Thanks,

    -Jon

      S
      sreev97350841Author
      Level 2
      June 26, 2019

      Thanks Jon.

      I tried the approach and running into this error message. Do we need to perform any transformation before the 2nd Update activity?

      06/26/2019 5:38:48 PM writer2 WKF-560029 The document types of inbound events ('srm:Custom' and 'nms:recipient') are incompatible (step 'Insert Recipients'). Unable to perform the operation.

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity AdvisorAccepted solution
      Community Advisor
      June 26, 2019

      Use reconciliation on key, or straight insert (no update) if that’s your use case.

        S
        sreev97350841Author
        Level 2
        June 26, 2019

        Straight Insert worked. I'll add the reconciliation step too. Thanks for your help

        Terms & ConditionsAccessibility statement

        Loading footer...