This is giving me as Invalid Query in postman.   { "status": "error", "message": "invalid query syntax for SELECT id, email, sso_id FROM users limit 500 offset 500 ORDER BY registration_data.registration_time DESC", "data": { "type": "error_data", "code": 603, "developer_message": "", "more_info": "" }, "metadata": {} } ... View more

@VikasB, @Payal Is it possible to retrieve the user records without using OFFSET parameter? ... View more

https://api.lithium.com/community/2.0/*******/search?api.pretty_print=true&client-id=************&q=SELECT%20count(*)%20FROM%20users ... View more

@VikasB Hey! I tried with your solution but its giving duplicate records as we proceed ahead by increasing offset value. @Payal Is there no another way by which we can retrieve all the records of LiQL Query using REST-API ? ... View more