JDBC Driver for Pipedrive

Build 22.0.8462

ProductsFiles

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.

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

For example, the following query is processed server side:

SELECT * FROM ProductsFiles WHERE ProductId = 6 

SELECT * FROM ProductsFiles WHERE ProductId = 6 AND IncludeDeletedFiles = 0

Columns

Name Type Description
Id [KEY] Integer Id of the products.
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 Product Id.
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