JDBC Driver for Pipedrive

Build 22.0.8462

PersonsFiles

Get details of Persons file.

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.

  • PersonId supports the '=' operator.
  • IncludeDeletedFiles supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonsFiles WHERE PersonId = 6 

SELECT * FROM PersonsFiles WHERE PersonId = 6 AND IncludeDeletedFiles = 0

Columns

Name Type Description
Id [KEY] Integer Id of the files.
ActiveFlag Boolean Active Flag.
ActivityId String Activity Id.
AddTime Datetime AddTime.
Cid String Cid.
DealId String Deal Id.
DealName String DealName.
Description String Description.
FileName String File Name.
FileSize Integer File Size.
FileType String File Type.
InlineFlag Boolean Inline Flag.
LogId String Log Id.
MailMessageId String MailMessage Id.
MailTemplateId String MailTemplate Id.
Name String Name.
OrgId Integer Org Id.
OrgName String Org Name.
PeopleName String People Name.
PersonId String PersonId.
PersonName String Person Name.
ProductId String Produc tId.
ProductName String Product Name.
RemoteId String Remote Id.
RemoteLocation String Remote Location.
S3Bucket String S3Bucket.
UpdateTime Datetime Update Time.
Url String Url.
UserId Integer UserId.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IncludeDeletedFiles Integer When enabled, the list of files will also include deleted files.

The allowed values are 0, 1.

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