Returns data about all users within the company

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