SSIS Components for SAP Ariba Source

Build 24.0.9060

History

Gets all history specified in a sourcing project.

View-Specific Information

Select

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

  • ProjectId supports the '=' comparison operator.
For example, the following query is processed server side:
SELECT * FROM History WHERE ProjectId = 'WS12345'

Columns

Name Type References Description
Id [KEY] Long Specifies ID of the history record of the sourcing project.
Title String Specifies the title of the respective history record.
Details String Specifies the sourcing project details. Possible values: active, inactive.
Type String Specifies the type of object for the history record. Possible values: Document, Workspace, Folder.
Description String Specifies the description related to the sourcing project. Possible values: startDate, status,owner.
Timestamp Datetime Specifies the date and time of the respective history record.
EffectiveUserName String Specifies the name of the user.
EffectiveUserUniqueName String Specifies the unique name of the user.
EffectiveUserEmailAddress String Specifies the email address of the user.
RealUserName String Specifies the name of the user.
RealUserUniqueName String Specifies the unique name of the user.
RealUserEmailAddress String Specifies the email address of the user.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060