| Author | Message | 
		
		  | malammik | 
			  
				|  Posted: Mon Apr 18, 2005 9:22 am    Post subject: Reading XML Attribute with namespace |   |  | 
		
		  |  Partisan
 
 
 Joined: 27 Jan 2005Posts: 397
 Location: Philadelphia, PA
 
 | 
			  
				| I have an XML which begins like this **************************************************
 <?xml version="1.0" encoding="UTF-8"?>
 <!--Sample XML file generated by XMLSPY v2004 rel. 4 U (http://www.xmlspy.com)-->
 <ArchMessage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="c:\xml\ArchMessage.xsd">
 <Id>2</Id>
 <PubSubService>
 <Subscription xsi:type="XPathPlusSubscription" >
 ***************************************************
 When I try to access the type attribute like this
 InputRoot.XML.ArchMessage.PubSubService.Subscription.(XML.Attribute)type
 OR
 InputRoot.XML.ArchMessage.PubSubService.Subscription.(XML.Attribute)xsi:type
 I am not getting the value. I know that this is wrong 100% because of namespaces. How do I access this namespaced attribute correctly?
 
 My input format is XML should it be XMLNS? What changes should I make in ESQL to get the value of the attribute?
 
 Thanks a lot.
 _________________
 Mikhail Malamud
 http://www.netflexity.com
 http://groups.google.com/group/qflex
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | frankies | 
			  
				|  Posted: Mon Apr 18, 2005 11:52 pm    Post subject: About the namespace. |   |  | 
		
		  | Newbie
 
 
 Joined: 07 Mar 2005Posts: 6
 
 
 | 
			  
				| Add ''  DECLARE xsi NAMESPACE 'http://schemas.xmlsoap.org/soap/envelope/';
 "
 before
 "
 InputRoot.XML.ArchMessage.PubSubService.Subscription.(XML.Attribute)xsi:type
 "
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | malammik | 
			  
				|  Posted: Sat Apr 23, 2005 8:55 am    Post subject: |   |  | 
		
		  |  Partisan
 
 
 Joined: 27 Jan 2005Posts: 397
 Location: Philadelphia, PA
 
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | malammik | 
			  
				|  Posted: Sat Apr 23, 2005 9:01 am    Post subject: |   |  | 
		
		  |  Partisan
 
 
 Joined: 27 Jan 2005Posts: 397
 Location: Philadelphia, PA
 
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | malammik | 
			  
				|  Posted: Sat Apr 23, 2005 4:10 pm    Post subject: |   |  | 
		
		  |  Partisan
 
 
 Joined: 27 Jan 2005Posts: 397
 Location: Philadelphia, PA
 
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | dipankar | 
			  
				|  Posted: Mon Apr 25, 2005 2:19 am    Post subject: hello |   |  | 
		
		  | Disciple
 
 
 Joined: 03 Feb 2005Posts: 171
 
 
 | 
			  
				| you can use FIELDVALUE function to get the attribute value in XML domain. Please see the following ESQL code-
 FIELDVALUE(InputBody.ArchMessage.PubSubService.Subscription ."xsi:type");
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | malammik | 
			  
				|  Posted: Mon Apr 25, 2005 7:01 am    Post subject: |   |  | 
		
		  |  Partisan
 
 
 Joined: 27 Jan 2005Posts: 397
 Location: Philadelphia, PA
 
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  |  |