Search Users
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
Parameter | Description |
---|---|
Content Metadata ID | Search for users who have access to this content_metadata item. |
Search for the user with this email address. | |
Filter Or | Combine given search criteria in a boolean OR expression. |
First Name | Match First name. |
Group ID | Search for users who are direct members of this group. |
ID | Match User Id. |
Last Name | Match Last name. |
Advanced Parameters
Parameter | Description |
---|---|
Embed User | Search for only embed users. |
Fields | Include only these fields in the response. |
Is Disabled | Search for disabled user accounts. |
Limit | Number of results to return. (used with offset and takes priority over page and per_page). |
Offset | Number of results to skip before returning any. (used with limit and takes priority over page and per_page). |
Sorts | Fields to sort by. |
Verified Looker Employee | Search 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