Error parsing XML response

[jballard81]

Good afternoon!

I'm using Web.Contents to perform an XML API call. It looks like it's working, but when i drill into the response data i see this exception error:

I've tried to google this error and haven't had any luck. When i run the API call manually and then import the returned XML file, PowerBI recognizes it with no issues.

Thanks!

[jballard81 · Accepted solution]

well after carefully comparing another working call, i found i was missing double quotes around the api address. so to the error's credit, it was pointing me in the right direction!