https://developer.khoros.com/khoroscommunitydevdocs/docs/users
Here is the 'Users' collection's reference. It mentions all the fields, filters as well as sorts you can use with this collection. Example LiQL Query:
SELECT first_name,email,sso_id FROM users LIMIT 50
You can increase or decrease the number of records by using LIMIT records_limit at the end of the query.
You can make API V2 LiQl calls using liql('query') in Freemarker.
Thanks akshays
I am looking for a solution for one time bulk update of users is and work arounds for limitations/restrictions around of SSO_ID and email fields in the LIKE and WHERE clause of LiQL.
I cannot use SSO_ID with LIKE and email in WHERE of LIiQL.
I need this to query/update the data based on filter criteria.
