ODBC Driver for Pipedrive

Build 24.0.9062

CurrentUsers

Returns data about an authorized user within the company with bound company data: company ID, company name, and domain.

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.

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.

デフォルト値はtrueです。

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

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