SSIS Components for Pipedrive

Build 24.0.9060

ActivityFields

Returns all activity fields.

Select

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

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060