Forum Discussion

jeffshurtliff's avatar
jeffshurtliff
Boss
5 years ago

Unable to use the 'email' field in a WHERE clause when using LiQL against the users table

I am trying to figure out how I can retrieve the User ID or login (i.e. username) for a user when I only have their email address using LiQL, but for some reason I am getting an "Invalid query syntax...
  • him_varma's avatar
    him_varma
    5 years ago

    Hi jeffshurtliff 

    It seems that the where clause constraint you are trying to use is not available.

    However as an alternate you can use the v1 API call to fetch user from email. Please find below:

    [yourcommunityurl]/restapi/vc/search/users?q=email:[email id]

    Please let me know if this was helpful.

    Thanks

Tarun's avatar
Tarun
Maven
5 years ago

Hi jeffshurtliff ,

It seems the constraint for the email of the user's that you are trying to users is not supported i.e. you can't pass all fields after where clause.

The constraints that can work with the particular users query are listed over here:

https://devdocportal.lithium.com/t5/Community-API-v2-Reference/bd-p/restv2docs?section=commv2&collection=users#constraints

Please refer to them and see if some other constraints can help you to carry the requirements.

like you can have a query like:

SELECT login FROM users WHERE login LIKE '%jane%'

 

Please Give Kudos if you find this post useful and mark this as Accepted Solution if this is the required solution.


Regards

Tarun Kumar