JDBC Driver for Pipedrive

Build 22.0.8462

Files

Returns data about all files.

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.

  • Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Files WHERE Id = 400

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Files SET Name = 'Updating PipeDrive Pipelines1' WHERE Id = 405

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Files WHERE Id = 400

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

ID of the file.

ActiveFlag Boolean True

ActiveFlag.

ActivityId String True

ID of the activity to associate file.

AddTime Datetime True

AddTime.

Cid String True

Cid.

DealId String True

ID of the deal to associate file.

DealName String True

DealName.

Description String False

Description of the file.

FileName String True

FileName.

FileSize Integer True

FileSize.

FileType String True

FileType.

InlineFlag Boolean True

InlineFlag.

LogId String True

LogId.

MailMessageId String True

MailMessageId.

MailTemplateId String True

MailTemplateId.

Name String False

Visible name of the file.

OrgId String True

ID of the organization to associate file.

OrgName String True

OrgName.

PersonId Integer True

ID of the person to associate file.

PersonName String True

PersonName.

ProductId String True

ID of the product to associate file.

ProductName String True

ProductName.

RemoteId String True

RemoteId.

RemoteLocation String True

RemoteLocation.

S3Bucket String True

S3Bucket.

UpdateTime Datetime True

UpdateTime.

Url String True

Url.

UserId Integer True

UserId.

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