Files
Returns all files attached to deals, persons, organizations, products, leads, or activities in the Pipedrive account.
Table-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 |
| Id | = |
For example, the following query is processed server-side:
SELECT * FROM Files WHERE Id = 400
UPDATE
Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated.
For example:
UPDATE Files SET Name = 'Updating PipeDrive Pipelines1' WHERE Id = 405
DELETE
Execute DELETE by specifying the Id in the WHERE clause.
For example:
DELETE FROM Files WHERE Id = 400
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
ID of the file. | |
| ActiveFlag | Boolean | True |
Indicates whether the file is active and visible in the Pipedrive application. | |
| ActivityId | String | True |
ID of the activity to associate file. | |
| AddTime | Datetime | True |
The date and time when the file was uploaded. | |
| Cid | String | True |
The content ID of the file, used to reference inline attachments in email messages. | |
| DealId | String | True |
ID of the deal to associate file. | |
| DealName | String | True |
The name of the deal this file is associated with. | |
| Description | String | False |
Description of the file. | |
| FileName | String | True |
The original file name of the uploaded file. | |
| FileSize | Integer | True |
The size of the file in bytes. | |
| FileType | String | True |
The MIME type or category of the file, such as image, document, or spreadsheet. | |
| InlineFlag | Boolean | True |
Indicates whether the file is embedded inline within an email message rather than attached separately. | |
| LogId | String | True |
The ID of the mail log entry associated with this file. | |
| MailMessageId | String | True |
The ID of the mail message this file is attached to. | |
| MailTemplateId | String | True |
The ID of the mail template this file is associated with. | |
| Name | String | False |
Visible name of the file. | |
| OrgId | String | True |
ID of the organization to associate file. | |
| OrgName | String | True |
The name of the organization this file is associated with. | |
| PersonId | Integer | True |
ID of the person to associate file. | |
| PersonName | String | True |
The name of the person this file is associated with. | |
| ProductId | String | True |
ID of the product to associate file. | |
| ProductName | String | True |
The name of the product this file is associated with. | |
| RemoteId | String | True |
The ID of the file in the remote storage service where it is hosted. | |
| RemoteLocation | String | True |
The name of the remote storage service where this file is hosted, such as googledrive or pipedrive. | |
| S3Bucket | String | True |
The Amazon S3 bucket name where the file is stored, if applicable. | |
| UpdateTime | Datetime | True |
The date and time when the file record was last updated. | |
| Url | String | True |
The direct URL to download or access the file. | |
| UserId | Integer | True |
The ID of the user who uploaded the file. | |
| LeadId | String | True |
The ID of the lead this file is associated with. | |
| LeadName | String | True |
The name of the lead this file is associated with. |