FindUsersByName
Finds users by their name.
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Id supports the '=' operator.
- Term supports the '=' operator.
- SearchByEmail supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM FindUsersByName WHERE Term = 'name'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of the user. |
| Activated | Boolean | Activated. |
| ActiveFlag | Boolean | Whether the user is active or not.
The default value is true. |
| Created | Datetime | Created. |
| DefaultCurrency | String | DefaultCurrency. |
| String | Email of the user. | |
| Hascreatedcompany | Boolean | Hascreatedcompany. |
| IconUrl | String | IconUrl. |
| IsAdmin | Integer | IsAdmin. |
| IsYou | Boolean | IsYou. |
| Lang | Integer | Lang. |
| LastLogin | Datetime | LastLogin. |
| Locale | String | Locale. |
| Modified | Datetime | Modified. |
| Name | String | Name of the user. |
| Phone | String | Phone. |
| RoleId | Integer | ID of the role. |
| TimezoneName | String | TimezoneName. |
| TimezoneOffset | String | TimezoneOffset. |
| Access | String | The access given to the user. |
| Term | String | The search term to look for. |
| SearchByEmail | Integer | When enabled, the term will only be matched against email addresses of users.
The default value is false. |