Python Forum
extracting data from XML/SOAP
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
extracting data from XML/SOAP
#2
You are printing just the last entry in the loop because the print in line 49 is outside the loop in line 41.
for obj in publication_objects:
    name = obj.find('d:PublicationObjectName', ns).text
    data = obj.find('d:PublicationObjectData/d:CLSPublicationObjectDataBE', ns)  
    applicable_at = data.find('d:ApplicableAt', ns).text    
    applicable_for = data.find('d:ApplicableFor', ns).text
    value = float(data.find('d:Value', ns).text)
    # Report each entry
    print(name,applicable_at,applicable_for,value)
Either move it inside or collect the parts in lists (or your favourite data structure) and write them later.
Reply


Messages In This Thread
extracting data from XML/SOAP - by hey_arnold - May-06-2018, 08:30 AM
RE: extracting data from XML/SOAP - by killerrex - May-06-2018, 09:52 AM
RE: extracting data from XML/SOAP - by hey_arnold - May-06-2018, 07:44 PM
RE: extracting data from XML/SOAP - by killerrex - May-06-2018, 10:11 PM
RE: extracting data from XML/SOAP - by hey_arnold - May-07-2018, 09:23 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Extracting Data into Columns using pdfplumber arvin 17 5,852 Dec-17-2022, 11:59 AM
Last Post: arvin
  Extracting Data from tables DataExtrator 0 1,164 Nov-02-2021, 12:24 PM
Last Post: DataExtrator
  extracting data ajitnayak1987 1 1,568 Jul-29-2021, 06:13 AM
Last Post: bowlofred
  Extracting and printing data ajitnayak1987 0 1,433 Jul-28-2021, 09:30 AM
Last Post: ajitnayak1987
  Extracting unique pairs from a data set based on another value rybina 2 2,357 Feb-12-2021, 08:36 AM
Last Post: rybina
Thumbs Down extracting data/strings from Word doc mikkelibsen 1 1,964 Feb-10-2021, 11:06 AM
Last Post: Larz60+
  Extracting data without showing dtype, name etc. tgottsc1 3 4,580 Jan-10-2021, 02:15 PM
Last Post: buran
  Extracting data from a website tgottsc1 2 2,301 Jan-09-2021, 08:14 PM
Last Post: tgottsc1
  Extracting data based on specific patterns in a text file K11 1 2,254 Aug-28-2020, 09:00 AM
Last Post: Gribouillis
  Extracting Rows From Data Frame and Understanding The Code JoeDainton123 0 1,465 Aug-03-2020, 04:08 PM
Last Post: JoeDainton123

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020