UploadAttachment
Upload an attachment to an Act! CRM entity.
Stored Procedures Specific Information
Process of uploading attachment
This stored procedure uploads an attachment to an Act! CRM entity. The required parameters EntityType (accepts a single value: 'activities', 'documents', 'history', or 'notes') and EntityId (accepts a single value) identify the target entity. Specify either the optional FilePath parameter (local path of the file to upload) or the Content parameter (file content as an InputStream) to provide the file data. When using Content (file content as an InputStream), the FileName parameter (including extension) is also required. For example:
Upload from a local file path
EXEC UploadAttachment EntityType = 'notes', EntityId = 'e29228c9-db9e-4b96-bd62-bfa8437a354b', FilePath = 'D:/Logs/kpi.png';
Upload from an input stream
EXEC UploadAttachment EntityType = 'notes', EntityId = 'e29228c9-db9e-4b96-bd62-bfa8437a354b', Content = @inputStream, FileName = 'kpi.png';
Input
| Name | Type | Description |
| EntityType | String | The type of entity to attach the file to.
The allowed values are activities, documents, history, notes. |
| EntityId | String | The unique identifier of the entity. |
| FilePath | String | The local path of the file to upload. |
| FileName | String | The file name including extension. Required when Content is specified instead of FilePath. |
Result Set Columns
| Name | Type | Description |
| DisplayName | String | The display name of the uploaded attachment. |
| FileExtension | String | The file extension of the uploaded attachment (e.g. '.png'). |
| FileName | String | The file name of the uploaded attachment. |
| FileSize | Long | The size of the uploaded attachment in bytes. |
| FileSizeDisplay | String | The human-readable size of the uploaded attachment (e.g. '12 KB'). |
| FileType | String | The registered system file type name of the uploaded attachment (e.g. 'PNG Image'). |
| LastModified | Datetime | The date and time the attachment was last modified. |
| Personal | Boolean | Whether the attachment is personal (true) or shared with the workgroup (false). |
| Status | String | Stored Procedure Execution Status |