ProductsFiles
Returns all files attached to the specified product, including file metadata and associated entity references.
View-Specific Information
SELECT
The provider uses 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 provider.
| Column | Supported Operators |
| ProductId | = |
| IncludeDeletedFiles | = |
For example, the following queries are processed server-side:
SELECT * FROM ProductsFiles WHERE ProductId = 6
SELECT * FROM ProductsFiles WHERE ProductId = 6 AND IncludeDeletedFiles = 0
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the file. | |
| ActiveFlag | Boolean | Whether the file is active and not deleted. | |
| AddTime | Datetime | The date and time when the file was added. | |
| Description | String | The text description associated with the file. | |
| FileName | String | The original name of the file as uploaded. | |
| FileSize | Integer | The size of the file in bytes. | |
| FileType | String | The MIME type or format category of the file. | |
| InlineFlag | Boolean | Whether the file is used as an inline attachment in an email rather than a standalone upload. | |
| Name | String | The display name of the file. | |
| ProductId | String |
Products.id | The unique identifier of the product the file is attached to. |
| ProductName | String | The name of the product the file is attached to. | |
| RemoteId | String | The identifier of the file in the remote storage system. | |
| RemoteLocation | String | The name of the remote storage service where the file is hosted, for example googledrive. | |
| S3Bucket | String | The S3 bucket name where the file is stored. | |
| UpdateTime | Datetime | The date and time when the file record was last updated. | |
| Url | String | The URL to access or download the file. | |
| UserId | Integer | The unique identifier of the user who uploaded the file. |