JDBC Driver for Pipedrive

Build 24.0.9060

UsersPermissions

Lists the followers of a specific user.

Select

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

  • UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM UsersPermissions WHERE UserId = 13822542

Columns

Name Type Description
UserId Integer ID of the user.
CanAddCustomFields Boolean CanAddCustomFields.
CanBulkEditItems Boolean CanBulkEditItems.
CanChangeVisibilityOfItems Boolean CanChangeVisibilityOfItems.
CanCreateOwnWorkflow Boolean CanCreateOwnWorkflow.
CanModifyOwnerForDeals Boolean CanModifyOwnerForDeals.
CanDeleteDeals Boolean CanDeleteDeals.
CanConvertDealsToLeads Boolean CanConvertDealsToLeads.
CanMergeDeals Boolean CanMergeDeals.
CanEditDealsClosedDate Boolean CanEditDealsClosedDate.
CanModifyOwnerForLeads Boolean CanModifyOwnerForLeads.
CanDeleteLeads Boolean CanDeleteLeads.
CanMergeLeads Boolean CanMergeLeads.
CanSeeDealsListSummary Boolean CanSeeDealsListSummary.
CanAddDeals Boolean CanAddDeals.
CanEditOtherUsersDeals Boolean CanEditOtherUsersDeals.
CanAddLeads Boolean CanAddLeads.
CanEditOtherUsersLeads Boolean CanEditOtherUsersLeads.
CanEditCustomFields Boolean CanEditCustomFields.
CanDeleteCustomFields Boolean CanDeleteCustomFields.
CanUseImport Boolean CanUseImport.
CanModifyLabels Boolean CanModifyLabels.
CanExportDataFromLists Boolean CanExportDataFromLists.
CanShareFilters Boolean CanShareFilters.
CanEditSharedFilters Boolean CanEditSharedFilters.
CanShareInsights Boolean CanShareInsights.
CanUseEmailTracking Boolean CanUseEmailTracking.
CanSeeOtherUsersStatistics Boolean CanSeeOtherUsersStatistics.
CanSeeCompanyWideStatistics Boolean CanSeeCompanyWideStatistics.
CanSeeOtherUsers Boolean CanSeeOtherUsers.
CanFollowOtherUsers Boolean CanFollowOtherUsers.
CanSeeHiddenItemsNames Boolean CanSeeHiddenItemsNames.
CanModifyOwnerForActivities Boolean CanModifyOwnerForActivities.
CanDeleteActivities Boolean CanDeleteActivities.
CanModifyOwnerForPeople Boolean CanModifyOwnerForPeople.
CanDeletePeople Boolean CanDeletePeople.
CanMergePeople Boolean CanMergePeople.
CanModifyOwnerForOrganizations Boolean CanModifyOwnerForOrganizations.
CanDeleteOrganizations Boolean CanDeleteOrganizations.
CanMergeOrganizations Boolean CanMergeOrganizations.
CanAddProducts Boolean CanAddProducts.
CanEditOtherUsersProducts Boolean CanEditOtherUsersProducts.
CanModifyOwnerForProducts Boolean CanModifyOwnerForProducts.
CanDeleteProducts Boolean CanDeleteProducts.
CanDeleteProductVariations Boolean CanDeleteProductVariations.
CanUseApi Boolean CanUseApi.
CanAddPeople Boolean CanAddPeople.
CanEditOtherUsersPeople Boolean CanEditOtherUsersPeople.
CanAddOrganizations Boolean CanAddOrganizations.
CanEditOtherUsersOrganizations Boolean CanEditOtherUsersOrganizations.

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