CurrentUsers
Returns data about an authorized user within the company with bound company data: company ID, company name, and domain.
Select
The connector 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 connector.
- 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. |