UploadActivityAttachment
Upload an attachment.
Stored Procedure Specific Information
Oracle Sales allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison.
You can upload the attachment in the following ways:
- You can provide FileLocation to upload an attachment
exec UploadActivityAttachment ActivityNumber=415, Description='test.', Title='asd15asdasd', FileLocation='D:\\abc.txt'
- You can provide FileName and FileContents(Base64 format) to upload an attachment
exec UploadActivityAttachment FileName='test2.txt', ActivityNumber=415, Description='test.', Title='asd15asdasd', FileContents='SGVsbG8gdGhpcyBpcyB0aGUgZmlsZSB'
- You can provide URL to upload an attachment
exec UploadActivityAttachment ActivityNumber=415, Description='test.', Title='asd15asdasd', URL='http://abc.com/qwerty.txt'
- You can provide FileURL to upload an attachment
exec UploadActivityAttachment ActivityNumber=415, Description='test.', Title='asd15asdasd', FileURL='http://abc.com/qwerty.txt'
- You can provide URI to upload an attachment
exec UploadActivityAttachment ActivityNumber=415, Description='test.', Title='asd15asdasd', URI='http://abc.com/qwerty#abc'
- You can provide UploadedText to upload an attachment
exec UploadActivityAttachment ActivityNumber=415, Description='test.', Title='asd15asdasd', UploadedText='sddsfe df d'
Input
| Name | Type | Required | Accepts Input Streams | Description |
| ActivityNumber | String | True | False | The unique alternate identifier for the activity. |
| FileName | String | False | False | The file name of the attachment. |
| AttachedDocumentId | Long | False | False | The unique identifier of the attached document. |
| DatatypeCode | String | False | False | Abbreviation that identifies the data type. |
| DmFolderPath | String | False | False | The folder path of the attachment. |
| DmDocumentId | String | False | False | Value that uniquely identifies the attachment. |
| DmVersionNumber | String | False | False | Version number of the attachment. |
| Url | String | False | False | The URL of the attachment. |
| Uri | String | False | False | The URI of the attachment. |
| FileUrl | String | False | False | The URL of the attachment. |
| ContentRepositoryFileShared | Bool | False | False | Indicates whether the attachment is shared. |
| Title | String | False | False | The title of the attachment. |
| Description | String | False | False | The description of the attachment. |
| ErrorStatusCode | String | False | False | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | False | False | The error message, if any, for the attachment. |
| FileContents | String | False | False | The contents of the attachment (Byte String). It should be base64 encoded. |
| ExpirationDate | Datetime | False | False | The expiration date of the contents in the attachment. |
| AsyncTrackerId | String | False | False | An identifier used for tracking the uploaded files |
| DownloadInfo | String | False | False | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
| PostProcessingAction | String | False | False | The name of the action that can be performed after an attachment is uploaded. |
| CategoryName | String | False | False | The category of the attachment. |
| UploadedText | String | False | False | The text of the attachment. |
| FileLocation | String | False | False | The location of the file that has to be uploaded. |
| Content | String | False | True | The content of the file that has to be uploaded. |
Result Set Columns
| Name | Type | Description |
| AttachedDocumentId | Long | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| FileName | String | The file name of the attachment. |
| DatatypeCode | String | Abbreviation that identifies the data type. |
| DmFolderPath | String | The folder path of the attachment. |
| DmDocumentId | String | Value that uniquely identifies the attachment. |
| DmVersionNumber | String | Version number of the attachment. |
| Url | String | The URL of the attachment. |
| Uri | String | The URI of the attachment. |
| FileUrl | String | The URL of the attachment. |
| UploadedText | String | The text of the attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | Long | The length of the attachment file. |
| UploadedFileName | String | The name of the attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared. |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user who last updated the record. |
| CreatedByUserName | String | The user who created the record. |
| AsyncTrackerId | String | An identifier used for tracking the uploaded files |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
| PostProcessingAction | String | The name of the action that can be performed after an attachment is uploaded. |
| CategoryName | String | The category of the attachment. |