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

him_varma's avatar
him_varma
Advisor
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

  • jeffshurtliff's avatar
    jeffshurtliff
    Boss
    5 years ago

    Hi him_varma,

    Thanks for the quick reply and the suggestion!  That's a great workaround!

    Does anyone from Khoros know why email isn't a valid constraint for users in LiQL and if this is a defect or something for which an enhancement request (i.e. idea) should be submitted?

    Thanks!

    Jeff

     

    • DougS's avatar
      DougS
      Khoros Oracle
      5 years ago

      Hi jeffshurtliff ,

      I think at the time we first launched API V2, a decision was made not to support email address as a constraint. You are welcome to submit an idea requesting this.

      Thanks,

      -Doug