I have a PowerQuery function o retrieve the contents of a SharePoint list.
let Source = (url as any) => let aSource = OData.Feed(url, null, [Implementation="2.0"]), in #"aSource" in Source
But sometimes the list doesn't exist, and OData REST API calls don't seem to have a nice set of HTTP type response codes. The code bombs out with a msg
OData version 3 and 4 Error The server returned an error: (404) Not found. (List 'ABC' does not exist at site ......)
But if I paste the URL into a browser, I get a XML response, with no HTTP error codes.