ProductsFiles
Get details of Persons file.
Select
The connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| IncludeDeletedFiles | Integer | When enabled, the list of files will also include deleted files.
使用できる値は次のとおりです。0, 1 |