DESCRIBEINTEGRATIONS()`¶

About DescribeIntegrations¶

Describes one or more zero-ETL or S3 event integrations with Amazon Redshift.

Method Signature¶

METHODS /AWS1/IF_RSH~DESCRIBEINTEGRATIONS
  IMPORTING
    !IV_INTEGRATIONARN TYPE /AWS1/RSHINTEGRATIONARN OPTIONAL
    !IV_MAXRECORDS TYPE /AWS1/RSHINTEGEROPTIONAL OPTIONAL
    !IV_MARKER TYPE /AWS1/RSHSTRING OPTIONAL
    !IT_FILTERS TYPE /AWS1/CL_RSHDSCINTEGRATIONSF00=>TT_DESCRINTEGRATIONSFILTERLIST OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_rshintegrationsmsg
  RAISING
    /AWS1/CX_RSHINTEGRATIONNOTFN00
    /AWS1/CX_RSHUNSUPPORTEDOPFAULT
    /AWS1/CX_RSHCLIENTEXC
    /AWS1/CX_RSHSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING¶

Optional arguments:¶

`iv_integrationarn` `TYPE /AWS1/RSHINTEGRATIONARN` `/AWS1/RSHINTEGRATIONARN`¶

The unique identifier of the integration.

`iv_maxrecords` `TYPE /AWS1/RSHINTEGEROPTIONAL` `/AWS1/RSHINTEGEROPTIONAL`¶

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

`iv_marker` `TYPE /AWS1/RSHSTRING` `/AWS1/RSHSTRING`¶

An optional pagination token provided by a previous DescribeIntegrations request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

`it_filters` `TYPE /AWS1/CL_RSHDSCINTEGRATIONSF00=>TT_DESCRINTEGRATIONSFILTERLIST` `TT_DESCRINTEGRATIONSFILTERLIST`¶

A filter that specifies one or more resources to return.

RETURNING¶

`oo_output` `TYPE REF TO /aws1/cl_rshintegrationsmsg` `/AWS1/CL_RSHINTEGRATIONSMSG`¶

Domain /AWS1/RT_ACCOUNT_ID

Primitive Type NUMC

Examples¶

Syntax Example¶

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->describeintegrations(
  it_filters = VALUE /aws1/cl_rshdscintegrationsf00=>tt_descrintegrationsfilterlist(
    (
      new /aws1/cl_rshdscintegrationsf00(
        it_values = VALUE /aws1/cl_rshdscintegrationsf01=>tt_descrintegrationsfiltvallst(
          ( new /aws1/cl_rshdscintegrationsf01( |string| ) )
        )
        iv_name = |string|
      )
    )
  )
  iv_integrationarn = |string|
  iv_marker = |string|
  iv_maxrecords = 123
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_string = lo_result->get_marker( ).
  LOOP AT lo_result->get_integrations( ) into lo_row.
    lo_row_1 = lo_row.
    IF lo_row_1 IS NOT INITIAL.
      lv_integrationarn = lo_row_1->get_integrationarn( ).
      lv_integrationname = lo_row_1->get_integrationname( ).
      lv_sourcearn = lo_row_1->get_sourcearn( ).
      lv_targetarn = lo_row_1->get_targetarn( ).
      lv_zeroetlintegrationstatu = lo_row_1->get_status( ).
      LOOP AT lo_row_1->get_errors( ) into lo_row_2.
        lo_row_3 = lo_row_2.
        IF lo_row_3 IS NOT INITIAL.
          lv_string = lo_row_3->get_errorcode( ).
          lv_string = lo_row_3->get_errormessage( ).
        ENDIF.
      ENDLOOP.
      lv_tstamp = lo_row_1->get_createtime( ).
      lv_description = lo_row_1->get_description( ).
      lv_string = lo_row_1->get_kmskeyid( ).
      LOOP AT lo_row_1->get_additionalenccontext( ) into ls_row_4.
        lv_key = ls_row_4-key.
        lo_value = ls_row_4-value.
        IF lo_value IS NOT INITIAL.
          lv_string = lo_value->get_value( ).
        ENDIF.
      ENDLOOP.
      LOOP AT lo_row_1->get_tags( ) into lo_row_5.
        lo_row_6 = lo_row_5.
        IF lo_row_6 IS NOT INITIAL.
          lv_string = lo_row_6->get_key( ).
          lv_string = lo_row_6->get_value( ).
        ENDIF.
      ENDLOOP.
    ENDIF.
  ENDLOOP.
ENDIF.

/AWS1/IF_RSH=>DESCRIBEINTEGRATIONS()¶