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.

     

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

Hi simonliucan 

 

Your SourceURL contains a named query parameter wsdl but you aren't provinding a value for this.  You can try either removing the wsdl part or supplying a value for.

 

Also, try just setting the SoureURL as the website domain e.g. 

 

SourceURL = "htps://www.website.com"

 

 

Then specify the subfolder using the RelativePath e.g.

 

Web.Contents( "https://www.website.com", [ RelativePath = "OrderService.cfc" ] )

 

 

Query Parameters like wsdl can also be specified using the Query field of the Options record, see the documentation:

 

Web.Contents - PowerQuery M | Microsoft Docs

 

Regards

 

Phil

simonliucan's avatar
simonliucan
Frequent Visitor
4 years ago

Thanks Phil, can you give me an exmaple of how to specify wsdl using querying field?