CurrentUsers
Returns data about an authorized user within the company with bound company data: company ID, company name, and domain.
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.
For example, the following query is processed server side:
SELECT * FROM CurrentUsers SELECT * FROM CurrentUsers WHERE Id = 2
Columns
| Name | Type | References | 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. | |
| CompanyId | Integer | Company Id. | |
| CompanyName | String | Company Name. | |
| CompanyDomain | String | Company Domain. | |
| CompanyCountry | String | Company Country. | |
| CompanyIndustry | String | Company Industry. | |
| LanguageCode | String | Language Code. | |
| CountryCode | String | Country Code. |