TaskCommentAttachments
Retrieve all task comments attachments.
View-Specific Information
Select
The driver uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- TaskId supports the '=' comparison operator.
- ProjectId supports the '=' comparison operator.
SELECT * FROM TaskCommentAttachments WHERE TaskId = 'TSK17371161'
SELECT * FROM TaskCommentAttachments WHERE ProjectId = 'WS12345'
Columns
Name | Type | References | Description |
TaskId [KEY] | String |
Tasks.InternalId | Specifies internal Id of specified task. |
CommentId [KEY] | String |
TaskComments.Id | Specifies unique Id genarated for each task history record. |
Id [KEY] | String | Specifies internal ID for the attachment, assigned by SAP Ariba. | |
FileName | String | Specifies name of the file. | |
DocumentType | String | Specifies the document's type. (doc/Choice/Workspace). | |
DocumentTypeUiName | String | Specifies the Document type. (Document/Choice/Sourcing Project) - UI name of the document type. | |
ContentType | String | Specifies MIME content type such as text/csv or image/png , this value is set based on the type of file. | |
Size | Long | Specifies length of the attachment, in bytes. Ignored in POST requests. | |
CanDownload | Bool | Set to true, when attachment/document is downloadable, otherwise false. | |
ProjectId [KEY] | String |
Projects.InternalId | Specify the unique identifier of the sourcing project for which you want to fetch task details. Example, Try it out with: WS17371155. |