AddPersonPicture
Adds a picture to a specified person record.
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 AddPersonPicture are Id and 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 AddPersonPicture Id = '1', FileLocation = 'C:\\Users\\Downloads\\download.jpg'
Input
| Name | Type | Accepts Input Streams | Description |
| Id | Integer | False | ID of a person. |
| CropX | Integer | False | X coordinate to where start cropping form in pixels. |
| CropY | Integer | False | Y coordinate to where start cropping form in pixels. |
| CropWidth | Integer | False | Width of cropping area in pixels. |
| CropHeight | Integer | False | Height of cropping area in pixels. |
| FileLocation | String | False | File to upload. |
| Content | String | True | The content as InputStream to be uploaded when FileLocation is not specified. |
| FileName | String | False | File name that is uploaded. |
Result Set Columns
| Name | Type | Description |
| Status | String | Execution status of the stored procedure. |