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 | 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. |