Question Re: XML Namespace Error with XPATH condition in Technology Q&A

XML Namespace Error with XPATH condition

barath_dv — Thu, 12 Dec 2024 13:59:47 GMT

Dear Experts,

We have below as the content which needs to be routed based on the field 'Message' value.

<?xml version="1.0" encoding="utf-8"?> <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> <code>06/019</code> <message xml:lang="en">Document does not exist</message> <innererror> <application> <component_id/> <service_namespace>/SAP/</service_namespace> <service_id>TEST</service_id> <service_version>0001</service_version> </application> <transactionid>d828d56baed54a718432432e7cd27533</transactionid> <timestamp/> <Error_Resolution> <SAP_Transaction/> <SAP_Note>See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)</SAP_Note> </Error_Resolution> <errordetails> <errordetail> <ContentID/> <code>06/033</code> <message>Document does not exist</message> <propertyref/> <severity>error</severity> <target/> <transition>false</transition> </errordetail> </errordetails> </innererror> </error>

Tried the condition = //innererror/errordetails/errordetail[contains(message, 'Document')]

Somehow, it is not working due to the namespace. I've also added the namespace in the runtime configuration as xmlns=http://schemas.microsoft.com/ado/2007/08/dataservices/metadata Still getting invalid namespace declared error.

Appreciate your valuable inputs and support.

Thanks,

Barath Vivekanandan

Re: XML Namespace Error with XPATH condition

Ryan-Crosby — Thu, 12 Dec 2024 14:24:39 GMT

I think you would need to anonymize the XML for your expression to work because it doesn't expect use of a namespace without a prefix. I tested several variations and none of them work for a namespace without a prefix.

Re: XML Namespace Error with XPATH condition

maik_bosch — Fri, 13 Dec 2024 05:55:01 GMT

As an addition to Ryan. I prefer to use XSLT below to clean the XML namespaces:

https://stackoverflow.com/questions/5268182/how-to-remove-namespaces-from-xml-using-xslt

Re: XML Namespace Error with XPATH condition

snayak — Fri, 13 Dec 2024 12:17:04 GMT

Hi Barath, You can use this xml routing condition:- //*:innererror/*:errordetails/*:errordetail[contains(*:message, 'Document')]

Re: XML Namespace Error with XPATH condition

barath_dv — Fri, 24 Jan 2025 11:09:10 GMT

Hi Snayak, Thanks, it worked! Thanks Maik and Ryan for your valuable response.