How to extract and parse value of XML Memo field from XTKWORKFLOW table in Adobe Campaign Classic

[Shruti1]

Hi All,

Please help

How Can we extract and parse value of XML Memo field from XTKWORKFLOW table in Adobe Campaign Classic

[Craig_Thonis · Accepted solution]

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/30...

Regards,

Craig

[Amine_Abedour]

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,

[Shruti1]

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

[Shruti1]

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