Rails nokogiri parse XML file

Question

I'm a little bit confused: could not find in web good examples of parsing xml with nokogiri...

example of my data:

<?xml version="1.0" encoding="UTF-8"?>
<root>
    <rows SessionGUID="6448680D1">
        <row>
            <AnalogueCode>0451103079</AnalogueCode>
            <AnalogueCodeAsIs>0451103079</AnalogueCodeAsIs>
            <AnalogueManufacturerName>BOSCH</AnalogueManufacturerName>
            <AnalogueWeight>0.000</AnalogueWeight>
            <CodeAsIs>OC90</CodeAsIs>
            <DeliveryVariantPriceAKiloForClientDescription />
            <DeliveryVariantPriceAKiloForClientPrice>0.00</DeliveryVariantPriceAKiloForClientPrice>
            <DeliveryVariantPriceNote />
            <PriceListItemDescription />
            <PriceListItemNote />
            <IsAvailability>1</IsAvailability>
            <IsCross>1</IsCross>
            <LotBase>1</LotBase>
            <LotType>1</LotType>
            <ManufacturerName>KNECHT/MAHLE</ManufacturerName>
            <OfferName>MSC-STC-58</OfferName>
            <PeriodMin>2</PeriodMin>
            <PeriodMax>4</PeriodMax>
            <PriceListDiscountCode>31087</PriceListDiscountCode>
            <ProductName>Фильтр масляный</ProductName>
            <Quantity>41</Quantity>
            <SupplierID>30</SupplierID>
            <GroupTitle>Замена</GroupTitle>
            <Price>203.35</Price>
        </row>
        <row>
            <AnalogueCode>0451103079</AnalogueCode>
            <AnalogueCodeAsIs>0451103079</AnalogueCodeAsIs>
            <AnalogueManufacturerName>BOSCH</AnalogueManufacturerName>
            <AnalogueWeight>0.000</AnalogueWeight>
            <CodeAsIs>OC90</CodeAsIs>
            <DeliveryVariantPriceAKiloForClientDescription />
            <DeliveryVariantPriceAKiloForClientPrice>0.00</DeliveryVariantPriceAKiloForClientPrice>
            <DeliveryVariantPriceNote />
            <PriceListItemDescription />
            <PriceListItemNote>[0451103079] Bosch,MTGC@0451103079</PriceListItemNote>
            <IsAvailability>1</IsAvailability>
            <IsCross>1</IsCross>
            <LotBase>1</LotBase>
            <LotType>0</LotType>
            <ManufacturerName>KNECHT/MAHLE</ManufacturerName>
            <OfferName>MSC-STC-1303</OfferName>
            <PeriodMin>3</PeriodMin>
            <PeriodMax>5</PeriodMax>
            <PriceListDiscountCode>102134</PriceListDiscountCode>
            <ProductName>Фильтр масляный</ProductName>
            <Quantity>5</Quantity>
            <SupplierID>666</SupplierID>
            <GroupTitle>Замена</GroupTitle>
            <Price>172.99</Price>
        </row>
      </rows>
</root>

and ruby code:

...
xml_doc  = Nokogiri::XML(response.body)
parts = xml_doc.xpath('/root/rows/row')

with the help of xpath i could do this? also how to get this parts object (row)?

Community · Accepted Answer · 2017-05-23 11:43:33Z

2

You're on the right track. parts = xml_doc.xpath('/root/rows/row') gives you back a NodeSet i.e. a list of the <row> elements.

You can loop through these using each or use row indexes like parts[0], parts[1] to access specific rows. You can then get the values of child nodes using xpath on the individual rows.

e.g. you could build a list of the AnalogueCode for each part with:

codes = []
parts.each do |row|
  codes << row.xpath('AnalogueCode').text
end

Looking at the full example of the XML you're processing there are 2 issues preventing your XPath from matching:

the <root> tag isn't actually the root element of the XML so /root/.. doesn't match
The XML is using namespaces so you need to include these in your XPaths

so there are a couple of possible solutions:

use CSS selectors rather than XPaths (i.e. use search) as suggested by the Tin Man
after xml_doc = Nokogiri::XML(response.body) do xml_doc.remove_namespaces! and then use parts = xml_doc.xpath('//root/rows/row') where the double slash is XPath syntax to locate the root node anywhere in the document
specify the namespaces:

e.g.

xml_doc  = Nokogiri::XML(response.body)
ns = xml_doc.collect_namespaces
parts = xml_doc.xpath('//xmlns:rows/xmlns:row', ns)

codes = []
parts.each do |row|
  codes << xpath('xmlns:AnalogueCode', ns).text
end

I would go with 1. or 2. :-)

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Mar 5, 2015 at 20:05

mikej

66.6k18 gold badges156 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

byCoder Over a year ago

hm... seemd that it return 0 or [] just also how to put it in object?

mikej Over a year ago

Yep, the return value will just be the return from each. To build a list of objects you'd have to do that inside the loop. I'll update the example.

mikej Over a year ago

try doing puts parts.size for the XML included in your question. It should print "2" (for the 2 rows), if not it sounds like the XML structure you're testing with isn't the same as in your question and your /rows/rows/row XPath isn't matching.

byCoder Over a year ago

yes you are right, dynamically i get this: could you take a look please? dl.dropboxusercontent.com/u/59666091/demooc90.xml '/s:Envelope/s:Body/SearchOfferResponse/SearchOfferResult/root/rows' - this didn't work

byCoder Over a year ago

any ideas (file is upper)?

|

the Tin Man · Accepted Answer · 2015-03-05 20:41:09Z

2

First, Nokogiri supports XPath AND CSS. I recommend using CSS because it's more easily read:

doc.search('row')

will return a NodeSet of every <row> in the document.

The equivalent XPath is:

doc.search('//row')

...how to get this parts object (row)?

I'm not sure what that means, but if you want to access individual elements inside a <row>, it's easily done several ways.

If you only want one node inside each of the row nodes:

doc.search('row Price').map(&:to_xml)
# => ["<Price>203.35</Price>", "<Price>172.99</Price>"]

doc.search('//row/Price').map(&:to_xml)
# => ["<Price>203.35</Price>", "<Price>172.99</Price>"]

If you only want the first such occurrence, use at, which is the equivalent of search(...).first:

doc.at('row Price').to_xml
# => "<Price>203.35</Price>"

Typically we want to iterate over a number of blocks and return an array of hashes of the data found:

row_hash = doc.search('row').map{ |row|
  {
    AnalogueCode: row.at('AnalogueCode').text,
    Price: row.at('Price').text,
  }
}
row_hash 
# => [{:AnalogueCode=>"0451103079", :Price=>"203.35"},
#     {:AnalogueCode=>"0451103079", :Price=>"172.99"}]

These are ALL covered in Nokogiri's tutorials and are answered many times here on Stack Overflow, so take the time to read and search.

edited Mar 5, 2015 at 20:41

answered Mar 5, 2015 at 20:20

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

3 Comments

byCoder Over a year ago

could you take a look please? dl.dropboxusercontent.com/u/59666091/demooc90.xml '/s:Envelope/s:Body/SearchOfferResponse/SearchOfferResult/root/rows' - this didn't work

Mathias Müller Over a year ago

@brabertaser1992 Well, you made it look as if there were no namespaces in your input document (by just omitting an important part of the document). But there is a namespace, and most likely you did not register the s: prefix in Nokogiri.

byCoder Over a year ago

any ideas with new file?

Collectives™ on Stack Overflow

Rails nokogiri parse XML file

2 Answers 2

8 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related