ProductsFiles
Get details of Persons file.
Select
The provider 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 provider.
- 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
Columns
| 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| IncludeDeletedFiles | Integer | When enabled, the list of files will also include deleted files.
The allowed values are 0, 1. |