JDBC Driver for Pipedrive

Build 24.0.9060

UsersRoleAssignments

Lists role assignments for a 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 UsersRoleAssignments WHERE UserId = 2

Columns

Name Type Description
UserId Integer ID of the user.
RoleId Integer Role Id.
ParentRoleId Integer Parent Role Id.
Name String Name.
ActiveFlag Boolean Active flag.
Type String Type.

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