Excel Add-In for Pipedrive

Build 24.0.9060

UsersRoleSettings

Lists the settings of user assigned role.

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.

  • UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM UsersRoleSettings WHERE UserId = 2

Columns

Name Type Description
UserId Integer ID of the user.
DealDefaultVisibility Integer Deal Default Visibility.
LeadDefaultVisibility Integer Lead Default Visibility.
OrgDefaultVisibility Integer Org Default Visibility.
PersonDefaultVisibility Integer Person Default Visibility.
ProductDefaultVisibility Integer Product Default Visibility.

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