Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can click “Customize cookies” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To continue without accepting these cookies, click “Continue without accepting.” To make more detailed choices or learn more, click “Customize cookies.”

Skip to content

/AWS1/CL_FNDGETDATAVIEWRSP

Response from retrieving a dataview, which includes details on the target database and table name

CONSTRUCTOR

IMPORTING

Optional arguments:

IV_AUTOUPDATE TYPE /AWS1/FNDBOOLEAN /AWS1/FNDBOOLEAN

Flag to indicate Dataview should be updated automatically.

IT_PARTITIONCOLUMNS TYPE /AWS1/CL_FNDPARTITIONCOLUMNL00=>TT_PARTITIONCOLUMNLIST TT_PARTITIONCOLUMNLIST

Ordered set of column names used to partition data.

IV_DATASETID TYPE /AWS1/FNDDATASETID /AWS1/FNDDATASETID

The unique identifier for the Dataset used in the Dataview.

IV_ASOFTIMESTAMP TYPE /AWS1/FNDTIMESTAMPEPOCH /AWS1/FNDTIMESTAMPEPOCH

Time range to use for the Dataview. The value is determined as epoch time in milliseconds. For example, the value for Monday, November 1, 2021 12:00:00 PM UTC is specified as 1635768000000.

IO_ERRORINFO TYPE REF TO /AWS1/CL_FNDDATAVIEWERRORINFO /AWS1/CL_FNDDATAVIEWERRORINFO

Information about an error that occurred for the Dataview.

IV_LASTMODIFIEDTIME TYPE /AWS1/FNDTIMESTAMPEPOCH /AWS1/FNDTIMESTAMPEPOCH

The last time that a Dataview was modified. The value is determined as epoch time in milliseconds. For example, the value for Monday, November 1, 2021 12:00:00 PM UTC is specified as 1635768000000.

IV_CREATETIME TYPE /AWS1/FNDTIMESTAMPEPOCH /AWS1/FNDTIMESTAMPEPOCH

The timestamp at which the Dataview was created in FinSpace. The value is determined as epoch time in milliseconds. For example, the value for Monday, November 1, 2021 12:00:00 PM UTC is specified as 1635768000000.

IT_SORTCOLUMNS TYPE /AWS1/CL_FNDSORTCOLUMNLIST_W=>TT_SORTCOLUMNLIST TT_SORTCOLUMNLIST

Columns to be used for sorting the data.

IV_DATAVIEWID TYPE /AWS1/FNDDATAVIEWID /AWS1/FNDDATAVIEWID

The unique identifier for the Dataview.

IV_DATAVIEWARN TYPE /AWS1/FNDDATAVIEWARN /AWS1/FNDDATAVIEWARN

The ARN identifier of the Dataview.

IO_DESTINATIONTYPEPARAMS TYPE REF TO /AWS1/CL_FNDDATAVIEWDSTTYPEP00 /AWS1/CL_FNDDATAVIEWDSTTYPEP00

Options that define the destination type for the Dataview.

IV_STATUS TYPE /AWS1/FNDDATAVIEWSTATUS /AWS1/FNDDATAVIEWSTATUS

The status of a Dataview creation.

  • RUNNING – Dataview creation is running.

  • STARTING – Dataview creation is starting.

  • FAILED – Dataview creation has failed.

  • CANCELLED – Dataview creation has been cancelled.

  • TIMEOUT – Dataview creation has timed out.

  • SUCCESS – Dataview creation has succeeded.

  • PENDING – Dataview creation is pending.

  • FAILED_CLEANUP_FAILED – Dataview creation failed and resource cleanup failed.


Queryable Attributes

autoUpdate

Flag to indicate Dataview should be updated automatically.

Accessible with the following methods

Method Description
GET_AUTOUPDATE() Getter for AUTOUPDATE

partitionColumns

Ordered set of column names used to partition data.

Accessible with the following methods

