Close

Using xpath queries in SQL

In the ESB Portal exceptions are stored including the original message that can be resubmitted. The original message is stored in column [MessageData] with data format [varchar](max). To extract data fields from the message using xpath queries in SQL, you first have to add the XML namespaces. You can either use function Xml.Value (to get…