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

RhallTalend,

This is just because 'email' is not a valid constraint for the object 'users' , and you are using "WHERE users.email='user@email.com'" in the API.

Here is the list of all constraints for users data you can use in V2 API.

https://lithosphere.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=users#constraints

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