Web Query Not Working

Question

I've been trying to help out a user who is having issues running a web query from within an Excel spreadsheet. Whenever the query is attempted to run, it gives the error "[Expression.Error] The column 'Row Type' of the table wasn't found."

If you go into the code and try to delete {"Row Type", type text} out of the editor, it will move to the next column and declare whatever is next wasn't found as well.

I tried deleting the applied steps, but it deletes that data within the spreadsheet. The person who uses this spreadsheet only knows what it does so I'm not able to pick his brain to figure out how it works or ask about the code that has been put into it. I tried working with Microsoft but they can't work on it because of the custom code that was put into it. Also, The "Row Type" isn't even used in the spreadsheet. The entire column is blank. Any ideas on how to resolve it?

Answer 1

I tried using that code instead, but it wipes out all of the data for that spreadsheet.

Answer 2

The source link is incorrect for that table. Create new query from the correct source will work.