Retrieve all tasks specified in a sourcing project.

View-Specific Information

Select

The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.

• ProjectId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM Tasks WHERE ProjectId = 'WS12345'

Columns

Name	Type	References	Description
InternalId [KEY]	String		Specifies the internal ID of the task. Example: TSK13758.
ParentId	String		Specifies the parent ID of the task. Sets the phase ID only for the task created in a phase.
PreviousId	String		Specifies the internal ID of the previous task when there are multiple tasks associated with a project. For example, if three tasks are created in a sequence: Task1, Task2 and Task3, then Task2 will have the internal ID of Task1 as the previous ID. Similarly, Task3 will have the internal ID of Task2 as the previous ID.
Title	String		Specifies the title of the task.
LocalizedTaskName	String		Specifies the locale ID and task name of the task.
Status	String		Specifies the status of the task. For example: active, inactive.
AltStatus	String		Specifies the status of the task. Example: In Progress, Not Started.
InternalStatus	String		Specifies the internal task status. Example: InActive, Active.
Description	String		Specifies the task description.
Type	String		Specifies the task type.
InternalType	String		Specifies the internal task type. Example: ToDo, Approval.
Rank	Int		Specifies the rank given to a task.
Dependencies	String		Dependencies.
StartWhenDependenciesComplete	Bool		Start when dependencies complete.
AreDependenciesCompleted	Bool		If true, there are no predecessor tasks or all predecessor tasks are completed. If false, there are one or more predecessor tasks that must be completed before this task can be started.
AvailableTaskActions	String		Specifies actions task owners can perform on the task. Possible values: markStartedAction, markCompletedAction, editTaskAction, deleteTaskAction, associateDocumentAction, editTaskNotification, removeTaskDocumentAction, editTaskAction, deleteTaskAction.
Operation	String		Specifies the current operation being performed on task. Example: Launch Approval, Award Approval, Approval, review.
ReviewerCanEdit	Bool		Reviewer can edit.
ShowPerDocumentDraft	Bool		Show per document draft.
Alert	String		Specify the task priority to indicate a task with a particular risk. You can set the alert manually while creating a task. An icon is added to the right of the task, indicating that the task requires special attention. Possible values: Green: Not yet reached the due date, Yellow: At-risk and needs action, Red: Due date crossed and needs immediate action.
FromSomeTemplate	Bool		Indicates whether the item is created from a template item or a template prototype. It is true if an item was inherited from a project template. It is false if an item was not inherited from a project template.
IsRecurrenceWithOccurence	Bool		If true, this is a recurring phase plan.
ScheduledFrom	String		Specifies the internal ID of the previous schedule of a recurring phase to which the phase for the task belongs. Example: AAP8AGSUT9UgV.
CanSubmitWithoutApprover	Bool		Decides whether approver is required for task submission. If true, the task can be submitted with an empty approval flow. If false, the task cannot be submitted with an empty approval flow.
HasSchedule	Bool		Has schedule.
IsPhase	Bool		Indicates whether the task is a phase. If true, this is a phase.
IsMilestone	Bool		Select Yes to enable the milestone flag to appear next to the task. Use this to communicate the importance of specific tasks to your team.
IsRequired	Bool		Is required.
BeginDate	Datetime		Specifies the date and time the task was created.
PlannedBeginDate	Datetime		Specifies the date and time the task was created.
PlannedBeginDateOffset	Int		Specifies the date and time the task was created.
EndDate	Datetime		Specifies the date and time a task was completed or canceled. Example: 2022-05-31T00: 00: 00. 000+0000.
DueDate	Datetime		Specifies due date and time of the task. Example: 2022-03-31T00: 00: 00. 000+0000.
DueDateOffset	Int		Due date offset.
DueDateFieldPath	String		Due date field path.
LastModified	Datetime		Specifies the date and time the respective task is modified.
TimeCreated	Datetime		Time created.
ParentProjectId	String		Specifies parent project ID of the task.
ParentProjectTitle	String		Specifies the parent project title of the task.
ParentProjectType	String		Specifies the parent project type of the task.
LocalizedParentProjectTitle	String		Specifies the locale ID and title of the parent document.
ParentIdsTitlesMap	String		Specifies the ID and name of parent projects.
DocumentId	String		Specifies the internal ID of the document associated with the task. It is returned in the GET response if there is an associated document. Example: Doc1234.
DocumentProcessId	String		Specifies the process ID of the document associated with the task. It is returned in the GET response if there is an associated document.
DocumentName	String		Specifies the name of the document associated with the task. It is returned in the GET response if there is an associated document.
LocalizedDocumentName	String		Specifies the locale ID and document name of the task.
DocumentType	String		Specifies documents type. Example: doc, Choice, Workspace.
LockDocument	Bool		Lock document.
PerDocumentDraft	Bool		Per document draft.
ProcessId	String		Unique process ID of the task.
FlattenedOwnerUsers	String		Flattened owner users.
Approvers	String		Approvers.
ActiveApproverUsers	String		Specifies user details such as unique name, name, and password adapter for the active approvers.
ApproverGroups	String		Approver groups.
ApprovalRequests	String		Approval requests.
ExternalApprovalEnabled	Bool		Enable or disable external system approval. Possible values: Yes, No.
Observers	String		Specifies users who are assigned as observers for the task.
ObserverGroups	String		Observer groups.
Recipients	String		Specifies the recipients. Values are assigned if the task is of type NotifyTask or notification task.
RecipientGroups	String		Specifies the recipient groups. Values are assigned for notification tasks only (the task type is NotifyTask).
TaskNotificationProfiles	String		Task notification profiles.
OwnerGroupName	String		Specifies the name for the project group.
OwnerGroupUniqueName	String		Specifies the unique name for the project group.
OwnerGroupRoles	String		Specifies the roles assigned to this project group.
OwnerGroupUsers	String		Specifies users in this project group.
OwnerGroupChildGroups	String		Specifies the child groups defined for this project group.
OwnerGroupIsOwner	Bool		Indicates whether the group has Project Owner capabilities. If true, this group has Project Owner capabilities.
OwnerGroupIsGlobal	Bool		Indicates whether the group is a global group. If true, this is a global group (defined for the entire site). If false, this is a project group.
OwnerGroupIsEditable	Bool		Indicates whether the group can be edited. If true, this group can be edited.
OwnerGroupIsDeletable	Bool		Indicates whether the group can be deleted. If true, this group can be deleted.
OwnerUserName	String		User's full name (for GET responses).
OwnerUserUniqueName	String		Unique name for the user; used as a login ID.
OwnerUserPasswordAdapter	String		Password adapter to authenticate the user. Example: PasswordAdapter1 or SourcingSupplierUser.
OwnerUserIsRecommended	Bool		Owner user is recommended.
EnableNotificationOnComment	Bool		If true, SAP Ariba sends email notifications each time someone adds a comment to a task. SAP Ariba sends notifications to all users in the approval (or review) flow except pending approvers (or reviewers).
NotificationProfileInternalId	String		Specifies the internal ID of the task notification profile.
NotificationProfileName	String		Specifies the name of the task notification profile.
NotificationProfileType	Int		Specifies the task notification profile type.
NotificationProfileCompleteRecipients	String		Lists recipients who receive the task completion notifications.
NotificationProfileOverdueRecipients	String		Recipients to get notified for overdue.
NotificationProfileOverdueBegin	Int		Specifies the number of days after the task due date that must elapse before overdue notifications are sent.
NotificationProfileOverdueReminder	Int		Specifies the interval between overdue notifications (the frequency), in days.
NotificationProfilePendingRecipients	String		Specifies the recipients for pending notifications.
NotificationProfilePendingBegin	Int		Specifies the number of days before the task due date when pending notifications are sent.
NotificationProfilePendingReminder	Int		Specifies the interval between pending notifications (the frequency), in days.
NotificationProfileSendComplete	Bool		Indicates whether the notification is sent to the recipients.
NotificationProfileSendOverdue	Bool		Indicates whether the ontime status of the task is overdue. If true, the overdue notifications will be sent when the task is overdue. If false, the task overdue notifications will not be sent.
NotificationProfileSendPending	Bool		Indicates whether the notification is pending. If true, the task due date is within the period for sending pending notifications. If false, the task due date is not within the period for sending pending notifications.
NotificationScheduleFrequency	String		Specifies the frequency at which a notification task sends the notification.
NotificationScheduleOffset	Int		Specifies the day of a month on which the notification must be scheduled for a recurring task. Possible value: 1 - 31.
NotificationScheduleMultiple	Int		Specifies the number of units for the task schedule.
NotificationScheduleNeedsManualCompletion	Bool		Indicates whether the manual completion is required.
NotificationScheduleShouldAutoStartSchedule	Bool		Specifies whether a notification task or phase in a full project should start after predecessor tasks or phases are completed, rather than requiring a project owner or task owner to start it manually. Templates cannot be modified using the API. This field can only be set at the template and project levels for full projects.
NotificationScheduleFirstSendDate	Datetime		Indicates the date and time a notification task sends the first notification. It is calculated based on the values in the Notification schedule fields.
NotificationScheduleFinalSendDate	Datetime		Indicates the date and time a notification task sends the final notification. It is calculated based on the values in the Notification schedule fields.
NotificationScheduleFinalSendDateFieldPath	String		Notification schedule final send date field path.
NotificationScheduleBeforeOrAfter	Int		Indicates the number of days before or after the due date. For example, the value -1 indicates that this is a schedule for pending notifications (notifications sent before a task is due) and 1 indicates that this is a schedule for overdue notifications (notifications sent after a task is due).
ScheduleFrequency	String		Specifies the unit of time for the task schedule. Possible values: Once, Month, Week, Day.
ScheduleOffset	Int		Specifies the day of a month on which the notification must be scheduled for a recurring task. Possible value: 1 - 31.
ScheduleMultiple	Int		Specifies the number of units for the task schedule.
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.