PersonsFiles
Returns all files attached to a specific person in Pipedrive, including file metadata and links to associated deals, organizations, and leads.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| PersonId | = |
For example, the following query is processed server-side:
SELECT * FROM PersonsFiles WHERE PersonId = 6
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the file. | |
| ActiveFlag | Boolean | Indicates whether the file is active and has not been deleted. | |
| ActivityId | String | Identifier of the activity to which the file is attached. | |
| AddTime | Datetime | Date and time when the file was uploaded. | |
| Cid | String | Content identifier used for inline file references in email messages. | |
| DealId | String | Identifier of the deal to which the file is attached. | |
| DealName | String | Title of the deal to which the file is attached. | |
| Description | String | User-provided description of the file contents. | |
| FileName | String | Original file name as it was uploaded. | |
| FileSize | Integer | Size of the file in bytes. | |
| FileType | String | MIME type or category of the file, for example image or document. | |
| InlineFlag | Boolean | Indicates whether the file is embedded inline within an email message. | |
| LogId | String | Identifier of the activity log entry associated with the file. | |
| MailMessageId | String | Identifier of the mail message to which the file is attached. | |
| MailTemplateId | String | Identifier of the mail template associated with the file. | |
| Name | String | Display name of the file. | |
| OrgId | Integer | Identifier of the organization to which the file is attached. | |
| OrgName | String | Name of the organization to which the file is attached. | |
| PeopleName | String | Full name of the person to whom the file belongs. | |
| PersonId | String |
Persons.Id | Identifier of the person to whom the file is attached. |
| PersonName | String | Full name of the person to whom the file is attached. | |
| ProductId | String | Identifier of the product to which the file is attached. | |
| ProductName | String | Name of the product to which the file is attached. | |
| RemoteId | String | Identifier of the file in the remote storage system. | |
| RemoteLocation | String | Name of the remote storage service where the file is stored, for example googledrive. | |
| S3Bucket | String | Name of the Amazon S3 bucket where the file is stored. | |
| UpdateTime | Datetime | Date and time when the file record was last updated. | |
| Url | String | Download URL for retrieving the file. | |
| UserId | Integer | Identifier of the user who uploaded the file. | |
| LeadId | String | Identifier of the lead to which the file is attached. | |
| LeadName | String | Title of the lead to which the file is attached. |