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.

     

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi simonliucan 

 

Did you manage to solve this problem? If not, maybe you can share how you set up the request in SoapUI with screenshots (removing sensitive info). We can help check whether some small details have been neglected. If you have solved it, can you share the final solution here to help the community?

 

Best Regards,
Community Support Team _ Jing

simonliucan's avatar
simonliucan
Frequent Visitor
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
    Super User
    4 years ago

    simonliucan 

     

    Odd, splitting 1 step into 2 should not fix it.