OrganizationsFiles
Returns files attached to a specified organization, including file metadata and links to associated deals, persons, and products.
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 |
| OrgId | = |
For example, the following query is processed server-side:
SELECT * FROM OrganizationsFiles WHERE OrgId = 6
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the file. | |
| ActiveFlag | Boolean | Indicates whether the file is active and not deleted. | |
| ActivityId | String | The identifier of the activity this file is associated with, if any. | |
| AddTime | Datetime | The date and time when the file was uploaded. | |
| Cid | String | The content identifier (CID) used when the file is embedded inline in an email. | |
| DealId | String | The identifier of the deal this file is associated with, if any. | |
| DealName | String | The title of the deal this file is associated with. | |
| Description | String | A user-provided description of the file. | |
| FileName | String | The original file name of the uploaded file. | |
| FileSize | Integer | The size of the file in bytes. | |
| FileType | String | The MIME type or category of the file (for example, image/png or application/pdf). | |
| InlineFlag | Boolean | Indicates whether the file is embedded inline in an email rather than attached as a separate file. | |
| LogId | String | The identifier of the changelog log entry associated with this file. | |
| MailMessageId | String | The identifier of the mail message this file is attached to, if any. | |
| MailTemplateId | String | The identifier of the mail template this file is associated with, if any. | |
| Name | String | The display name of the file as shown in Pipedrive. | |
| OrgId | Integer | The identifier of the organization this file is attached to. | |
| OrgName | String | The name of the organization this file is attached to. | |
| PeopleName | String | The name of the person this file is associated with, if any. | |
| PersonId | String | The identifier of the person this file is associated with, if any. | |
| PersonName | String | The name of the person this file is associated with. | |
| ProductId | String | The identifier of the product this file is associated with, if any. | |
| ProductName | String | The name of the product this file is associated with. | |
| RemoteId | String | The identifier of the file in its remote storage system (for example, Google Drive). | |
| RemoteLocation | String | The name of the remote storage service where the file is hosted (for example, googledrive or s3). | |
| S3Bucket | String | The Amazon S3 bucket name where the file is stored. | |
| UpdateTime | Datetime | The date and time when the file record was last updated. | |
| Url | String | The download URL for accessing the file. | |
| UserId | Integer | The identifier of the user who uploaded the file. | |
| LeadId | String | The identifier of the lead this file is associated with, if any. | |
| LeadName | String | The title of the lead this file is associated with. |