JDBC Driver for Pipedrive

Build 22.0.8462

ActivityFields

Returns all activity fields.

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.

For example, the following query is processed server side:

SELECT * FROM ActivityFields

Columns

Name Type Description
Id [KEY] Integer Id.
ActiveFlag Boolean ActiveFlag.
AddTime Datetime AddTime.
AddVisibleFlag Boolean AddVisibleFlag.
BulkEditAllowed Boolean BulkEditAllowed.
DetailsVisibleFlag Boolean DetailsVisibleFlag.
EditFlag Boolean EditFlag.
FieldType String FieldType.
FilteringAllowed Boolean FilteringAllowed.
ImportantFlag Boolean ImportantFlag.
IndexVisibleFlag Boolean IndexVisibleFlag.
Key String Key.
LastUpdatedByUserId String LastUpdatedByUserId.
MandatoryFlag Boolean MandatoryFlag.
Name String Name.
Options String Options.
OrderNr Integer OrderNr.
SearchableFlag Boolean SearchableFlag.
SortableFlag Boolean SortableFlag.
UpdateTime Datetime UpdateTime.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462