Search users

Returns all* user records that match the given search criteria.

If multiple search params are given and `filter_or` is FALSE or not specified, search params are combined in a logical AND operation. Only rows that match *all* search param criteria will be returned.

If `filter_or` is TRUE, multiple search params are combined in a logical OR operation. Results will include rows that match **any** of the search criteria.

String search params use case-insensitive matching. String search params can contain `%` and ’_’ as SQL LIKE pattern match wildcard expressions. example=“dan%” will match “danger” and “Danzig” but not “David” example=“D_m%” will match “Damage” and “dump”

Integer search params can accept a single value or a comma separated list of values. The multiple values will be combined under a logical OR operation - results will match at least one of the given values.

Most search params can accept “IS NULL” and “NOT NULL” as special expressions to match or exclude (respectively) rows where the column is null.

Boolean search params accept only “true” and “false” as values.

(*) Results are always filtered to the level of information the caller is permitted to view. Looker admins can see all user details; normal users in an open system can see names of other users but no details; normal users in a closed system can only see names of other users who are members of the same group as the user.

External Documentation

To learn more, visit the Google Looker documentation.

Basic Parameters

ParameterDescription
Content Metadata IDSearch for users who have access to this content_metadata item.
EmailSearch for the user with this email address.
Filter OrCombine given search criteria in a boolean OR expression.
First NameMatch First name.
Group IDSearch for users who are direct members of this group.
IDMatch User Id.
Last NameMatch Last name.

Advanced Parameters

ParameterDescription
Embed UserSearch for only embed users.
FieldsInclude only these fields in the response.
Is DisabledSearch for disabled user accounts.
LimitNumber of results to return. (used with offset and takes priority over page and per_page).
OffsetNumber of results to skip before returning any. (used with limit and takes priority over page and per_page).
SortsFields to sort by.
Verified Looker EmployeeSearch for user accounts associated with Looker employees.

Example Output

[]

Workflow Library Example

Search Users with Google Looker and Send Results Via Email

Preview this Workflow on desktop