CData Python Connector for Pipedrive

Build 23.0.8839


Finds users by their name.


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.
  • Term supports the '=' operator.
  • SearchByEmail supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM FindUsersByName WHERE Term = 'name'


Name Type Description
Id [KEY] Integer ID of the user.
Activated Boolean Activated.
ActiveFlag Boolean Whether the user is active or not.


Created Datetime Created.
DefaultCurrency String DefaultCurrency.
Email 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.
Term String The search term to look for.
SearchByEmail Integer When enabled, the term will only be matched against email addresses of users.


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