Power BI Connector for Pipedrive

Build 24.0.9060

FindUsersByName

Finds users by their name.

Select

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

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

Columns

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

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

The default value is false.

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