OrganizationsFiles
Get details of deals 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.
- OrgId supports the '=' operator.
- IncludeDeletedFiles supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM OrganizationsFiles WHERE OrgId = 6 SELECT * FROM OrganizationsFiles WHERE OrgId = 6 AND IncludeDeletedFiles = 0
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of the organizations. |
| 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. |