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 <[email protected]> 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 <[email protected]> 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 "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
