Hi Mark and matt, thanks for the help.
How can i get all the values in single file. Nifi flow: GetHttp, EvaluateXquery and Putfile In putfile i am getting error because the above query executes the number of childs presents. In our example 2 times. So each time it trying to create same filename. How can i get the all the records into a single file. GetHttp: Url :********* Filename: test.xml EvaluateXquery: /*:OAI-PMH/*:ListSets/*:set/*:setSpec/text() putFile: C:\Downloads\Nifi\ i am getting file as C:\Downloads\Nifi\test.xml: this file currently contains only one record. On Wed, Sep 14, 2016 at 1:56 AM, Matt Burgess <[email protected]> wrote: > 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_ > [email protected]%3E > > Regards, > Matt > > On Tue, Sep 13, 2016 at 4:09 PM, Selvam Raman <[email protected]> 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 <[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 > > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து" > -- Selvam Raman "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
