Files
Returns data about all files.
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.
- Id supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Files WHERE Id = 400
UPDATE
Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Files SET Name = 'Updating PipeDrive Pipelines1' WHERE Id = 405
DELETE
Delete can be executed by specifying the Id in the WHERE Clause.
For example:
DELETE FROM Files WHERE Id = 400
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Integer | True |
ID of the file. |
ActiveFlag | Boolean | True |
ActiveFlag. |
ActivityId | String | True |
ID of the activity to associate file. |
AddTime | Datetime | True |
AddTime. |
Cid | String | True |
Cid. |
DealId | String | True |
ID of the deal to associate file. |
DealName | String | True |
DealName. |
Description | String | False |
Description of the file. |
FileName | String | True |
FileName. |
FileSize | Integer | True |
FileSize. |
FileType | String | True |
FileType. |
InlineFlag | Boolean | True |
InlineFlag. |
LogId | String | True |
LogId. |
MailMessageId | String | True |
MailMessageId. |
MailTemplateId | String | True |
MailTemplateId. |
Name | String | False |
Visible name of the file. |
OrgId | String | True |
ID of the organization to associate file. |
OrgName | String | True |
OrgName. |
PersonId | Integer | True |
ID of the person to associate file. |
PersonName | String | True |
PersonName. |
ProductId | String | True |
ID of the product to associate file. |
ProductName | String | True |
ProductName. |
RemoteId | String | True |
RemoteId. |
RemoteLocation | String | True |
RemoteLocation. |
S3Bucket | String | True |
S3Bucket. |
UpdateTime | Datetime | True |
UpdateTime. |
Url | String | True |
Url. |
UserId | Integer | True |
UserId. |
LeadId | String | True |
LeadId. |
LeadName | String | True |
LeadName. |