AddFile
Upload a file and associate it with Deal, Person, Organization, Activity or Product.
Stored Procedure-Specific Information
Pipedrive allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. The required columns in AddFile are FileLocation. If FileLocation is not provided, both the Content which is an input stream of the file and FileName with extension should be provided.
To execute this procedure, enter:
EXEC AddFile DealId = '12', FileLocation = 'C:\Users\Downloads\file_example_MP3_1MG.mp3'
Input
| Name | Type | Accepts Input Streams | Description |
| DealId | Integer | False | ID of the deal to associate file(s) with. |
| PersonId | Integer | False | ID of the person to associate file(s) with. |
| OrgId | Integer | False | ID of the organization to associate file(s) with. |
| ProductId | Integer | False | ID of the product to associate file(s) with. |
| ActivityId | Integer | False | ID of the activity to associate file(s) with. |
| FileLocation | String | False | File to upload. |
| FileName | String | False | File name that is uploaded. |
| Content | String | True | The content as InputStream to be uploaded when FileLocation is not specified. |
Result Set Columns
| Name | Type | Description |
| Status | String | Execution status of the stored procedure. |