ODBC Driver for Pipedrive

Build 24.0.9062

Users

Returns data about all users within the company

Select

The 本製品 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 本製品.

  • Id supports the '=' operator.
  • SearchByEmail supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Users WHERE Id = 13816635     

INSERT

Insert can be executed by specifying the Name, Email and ActiveFlag columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Users (Name, Email, ActiveFlag) VALUES ('CdataIndiaEngineering', '[email protected]', 'true')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Users SET ActiveFlag = 'false' WHERE Id = 13944807

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

ID of the user.

Activated Boolean False

Activated.

ActiveFlag Boolean False

Whether the user is active or not.

デフォルト値はtrueです。

Created Datetime False

Created.

DefaultCurrency String False

DefaultCurrency.

Email String False

Email of the user.

Hascreatedcompany Boolean False

Hascreatedcompany.

IconUrl String False

IconUrl.

IsAdmin Integer False

IsAdmin.

IsYou Boolean False

IsYou.

Lang Integer False

Lang.

LastLogin Datetime False

LastLogin.

Locale String False

Locale.

Modified Datetime False

Modified.

Name String False

Name of the user.

Phone String False

Phone.

RoleId Integer False

ID of the role.

TimezoneName String False

TimezoneName.

TimezoneOffset String False

TimezoneOffset.

Access String False

The access given to the user.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062