Forum Discussion

RhallTalend's avatar
6 years ago

Why cannot I retrieve users.id via users.email address?

  Hi, I am really struggling to figure out why I cannot retrieve a user id from an email address. I have tried the v1 API and keep getting a 100 error. I have tried the v2 API and get the error belo...
  • RhallTalend's avatar
    RhallTalend
    6 years ago

    Thanks Parshant.

    This is frustrating since it is not made very clear. The LiQL language documentation should really make things like this clear since it is based so heavily on SQL which does not have these constraints.

     

    Anyway, I managed to resolve this by using the v1 API.......which is also not very clearly documented. So, to make it clear for others, if you want to use OAuth credentials and the v1 API for this, the URL you need is this....

    https://api.lithium.com/community/v1/{tenant_id}/users/email/user@email.com?restapi.response_format=json

    The headers need to be configured as described in the documentation