Method Description
GET_PARTITIONCOLUMNS() Getter for PARTITIONCOLUMNS, with configurable default
ASK_PARTITIONCOLUMNS() Getter for PARTITIONCOLUMNS w/ exceptions if field has no va
HAS_PARTITIONCOLUMNS() Determine if PARTITIONCOLUMNS has a value

datasetId

The unique identifier for the Dataset used in the Dataview.

Accessible with the following methods

Method Description
GET_DATASETID() Getter for DATASETID, with configurable default
ASK_DATASETID() Getter for DATASETID w/ exceptions if field has no value
HAS_DATASETID() Determine if DATASETID has a value

asOfTimestamp

Time range to use for the Dataview. The value is determined as epoch time in milliseconds. For example, the value for Monday, November 1, 2021 12:00:00 PM UTC is specified as 1635768000000.

Accessible with the following methods

Method Description
GET_ASOFTIMESTAMP() Getter for ASOFTIMESTAMP, with configurable default
ASK_ASOFTIMESTAMP() Getter for ASOFTIMESTAMP w/ exceptions if field has no value
HAS_ASOFTIMESTAMP() Determine if ASOFTIMESTAMP has a value

errorInfo

Information about an error that occurred for the Dataview.

Accessible with the following methods

Method Description
GET_ERRORINFO() Getter for ERRORINFO

lastModifiedTime

The last time that a Dataview was modified. The value is determined as epoch time in milliseconds. For example, the value for Monday, November 1, 2021 12:00:00 PM UTC is specified as 1635768000000.

Accessible with the following methods

Method Description
GET_LASTMODIFIEDTIME() Getter for LASTMODIFIEDTIME

createTime

The timestamp at which the Dataview was created in FinSpace. The value is determined as epoch time in milliseconds. For example, the value for Monday, November 1, 2021 12:00:00 PM UTC is specified as 1635768000000.

Accessible with the following methods

Method Description
GET_CREATETIME() Getter for CREATETIME

sortColumns

Columns to be used for sorting the data.

Accessible with the following methods

Method Description
GET_SORTCOLUMNS() Getter for SORTCOLUMNS, with configurable default
ASK_SORTCOLUMNS() Getter for SORTCOLUMNS w/ exceptions if field has no value
HAS_SORTCOLUMNS() Determine if SORTCOLUMNS has a value

dataViewId

The unique identifier for the Dataview.

Accessible with the following methods

Method Description
GET_DATAVIEWID() Getter for DATAVIEWID, with configurable default
ASK_DATAVIEWID() Getter for DATAVIEWID w/ exceptions if field has no value
HAS_DATAVIEWID() Determine if DATAVIEWID has a value

dataViewArn

The ARN identifier of the Dataview.

Accessible with the following methods

Method Description
GET_DATAVIEWARN() Getter for DATAVIEWARN, with configurable default
ASK_DATAVIEWARN() Getter for DATAVIEWARN w/ exceptions if field has no value
HAS_DATAVIEWARN() Determine if DATAVIEWARN has a value

destinationTypeParams

Options that define the destination type for the Dataview.

Accessible with the following methods

Method Description
GET_DESTINATIONTYPEPARAMS() Getter for DESTINATIONTYPEPARAMS

status

The status of a Dataview creation.

  • RUNNING – Dataview creation is running.

  • STARTING – Dataview creation is starting.

  • FAILED – Dataview creation has failed.

  • CANCELLED – Dataview creation has been cancelled.

  • TIMEOUT – Dataview creation has timed out.

  • SUCCESS – Dataview creation has succeeded.

  • PENDING – Dataview creation is pending.

  • FAILED_CLEANUP_FAILED – Dataview creation failed and resource cleanup failed.

Accessible with the following methods

Method Description
GET_STATUS() Getter for STATUS, with configurable default
ASK_STATUS() Getter for STATUS w/ exceptions if field has no value
HAS_STATUS() Determine if STATUS has a value