PersonsFiles
Get details of Persons file.
Select
The driver 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 driver.
- PersonId supports the '=' operator.
- IncludeDeletedFiles supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM PersonsFiles WHERE PersonId = 6 SELECT * FROM PersonsFiles WHERE PersonId = 6 AND IncludeDeletedFiles = 0
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of the files. |
| 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 | Produc tId. |
| 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. |