Forum Discussion

simonliucan's avatar
simonliucan
Frequent Visitor
4 years ago
Solved

xml API call not working

Hi folks,   I was trying to make API call using xml in Power Query but it's not working. It either gives error message "Internal Server Error 500", or returns HTTP code 200, but with Content Length...
Need Help
  • simonliucan's avatar
    simonliucan
    4 years ago

    Yes problem solved, I just separate xml.tables(web.comtents)) into 2 steps:

    Source = web.comtents(SourceURL, content=..., header = options)

    XMLTable = Xml.Tables(Source)

    ......

    and it worked.

    thanks for all your reply.

     

simonliucan's avatar
simonliucan
Frequent Visitor
4 years ago

Thanks Phil.

But I still don't understand, I have already put the xml in the "Body" (see my screenshot), which is the wsdl I believe? What should I put in the query section?

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi simonliucan 

 

The point I'm trying to make is that if you are supplying the request in the Body then do you need to also supply an empty query parameter called wsdl ?

If the request Body contains everything required by the API for a successful request, then why are you also supplying wsdl in the query parameters?

Try removing ?wsdl from the SourceURL.

 

Another thing you could try : all the URL's in your body are HTTP.  They actually redirect to HTTPS if you try to access them in your browser.  So try changing them all to HTTPS e.g. https://www.w3.org/2001/XMLSchema

 

Please bear in mind that I have no access to your API to test it and I have no idea how it works so I am offering advice based on what looks like it might be causing issues.

Regards

Phil