Raise better error message when requests fail

* Include the body of the response in the error