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...
Forum Discussion
hkremer, as Parshant mentioned, a 414 error indicates that the URI is too long. For example, when you perform a LiQL query using URI query parameters then it ends up looking something like this: https://community.khoros.com/lithosphere/api/2.0/search?q=SELECT+id,+login,+avatar.profile,+rank,+view_href+FROM+users+WHERE+id+%3D+%22116946%22
So if you are passing quite a few fields in the SELECT portion or have a lengthy WHERE clause then you could technically be hitting the URI limit. In that case, you would need to either reach out to Khoros Support to see about increasing the URI limit or go about the query another way, such as passing the query as a JSON payload instead.
Where are you making the query? Is it within a FreeMarker component/macro/endpoint, or perhaps a REST API call in a script? Or are you seeing it in the API Browser within Studio?
