Thanks, Selvam. The issue that I think you're having here is that your XML is using namespace, but your XQuery does not use any namespaces. The XQuery does support using a wildcard for the namespace. So when I changed the XQuery to use the wildcard:
/*:OAI-PMH/*:ListSets/*:set/*:setSpec/text() I get back two results: h10255_dryad.148 10255_2 Does this give you what you need? Thanks -Mark > On Sep 13, 2016, at 4:09 PM, Selvam Raman <sel...@gmail.com> wrote: > > This is the sample xml > > <OAI-PMH xmlns="http://www.openarchives.org/OAI/2.0/"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation=" > http://www.openarchives.org/OAI/2.0/ > http://www.openarchives.org/OAI/2.0/OAI-PMH.xsd";> > <responseDate>2016-09-13T20:05:49Z</responseDate> > <request verb="ListSets">http://testing</request> > <ListSets> > <set> > <setSpec>h10255_dryad.148</setSpec> > <setName>test1</setName> > </set> > <set> > <setSpec>10255_2</setSpec> > <setName>test2</setName> > </set> > </ListSets> > </OAI-PMH> > > Thanks, > RS > > On Tue, Sep 13, 2016 at 6:44 PM, Mark Payne <marka...@hotmail.com> wrote: > >> Selvam, >> >> Can you share a sample of your XML? It's hard to tell why it's not working >> without the actual >> data that you're trying to run this against. I can tell you though, that >> you won't have much luck >> using the doc() function. You'd instead want to just omit it all together >> and use /OAI-PMH/... >> >> I tried using the XQuery "/OAI-PMH/ListSets/set/setSpec/text()" against >> the following XML: >> >> <OAI-PMH> >> <ListSets> >> <set> >> <setSpec>test</setSpec> >> </set> >> </ListSets> >> </OAI-PMH> >> >> I got back the expected result of simply "test". >> >> With a sample that is more representative of your actual XML I may be able >> to offer more assistance. >> >> Thanks >> -Mark >> >>> On Sep 13, 2016, at 8:22 AM, Selvam Raman <sel...@gmail.com> wrote: >>> >>> Hi , >>> >>> Need your help techies. >>> >>> I am using GetHttp to pull the data and it is coming as xml file.(have >>> mentioned the url and filename). >>> >>> want to extract field value from the xml using Evaluate Xquery. >>> >>> I have tried this two but nothing is working >>> >>> 1) for $x in doc("selmna.xml")/OAI-PMH/ListSets/set >>> return data($x/setSpec) >>> >>> 2)//setSpec or /OAI-PMH/ListSets/set/setSpec/text() >>> >>> Can you please help me, what am i missing here. >>> >>> -- >>> Selvam Raman >>> "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து" >> >> > > > -- > Selvam Raman > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
