OK, managed to solve my own problem...:) The list has an alias and the OData connection worked when I used that.
The successful OData connection ended up being this:
More specifically, Project Requests had been aliased as Comp Charter Requests. Also, the OData connection requires removal of spaces.
Perhaps this info will help others troubleshooting a connection to a SharePoint list!