How to extract and parse value of XML Memo field from XTKWORKFLOW table in Adobe Campaign Classic | Community
Skip to main content
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 Craig_Thonis

Hi Shruti,

 

Check out the forum thread below. It's a good example of how to extract individual values from the XML memo field.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/exporting-xml-fields/m-p/303050

 

Regards,

Craig

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
September 25, 2024

Hi Shruti,

 

Check out the forum thread below. It's a good example of how to extract individual values from the XML memo field.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/exporting-xml-fields/m-p/303050

 

Regards,

Craig

    Amine_Abedour
    Community Advisor
    Amine_AbedourCommunity Advisor
    Community Advisor
    September 25, 2024

    Hello @shruti1,

     

    (Sorry for the print screen in French.)

     

    You need to use the 'NodeValue' function.

    For example, if you want to extract the value of 'taskCount', which is an XML attribute of xtk:workflow (so its value is stored in the mData of wtkworkflow), you can do it like this:

    • Query the workflows you want using a query activity.

    • In the same query or in an enrichment, choose to enrich your data.

    • Use the function like this: NodeValue('/workflow/@taskCount', data)

       

    • Result:

    Br,

    Amine ABEDOUR
      S
      Shruti1Author
      Level 4
      September 26, 2024

      hello @amine_abedour 

      thanks for your reply

       

      NodeValue('/workflow/@taskCount', data)

      but m receiving missing right parenthesis error in audit logs are using this

       

       

      please suggest next steps

      Terms & ConditionsAccessibility statement

      Loading footer...