xml parse from API response

Question

There's an API that I am experimenting with that outputs XML.

Could anyone tell me if I have something wrong my code to parse the API response or is it a problem with the API itself?

I can use a put command with this:

import requests
import xml
from xml.etree import ElementTree

response = requests.post("https://openadrtester.herokuapp.com/api/v1/cpp/senorio/three")
string_xml = response.content
tree = xml.etree.ElementTree.fromstring(string_xml)

xml.etree.ElementTree.dump(tree)

But it will error out on:

Traceback (most recent call last):
  File "C:\Users\bbartling\OneDrive - Slipstream\Desktop\myAPI\tut\test.py", line 7, in <module>
    tree = xml.etree.ElementTree.fromstring(string_xml)
  File "C:\Users\bbartling\AppData\Local\Programs\Python\Python37\lib\xml\etree\ElementTree.py", line 1315, in XML
    parser.feed(text)
  File "<string>", line None
xml.etree.ElementTree.ParseError: not well-formed (invalid token): line 1, column 0

XML is also viewable through the browser on a get request:

https://openadrtester.herokuapp.com/

What does string_xml contain if you print() it in your code? — jordanm
– jordanm, Commented Oct 27, 2020 at 19:01
b'{"notification": "True", "startTime": "2:00PM", "duration": "6 Hours", "randomization": "None", "rampUp": "None", "recovery": "None", "numberOfSignals": "2", "signalNameSimple": [{"signalType": "level", "units": "None", "numberOfIntervals": "None", "intervalDuration": "None", "typicalIntervalValues": "1,2,1", "signalTarget": "None"}], "signalNameElectricityPrice": [{"signalType": "price", "units": "USD per kWh", "numberOfIntervals": "3", "intervalDuration": "1 hour,4 hour,1 hour", "typicalIntervalValues": "$0.50,$0.75,$0.50", "signalTarget": "None"}]}\n' — bbartling
– bbartling, Commented Oct 27, 2020 at 19:01

Andrej Kesely · Accepted Answer · 2020-10-27 19:12:53Z

2

The data is not XML, but Json (parse it with .json() method, then access like normal python structure):

import json
import requests

response = requests.post("https://openadrtester.herokuapp.com/api/v1/cpp/senorio/three")
data = response.json()

print(json.dumps(data, indent=4))

Prints:

{
    "notification": "True",
    "startTime": "2:00PM",
    "duration": "6 Hours",
    "randomization": "None",
    "rampUp": "None",
    "recovery": "None",
    "numberOfSignals": "2",
    "signalNameSimple": [
        {
            "signalType": "level",
            "units": "None",
            "numberOfIntervals": "None",
            "intervalDuration": "None",
            "typicalIntervalValues": "1,2,1",
            "signalTarget": "None"
        }
    ],
    "signalNameElectricityPrice": [
        {
            "signalType": "price",
            "units": "USD per kWh",
            "numberOfIntervals": "3",
            "intervalDuration": "1 hour,4 hour,1 hour",
            "typicalIntervalValues": "$0.50,$0.75,$0.50",
            "signalTarget": "None"
        }
    ]
}

EDIT: To modify request header to obtain XML:

import requests

response = requests.post("https://openadrtester.herokuapp.com/api/v1/cpp/senorio/three", headers={'Accept': 'application/xml'})
print(response.text)

Prints:

<?xml version="1.0" ?><response><notification>True</notification><startTime>2:00PM</startTime><duration>6 Hours</duration><randomization>None</randomization><rampUp>None</rampUp><recovery>None</recovery><numberOfSignals>2</numberOfSignals><signalNameSimple><signalType>level</signalType><units>None</units><numberOfIntervals>None</numberOfIntervals><intervalDuration>None</intervalDuration><typicalIntervalValues>1,2,1</typicalIntervalValues><signalTarget>None</signalTarget></signalNameSimple><signalNameElectricityPrice><signalType>price</signalType><units>USD per kWh</units><numberOfIntervals>3</numberOfIntervals><intervalDuration>1 hour,4 hour,1 hour</intervalDuration><typicalIntervalValues>$0.50,$0.75,$0.50</typicalIntervalValues><signalTarget>None</signalTarget></signalNameElectricityPrice></response>

edited Oct 27, 2020 at 19:12

answered Oct 27, 2020 at 19:02

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

3 Comments

bbartling Over a year ago

When people use like a curl -i -H "Accept: application/xml" is the -H a header arg?

bbartling Over a year ago

If so Is it easy to modify my requests script for that?

bbartling Over a year ago

Would there be any chance you could help me out with this one? :) stackoverflow.com/questions/64573932/…

Collectives™ on Stack Overflow

xml parse from API response

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related