Selvam, Looks like you're using a default namespace (xmlns="http://www.openarchives.org/OAI/2.0/";), this makes the XPath querying more difficult as you have to use local-name(), as described in a NiFi email thread here:
http://mail-archives.us.apache.org/mod_mbox/incubator-nifi-users/201605.mbox/%3ccaev8zdx5vdozhyani_pb1mlgpma4ddsenczwd62k1qkn8ag...@mail.gmail.com%3E Regards, Matt On Tue, 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 > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
