MuleSoft Connector for SAP Fieldglass

Build 20.0.7654

Approvals

Query this table for approvals in SAPFieldglass.

View Specific Information

The connector will use the SAP Fieldglass API to process WHERE clause conditions built with the following columns and operators. The remaining filter criteria is executed client-side within the connector.

  • ModuleId supports the '=' operator.
  • WorkItemId supports the '=' operator. This must be used alongside ModuleId.

For example, the following queries are processed server-side:

  SELECT * FROM Approvals WHERE ModuleId='70'
  SELECT * FROM Approvals WHERE ModuleId='70' AND WorkItemId='300'

Columns

Name Type Description
Id [KEY] String The Id of the approval.
ModuleId String The Id of the module this approval belongs to.
ModuleName String The name of the module this approval belongs to.
Ref String The reference of the approval.
Uom String The unit of measure of the approval.
Name String The name of the approval.
Amount Double The amount of the approval.
StartDate Date The start date of the approval.
EndDate Date The end date of the approval.
CreateDate Date The created date of the approval.
CreatorName String The name of the approval's creator.
UniqueName String The unique name of the approval's creator.
EmailId String The id of the email of this approval.
RefVersion Integer The ref version of this approval.
ValidObject Boolean Indicates whether this approval is a valid object or not.
WorkerType String The type of the worker.
WorkerTypeLabel String The label of the worker type.
SourceLink String The source link of the approval.
Others String An aggregate of other properties for this approval.
Status String The status of this approval.
Details String The details of this approval.
ActivityID String The Id of the approval's activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
WorkItemId String The WorkItem Id you want to filter approvals with. This must be used in conjunction with ModuleId.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654