Users
Returns data about all users within the company, including their account status, contact details, role assignments, and access settings.
Table-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 | = |
| SearchByEmail | = |
For example, the following query is processed server-side:
SELECT * FROM Users WHERE Id = 13816635
INSERT
Execute INSERT by specifying the Name, Email, and ActiveFlag columns. You can also insert any columns that are not required.
For example:
INSERT INTO Users (Name, Email, ActiveFlag) VALUES ('CdataIndiaEngineering', '[email protected]', 'true')
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Users SET ActiveFlag = 'false' WHERE Id = 13944807
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
ID of the user. | |
| Activated | Boolean | True |
Whether the user has completed account activation. | |
| ActiveFlag | Boolean | False |
Whether the user is active or not. The default value is true. | |
| Created | Datetime | True |
The date and time when the user account was created. | |
| DefaultCurrency | String | True |
The default currency code used for the user's monetary values. | |
| String | False |
Email of the user. | ||
| Hascreatedcompany | Boolean | True |
Whether the user has created a company in Pipedrive. | |
| IconUrl | String | True |
The URL of the user's profile avatar image. | |
| IsAdmin | Integer | True |
Whether the user has administrator privileges in the company account. | |
| IsYou | Boolean | True |
Whether this user record represents the currently authenticated user. | |
| Lang | Integer | True |
The numeric identifier for the user's preferred interface language. | |
| LastLogin | Datetime | True |
The date and time of the user's most recent login. | |
| Locale | String | True |
The locale code that determines the user's regional formatting preferences for dates and numbers. | |
| Modified | Datetime | True |
The date and time when the user record was last modified. | |
| Name | String | False |
Name of the user. | |
| Phone | String | True |
The phone number associated with the user's account. | |
| RoleId | Integer | True |
ID of the role. | |
| TimezoneName | String | True |
The IANA timezone name representing the user's local timezone. | |
| TimezoneOffset | String | True |
The UTC offset string representing the user's timezone offset. | |
| Access | String | False |
The access given to the user. |