Save targetData in broadLogRcp | Community
Skip to main content
Heku_
Heku_
Level 5
February 13, 2024
Question

Save targetData in broadLogRcp

  • February 13, 2024
  • 1 reply
  • 1227 views

Hello, I would like to save all the targetData in a custom XML field in broadLogRcp, i know i can store an attribute from the targetData like this:

But when i do this: 

With tD like:

I get this error when I send the delivery

How can I do it?

Thank you in advance,

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

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

    1 reply

    Marcel_Szimonisz
    Community Advisor
    Marcel_SzimoniszCommunity Advisor
    Community Advisor
    February 14, 2024

    Hello @heku_,
    you need to create memo column that will store you XML as string and then parse back to XML it when needed.

    You can perhaps store JSON instead as string in memo field of broadLog

    This might bring some performance issues when saving a lot of data to broad log. Perhaps you can create another table where you can store the data that will be linked to your deliveryBroadLog table and recipient id


    Marcel

    Heku_
    Heku_Author
    Level 5
    February 14, 2024

    Hello @marcel_szimonisz, what is the exact way?

    I've tried this configuration:

    Schema broadLogRcp:

    Target Mapping additional fields:

    But I get this error:

    ORA-210000 Oracle error: ORA-01747: invalid user.table.column, table.column, or column specification

     

    I've tried the same with "element" instead of "attribute"

      Marcel_Szimonisz
      Community Advisor
      Marcel_SzimoniszCommunity Advisor
      Community Advisor
      February 15, 2024

      I think you cannot save directly entire targetData to each broad log record

      This additional fields on target mapping happens on 1-1 level so you need to build perhaps JSON of all data you need per recipient and then just save it.

      What you need from particular targetData only save those fields you need by creating JSON string on fly in expression builder?
      I think i need more context for this to help you more.




      Marcel


      Terms & ConditionsAccessibility statement

      Loading footer...