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

Amine_Abedour
Amine_Abedour
New Participant
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
    New Participant
    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

    Craig_Thonis
    Craig_ThonisAccepted solution
    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

      Terms & ConditionsAccessibility statement

      Loading footer...