REST API Limit

Hi there,   I understand that the max results for LiQL query is 1000 (source).   However, when making a call SELECT * FROM messages limit 1000 I get hit with a 414.   I'm struggling to find any...