Documents
Gets IDs and header information for all documents in a specified 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.
- InternalId supports the '=' comparison operator.
- ProjectId supports the '=' comparison operator.
SELECT * FROM Documents WHERE InternalId = 'Doc17975275'
SELECT * FROM Documents WHERE ProjectId = 'WS12345'
Columns
| Name | Type | References | Description |
| InternalId [KEY] | String | Specifies the internal ID of the document, assigned by SAP Ariba. | |
| DocVersion | String | Specifies the document version. Ignored for POST and PUT requests. | |
| VersionComment | String | Specifies comments given for the document version. Ignored for POST and PUT requests. | |
| AvailableDocumentActions | String | Specifies actions associated with documents. Possible actions are - Create Folder, Upload Document, Delete Document, Edit Document, Copy Document, Move Document, Publish Document, Lock Document, Unlock Document, Add Document, Save As New Version, Delete Old Version, Revert Version, Replace Document, Delete Document Old Version. | |
| Title | String | Specifies the title (name) of the document. | |
| LocalizedTitle | String | Specifies the locale ID and title of the document. | |
| BaseLanguage | String | Specifies the language used in the sourcing project if there is no translated text for the user's language. | |
| Description | String | Specifies the description of the document. | |
| Type | String | Specifies the document's type. (doc/Choice/Workspace). | |
| Status | String | Specifies the status of the document. Possible values: Pending Selection, Draft, Complete. | |
| AllowedTasks | String | Specifies the tasks allowed for the documents. Possible values: Todo, Review, Approval. | |
| IconType | String | Specifies the document's type. (doc/Choice/Sourcing Project). | |
| DocType | String | Specifies the document type - UI name of the document type. . Possible values: Document, Choice, Sourcing Project. | |
| DocumentCreateType | String | Specifies the document type. This value is available only when the type is choice. Example: ariba. sourcing. rfx. RFXDocument. | |
| FlattenedOwnerUsers | String | Flattened owner users. | |
| LastModified | Datetime | Specifies the date and time the event was last modified. Example: 2022-03-30T06: 55: 08. 978+0000. | |
| CreateDate | Datetime | Specifies the date and time the sourcing project was created. Example: 2022-03-24T16: 50: 16. 242+0000. | |
| IsLocked | Bool | Whether this is locked. | |
| ProcessId | String | A unique process ID. | |
| InternalStatus | String | The internal status of the document. | |
| ParentId | String | Specifies the internal ID of the document's parent folder, assigned by SAP Ariba. Ignored for POST requests. | |
| ParentProjectId | String | Internal ID of the sourcing project, assigned by SAP Ariba. Ignored for POST requests. | |
| ParentIdsTitlesMap | String | Specifies the list of parent project details id and name. | |
| ParentProjectTitle | String | Specifies the parent project title. Example: Sourcing Full Project. | |
| LocalizedParentProjectTitle | String | Specifies the locale ID and title of the parent document. | |
| ParentProjectType | String | Specifies the parent project type. Possible values: CLASSIC_FULL_PROJECT, CLASSIC_QUICK_PROJECT. | |
| LastModifiedByOrgANId | String | Specifies the Ariba Network ID for a user's organization. | |
| LastModifiedByTimeZoneID | String | Specifies the user's time zone. | |
| LastModifiedByLocaleID | String | Specifies the user's locale. | |
| LastModifiedByName | String | Specifies the user's full name (for GET responses). | |
| LastModifiedByOrgName | String | Specifies the organization name of the user. | |
| LastModifiedByUniqueName | String | Specifies the unique name for the user; used as a login ID. | |
| LastModifiedByOrganization | String | Last modified by organization. | |
| LastModifiedByEmailAddress | String | Specifies the email address for the user. | |
| LastModifiedByPasswordAdapter | String | Specifies the password adapter to authenticate the user. Example: PasswordAdapter1 or SourcingSupplierUser. | |
| LastModifiedByIsRecommended | Bool | Last modified by is recommended. | |
| OwnerName | String | User's full name (for GET responses). | |
| OwnerUniqueName | String | Unique name for the user; used as a login ID. | |
| OwnerPasswordAdapter | String | Password adapter to authenticate the user. Example: PasswordAdapter1 or SourcingSupplierUser. | |
| OwnerIsRecommended | Bool | Owner is recommended. | |
| 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. |