How to retrieve all the users data using LiQL/API with email/SSO_id filter?
Hi All,
New to Khoros and I am trying to figure out how to retrieve and as well as update the bulk users data.
How can I retrieve all the users data using LIQL/ API calls? I need to retrieve all the users to update the email of bulk users (replacing invalid emails with valid emails).
How can I query all the users in our community? also how to use SSO_ID or email with LIKE or MATCH in LiQL to query users that has email/SSO_ID with certain pattern (query all user with email or sso ends with "@company.com").
It seems like email cannot be user in where and SSO_Id cannot be used with LIKE, are there any other ways to apply filter for these two columns?
I do see that API 2.0 results in only 25 records when I execute with below API
https://community.mycompany.com//api/2.0/search?q=select+*+from+users.
Appreciate any direction