Retrieve task approval requests.

View-Specific Information

Select

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

• ProjectId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM TaskApprovalRequests WHERE ProjectId = 'WS12345'

Columns

Name	Type	References	Description
TaskId [KEY]	String	Tasks.InternalId	Specifies the internal ID of the task. Example: TSK13758.
ApprovalReqId [KEY]	String		Specifies the user ID of the approval requester. Example: useraaa.
Dependencies	String		Specifies the internal ID of the task that was chosen as a predecessor while creating a todo task.
Reason	String		Specifies if a task action is required or optional. Optional tasks can be canceled to dismiss them with no further action. Example: Action is Required.
Status	String		Specifies the status of the task. When approver performs approval, the possible values are: Approved, Rejected, Denied, Ready for approval, Pending for approval.
ApprovalRequired	Bool		Indicates whether approval is required.
UserApprovers	String		Lists users, who are approvers specified during the creation of approval task.
ApproverUsers	String		Lists all the active approver users expanded from groups in the approval flow.
ApproverGroups	String		Lists all groups.
ReadOnly	Bool		Indicates read-only task.
Dependency	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV.
DependencyDependencies	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the internal ID of the task that was chosen as a predecessor while creating a todo task.
DependencyApprovalReqId	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the user ID of the approval requester. Example: useraaa.
DependencyReason	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies if a task action is required or optional. Optional tasks can be canceled to dismiss them with no further action. Example: Action is Required.
DependencyStatus	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the status of the task. When approver performs approval, the possible values are: Approved, Rejected, Denied, Ready for approval, Pending for approval.
DependencyApprovalRequired	Bool		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Indicates whether approval is required.
DependencyUserApprovers	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Lists users, who are approvers specified during the creation of approval task.
DependencyApproverUsers	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Lists all the active approver users expanded from groups in the approval flow.
DependencyApproverGroups	String		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Lists all groups.
DependencyReadOnly	Bool		Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Indicates read-only task.
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.