CData Python Connector for Pipedrive

Build 23.0.8839


Get details of Persons file.


The 本製品 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 本製品.

  • 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


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.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

使用できる値は次のとおりです。0, 1

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839