FindUsersByName
Finds users by their name.
View-Specific Information
SELECT
The provider uses 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 provider.
| Column | Supported Operators |
| Id | = |
| Term | = |
| SearchByEmail | = |
For example, the following query is processed server-side:
SELECT * FROM FindUsersByName WHERE Term = 'name'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | ID of the user. | |
| Activated | Boolean | Indicates whether the user account has been activated. | |
| ActiveFlag | Boolean | Whether the user is active or not.
The default value is true. | |
| Created | Datetime | The date and time when the user account was created. | |
| DefaultCurrency | String | The ISO currency code set as the default currency for this user. | |
| String | Email of the user. | ||
| Hascreatedcompany | Boolean | Indicates whether the user has created a company account in Pipedrive. | |
| IconUrl | String | The URL of the user's profile picture or avatar. | |
| IsAdmin | Integer | Indicates whether the user has administrator privileges. A value of 1 means the user is an admin. | |
| IsYou | Boolean | Indicates whether this user record represents the currently authenticated user. | |
| Lang | Integer | The language code identifier used for this user's Pipedrive interface. | |
| LastLogin | Datetime | The date and time of the user's most recent login to Pipedrive. | |
| Locale | String | The locale string that determines date, time, and number formatting for this user. | |
| Modified | Datetime | The date and time when the user account was last modified. | |
| Name | String | Name of the user. | |
| Phone | String | The phone number associated with the user account. | |
| RoleId | Integer | ID of the role. | |
| TimezoneName | String | The IANA timezone name used to localize dates and times for this user, such as America/New_York. | |
| TimezoneOffset | String | The UTC offset string representing the user's timezone, such as +05:30. | |
| 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. |