extracting data from XML/SOAP - Printable Version

extracting data from XML/SOAP - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: extracting data from XML/SOAP (/thread-9946.html)

extracting data from XML/SOAP - hey_arnold - May-06-2018

Hi All,

My code below is currently returning:

LNG Stock Level 2016-09-30T14:00:14Z 2016-03-14T00:00:00Z 6722.422335

Which is what I want it to do, however there should be a lot more data than there is. When I look at the XML data that the api returns there is a lot of data points however I cannot get my code to output it all.

It should be doing something like this, but its not:

LNG Stock Level 2016-09-30T14:00:14Z 2016-03-14T00:00:00Z 6722.422335
LNG Stock Level 2016-09-30T14:00:14Z 2016-03-14T00:00:00Z 3048.422335
LNG Stock Level 2016-09-30T14:00:14Z 2016-03-14T00:00:00Z 3430.422335

import requests
from lxml import etree

def getXML():

    toDate = "2016-03-16"
    fromDate = "2016-03-14"
    dateType = "gasday"

    url="http://marketinformation.natgrid.co.uk/MIPIws-public/public/publicwebservice.asmx"
    headers = {'content-type': 'application/soap+xml; charset=utf-8'}

    body ="""<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
        <soap12:Body>
            <GetPublicationDataWM xmlns="http://www.NationalGrid.com/MIPI/">
                <reqObject>
                    <LatestFlag>Y</LatestFlag>
                    <ApplicableForFlag>Y</ApplicableForFlag>
                    <ToDate>%s</ToDate>
                    <FromDate>%s</FromDate>
                    <DateType>%s</DateType>
                    <PublicationObjectNameList>
                        <string>LNG Stock Level</string>
                    </PublicationObjectNameList>
                </reqObject>
            </GetPublicationDataWM>
        </soap12:Body>
    </soap12:Envelope>""" % (toDate, fromDate,dateType)


    response = requests.post(url,data=body,headers=headers)

    return response.content

root = etree.fromstring(getXML())

# map prefix 'd' to the default namespace URI
ns = { 'd': 'http://www.NationalGrid.com/MIPI/'}

publication_objects = root.xpath('//d:CLSMIPIPublicationObjectBE', namespaces=ns)
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)
    
    
print(name,applicable_at,applicable_for,value)

RE: extracting data from XML/SOAP - killerrex - May-06-2018

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.

RE: extracting data from XML/SOAP - hey_arnold - May-06-2018

If I do what you are suggesting it doesn't change how many values it returns, still only one row of data.

If you could provide me a link about how to collect the parts that would be great. Thanks for the reply.

RE: extracting data from XML/SOAP - killerrex - May-06-2018

When I try to run your code this is the result I receive:

Output:<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Body>
    <GetPublicationDataWMResponse xmlns="http://www.NationalGrid.com/MIPI/">
      <GetPublicationDataWMResult>
        <CLSMIPIPublicationObjectBE>
          <PublicationObjectName>LNG Stock Level</PublicationObjectName>
          <PublicationObjectData>
            <CLSPublicationObjectDataBE>
              <ApplicableAt>2016-09-30T14:00:14Z</ApplicableAt>
              <ApplicableFor>2016-03-14T00:00:00Z</ApplicableFor>
              <Value>6722.422335</Value>
              <GeneratedTimeStamp>2016-09-30T14:56:00Z</GeneratedTimeStamp>
              <QualityIndicator> </QualityIndicator>
              <Substituted>N</Substituted>
              <CreatedDate>2016-09-30T14:56:39Z</CreatedDate>
            </CLSPublicationObjectDataBE>
            <CLSPublicationObjectDataBE>
              <ApplicableAt>2016-09-30T14:00:14Z</ApplicableAt>
              <ApplicableFor>2016-03-15T00:00:00Z</ApplicableFor>
              <Value>6406.486959</Value>
              <GeneratedTimeStamp>2016-09-30T14:56:00Z</GeneratedTimeStamp>
              <QualityIndicator> </QualityIndicator>
              <Substituted>N</Substituted>
              <CreatedDate>2016-09-30T14:56:39Z</CreatedDate>
            </CLSPublicationObjectDataBE>
            <CLSPublicationObjectDataBE>
              <ApplicableAt>2016-09-30T14:00:14Z</ApplicableAt>
              <ApplicableFor>2016-03-16T00:00:00Z</ApplicableFor>
              <Value>6064.522162</Value>
              <GeneratedTimeStamp>2016-09-30T14:56:00Z</GeneratedTimeStamp>
              <QualityIndicator> </QualityIndicator>
              <Substituted>N</Substituted>
              <CreatedDate>2016-09-30T14:56:39Z</CreatedDate>
            </CLSPublicationObjectDataBE>
          </PublicationObjectData>
        </CLSMIPIPublicationObjectBE>
      </GetPublicationDataWMResult>
    </GetPublicationDataWMResponse>
  </soap:Body>
</soap:Envelope>

As you can see there is just 1 element CLSMIPIPublicationObjectBE. If what you want is to iterate in all the CLSPublicationObjectDataBE (and not get just the first one) you can do something like:

publication_objects = root.xpath('//d:CLSMIPIPublicationObjectBE', namespaces=ns)
for obj in publication_objects:
    name = obj.find('d:PublicationObjectName', ns).text
    
    for data in obj.findall('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)
    
        print(name,applicable_at,applicable_for,value)

With that the output I get is:

Output:LNG Stock Level 2016-09-30T14:00:14Z 2016-03-14T00:00:00Z 6722.422335
LNG Stock Level 2016-09-30T14:00:14Z 2016-03-15T00:00:00Z 6406.486959
LNG Stock Level 2016-09-30T14:00:14Z 2016-03-16T00:00:00Z 6064.522162

RE: extracting data from XML/SOAP - hey_arnold - May-07-2018

Thanks very helpful