Forum Discussion

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
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.