Skip to content

/AWS1/IF_DYN=>EXPORTTABLETOPOINTINTIME()

About ExportTableToPointInTime

Exports table data to an S3 bucket. The table must have point in time recovery enabled, and you can export data from any time within the point in time recovery window.

Method Signature

METHODS /AWS1/IF_DYN~EXPORTTABLETOPOINTINTIME
  IMPORTING
    !IV_TABLEARN TYPE /AWS1/DYNTABLEARN OPTIONAL
    !IV_EXPORTTIME TYPE /AWS1/DYNEXPORTTIME OPTIONAL
    !IV_CLIENTTOKEN TYPE /AWS1/DYNCLIENTTOKEN OPTIONAL
    !IV_S3BUCKET TYPE /AWS1/DYNS3BUCKET OPTIONAL
    !IV_S3BUCKETOWNER TYPE /AWS1/DYNS3BUCKETOWNER OPTIONAL
    !IV_S3PREFIX TYPE /AWS1/DYNS3PREFIX OPTIONAL
    !IV_S3SSEALGORITHM TYPE /AWS1/DYNS3SSEALGORITHM OPTIONAL
    !IV_S3SSEKMSKEYID TYPE /AWS1/DYNS3SSEKMSKEYID OPTIONAL
    !IV_EXPORTFORMAT TYPE /AWS1/DYNEXPORTFORMAT OPTIONAL
    !IV_EXPORTTYPE TYPE /AWS1/DYNEXPORTTYPE OPTIONAL
    !IO_INCREMENTALEXPORTSPEC TYPE REF TO /AWS1/CL_DYNINCREMENTALEXPPEC OPTIONAL
    !IO_FILTERSPECIFICATION TYPE REF TO /AWS1/CL_DYNFILTERSPEC OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_dynexptbltoptintmout
  RAISING
    /AWS1/CX_DYNEXPORTCONFLICTEX
    /AWS1/CX_DYNINTERNALSERVERERR
    /AWS1/CX_DYNINVEXPORTTIMEEX
    /AWS1/CX_DYNLIMITEXCEEDEDEX
    /AWS1/CX_DYNPTINTIMERECUNAVEX
    /AWS1/CX_DYNTABLENOTFOUNDEX
    /AWS1/CX_DYNCLIENTEXC
    /AWS1/CX_DYNSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING

Required arguments:

iv_tablearn TYPE /AWS1/DYNTABLEARN /AWS1/DYNTABLEARN

The Amazon Resource Name (ARN) associated with the table to export.

iv_s3bucket TYPE /AWS1/DYNS3BUCKET /AWS1/DYNS3BUCKET

The name of the Amazon S3 bucket to export the snapshot to.

Optional arguments:

iv_exporttime TYPE /AWS1/DYNEXPORTTIME /AWS1/DYNEXPORTTIME

Time in the past from which to export table data, counted in seconds from the start of the Unix epoch. The table export will be a snapshot of the table's state at this point in time.

iv_clienttoken TYPE /AWS1/DYNCLIENTTOKEN /AWS1/DYNCLIENTTOKEN

Providing a ClientToken makes the call to ExportTableToPointInTimeInput idempotent, meaning that multiple identical calls have the same effect as one single call.

A client token is valid for 8 hours after the first request that uses it is completed. After 8 hours, any request with the same client token is treated as a new request. Do not resubmit the same request with the same client token for more than 8 hours, or the result might not be idempotent.

If you submit a request with the same client token but a change in other parameters within the 8-hour idempotency window, DynamoDB returns an ExportConflictException.

iv_s3bucketowner TYPE /AWS1/DYNS3BUCKETOWNER /AWS1/DYNS3BUCKETOWNER

The ID of the Amazon Web Services account that owns the bucket the export will be stored in.

S3BucketOwner is a required parameter when exporting to a S3 bucket in another account.

iv_s3prefix TYPE /AWS1/DYNS3PREFIX /AWS1/DYNS3PREFIX

The Amazon S3 bucket prefix to use as the file name and path of the exported snapshot.

iv_s3ssealgorithm TYPE /AWS1/DYNS3SSEALGORITHM /AWS1/DYNS3SSEALGORITHM

Type of encryption used on the bucket where export data will be stored. Valid values for S3SseAlgorithm are:

  • AES256 - server-side encryption with Amazon S3 managed keys

  • KMS - server-side encryption with KMS managed keys

iv_s3ssekmskeyid TYPE /AWS1/DYNS3SSEKMSKEYID /AWS1/DYNS3SSEKMSKEYID

The ID of the KMS managed key used to encrypt the S3 bucket where export data will be stored (if applicable).

iv_exportformat TYPE /AWS1/DYNEXPORTFORMAT /AWS1/DYNEXPORTFORMAT

The format for the exported data. Valid values for ExportFormat are DYNAMODB_JSON or ION.

iv_exporttype TYPE /AWS1/DYNEXPORTTYPE /AWS1/DYNEXPORTTYPE

Choice of whether to execute as a full export or incremental export. Valid values are FULL_EXPORT or INCREMENTAL_EXPORT. The default value is FULL_EXPORT. If INCREMENTAL_EXPORT is provided, the IncrementalExportSpecification must also be used.

io_incrementalexportspec TYPE REF TO /AWS1/CL_DYNINCREMENTALEXPPEC /AWS1/CL_DYNINCREMENTALEXPPEC

Optional object containing the parameters specific to an incremental export.

io_filterspecification TYPE REF TO /AWS1/CL_DYNFILTERSPEC /AWS1/CL_DYNFILTERSPEC

The criteria used to filter which items are included in the point-in-time export. When you specify this parameter, only items that match the key conditions and filter expressions are exported.

RETURNING

oo_output TYPE REF TO /aws1/cl_dynexptbltoptintmout /AWS1/CL_DYNEXPTBLTOPTINTMOUT

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->exporttabletopointintime(
  io_filterspecification = new /aws1/cl_dynfilterspec(
    it_expressionattributenames = VALUE /aws1/cl_dynxprsnattrnamemap_w=>tt_expressionattributenamemap(
      (
        VALUE /aws1/cl_dynxprsnattrnamemap_w=>ts_xprsnattrnamemap_maprow(
          key = |string|
          value = new /aws1/cl_dynxprsnattrnamemap_w( |string| )
        )
      )
    )
    it_expressionattributevalues = VALUE /aws1/cl_dynattributevalue=>tt_expressionattributevaluemap(
      (
        VALUE /aws1/cl_dynattributevalue=>ts_xprsnattrvaluemap_maprow(
          key = |string|
          value = new /aws1/cl_dynattributevalue(
            it_bs = VALUE /aws1/cl_dynbinarysetattrval_w=>tt_binarysetattributevalue(
              ( new /aws1/cl_dynbinarysetattrval_w( '5347567362473873563239796247513D' ) )
            )
            it_l = VALUE /aws1/cl_dynattributevalue=>tt_listattributevalue(
              (
                new /aws1/cl_dynattributevalue(
                  it_bs = VALUE /aws1/cl_dynbinarysetattrval_w=>tt_binarysetattributevalue(
                    ( new /aws1/cl_dynbinarysetattrval_w( '5347567362473873563239796247513D' ) )
                  )
                  it_m = VALUE /aws1/cl_dynattributevalue=>tt_mapattributevalue(
                    (
                      VALUE /aws1/cl_dynattributevalue=>ts_mapattributevalue_maprow(
                        key = |string|
                        value = new /aws1/cl_dynattributevalue(
                          it_bs = VALUE /aws1/cl_dynbinarysetattrval_w=>tt_binarysetattributevalue(
                            ( new /aws1/cl_dynbinarysetattrval_w( '5347567362473873563239796247513D' ) )
                          )
                          it_ns = VALUE /aws1/cl_dynnumsetattrvalue_w=>tt_numbersetattributevalue(
                            ( new /aws1/cl_dynnumsetattrvalue_w( |string| ) )
                          )
                          it_ss = VALUE /aws1/cl_dynstrsetattrvalue_w=>tt_stringsetattributevalue(
                            ( new /aws1/cl_dynstrsetattrvalue_w( |string| ) )
                          )
                          iv_b = '5347567362473873563239796247513D'
                          iv_bool = ABAP_TRUE
                          iv_n = |string|
                          iv_null = ABAP_TRUE
                          iv_s = |string|
                        )
                      )
                    )
                  )
                  it_ns = VALUE /aws1/cl_dynnumsetattrvalue_w=>tt_numbersetattributevalue(
                    ( new /aws1/cl_dynnumsetattrvalue_w( |string| ) )
                  )
                  it_ss = VALUE /aws1/cl_dynstrsetattrvalue_w=>tt_stringsetattributevalue(
                    ( new /aws1/cl_dynstrsetattrvalue_w( |string| ) )
                  )
                  iv_b = '5347567362473873563239796247513D'
                  iv_bool = ABAP_TRUE
                  iv_n = |string|
                  iv_null = ABAP_TRUE
                  iv_s = |string|
                )
              )
            )
            it_m = VALUE /aws1/cl_dynattributevalue=>tt_mapattributevalue(
              (
                VALUE /aws1/cl_dynattributevalue=>ts_mapattributevalue_maprow(
                  key = |string|
                  value = new /aws1/cl_dynattributevalue(
                    it_bs = VALUE /aws1/cl_dynbinarysetattrval_w=>tt_binarysetattributevalue(
                      ( new /aws1/cl_dynbinarysetattrval_w( '5347567362473873563239796247513D' ) )
                    )
                    it_l = VALUE /aws1/cl_dynattributevalue=>tt_listattributevalue(
                      (
                        new /aws1/cl_dynattributevalue(
                          it_bs = VALUE /aws1/cl_dynbinarysetattrval_w=>tt_binarysetattributevalue(
                            ( new /aws1/cl_dynbinarysetattrval_w( '5347567362473873563239796247513D' ) )
                          )
                          it_ns = VALUE /aws1/cl_dynnumsetattrvalue_w=>tt_numbersetattributevalue(
                            ( new /aws1/cl_dynnumsetattrvalue_w( |string| ) )
                          )
                          it_ss = VALUE /aws1/cl_dynstrsetattrvalue_w=>tt_stringsetattributevalue(
                            ( new /aws1/cl_dynstrsetattrvalue_w( |string| ) )
                          )
                          iv_b = '5347567362473873563239796247513D'
                          iv_bool = ABAP_TRUE
                          iv_n = |string|
                          iv_null = ABAP_TRUE
                          iv_s = |string|
                        )
                      )
                    )
                    it_ns = VALUE /aws1/cl_dynnumsetattrvalue_w=>tt_numbersetattributevalue(
                      ( new /aws1/cl_dynnumsetattrvalue_w( |string| ) )
                    )
                    it_ss = VALUE /aws1/cl_dynstrsetattrvalue_w=>tt_stringsetattributevalue(
                      ( new /aws1/cl_dynstrsetattrvalue_w( |string| ) )
                    )
                    iv_b = '5347567362473873563239796247513D'
                    iv_bool = ABAP_TRUE
                    iv_n = |string|
                    iv_null = ABAP_TRUE
                    iv_s = |string|
                  )
                )
              )
            )
            it_ns = VALUE /aws1/cl_dynnumsetattrvalue_w=>tt_numbersetattributevalue(
              ( new /aws1/cl_dynnumsetattrvalue_w( |string| ) )
            )
            it_ss = VALUE /aws1/cl_dynstrsetattrvalue_w=>tt_stringsetattributevalue(
              ( new /aws1/cl_dynstrsetattrvalue_w( |string| ) )
            )
            iv_b = '5347567362473873563239796247513D'
            iv_bool = ABAP_TRUE
            iv_n = |string|
            iv_null = ABAP_TRUE
            iv_s = |string|
          )
        )
      )
    )
    iv_filterexpression = |string|
    iv_keyconditionexpression = |string|
    iv_projectionexpression = |string|
  )
  io_incrementalexportspec = new /aws1/cl_dynincrementalexppec(
    iv_exportfromtime = '20150101000000.0000000'
    iv_exporttotime = '20150101000000.0000000'
    iv_exportviewtype = |string|
  )
  iv_clienttoken = |string|
  iv_exportformat = |string|
  iv_exporttime = '20150101000000.0000000'
  iv_exporttype = |string|
  iv_s3bucket = |string|
  iv_s3bucketowner = |string|
  iv_s3prefix = |string|
  iv_s3ssealgorithm = |string|
  iv_s3ssekmskeyid = |string|
  iv_tablearn = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lo_exportdescription = lo_result->get_exportdescription( ).
  IF lo_exportdescription IS NOT INITIAL.
    lv_exportarn = lo_exportdescription->get_exportarn( ).
    lv_exportstatus = lo_exportdescription->get_exportstatus( ).
    lv_exportstarttime = lo_exportdescription->get_starttime( ).
    lv_exportendtime = lo_exportdescription->get_endtime( ).
    lv_exportmanifest = lo_exportdescription->get_exportmanifest( ).
    lv_tablearn = lo_exportdescription->get_tablearn( ).
    lv_tableid = lo_exportdescription->get_tableid( ).
    lv_exporttime = lo_exportdescription->get_exporttime( ).
    lv_clienttoken = lo_exportdescription->get_clienttoken( ).
    lv_s3bucket = lo_exportdescription->get_s3bucket( ).
    lv_s3bucketowner = lo_exportdescription->get_s3bucketowner( ).
    lv_s3prefix = lo_exportdescription->get_s3prefix( ).
    lv_s3ssealgorithm = lo_exportdescription->get_s3ssealgorithm( ).
    lv_s3ssekmskeyid = lo_exportdescription->get_s3ssekmskeyid( ).
    lv_failurecode = lo_exportdescription->get_failurecode( ).
    lv_failuremessage = lo_exportdescription->get_failuremessage( ).
    lv_exportformat = lo_exportdescription->get_exportformat( ).
    lv_billedsizebytes = lo_exportdescription->get_billedsizebytes( ).
    lv_itemcount = lo_exportdescription->get_itemcount( ).
    lv_exporttype = lo_exportdescription->get_exporttype( ).
    lo_incrementalexportspecif = lo_exportdescription->get_incrementalexportspec( ).
    IF lo_incrementalexportspecif IS NOT INITIAL.
      lv_exportfromtime = lo_incrementalexportspecif->get_exportfromtime( ).
      lv_exporttotime = lo_incrementalexportspecif->get_exporttotime( ).
      lv_exportviewtype = lo_incrementalexportspecif->get_exportviewtype( ).
    ENDIF.
    lo_filterspecification = lo_exportdescription->get_filterspecification( ).
    IF lo_filterspecification IS NOT INITIAL.
      lv_conditionexpression = lo_filterspecification->get_filterexpression( ).
      lv_projectionexpression = lo_filterspecification->get_projectionexpression( ).
      lv_keyexpression = lo_filterspecification->get_keyconditionexpression( ).
      LOOP AT lo_filterspecification->get_expressionattributenames( ) into ls_row.
        lv_key = ls_row-key.
        lo_value = ls_row-value.
        IF lo_value IS NOT INITIAL.
          lv_attributename = lo_value->get_value( ).
        ENDIF.
      ENDLOOP.
      LOOP AT lo_filterspecification->get_xprsnattributevalues( ) into ls_row_1.
        lv_key_1 = ls_row_1-key.
        lo_value_1 = ls_row_1-value.
        IF lo_value_1 IS NOT INITIAL.
          lv_stringattributevalue = lo_value_1->get_s( ).
          lv_numberattributevalue = lo_value_1->get_n( ).
          lv_binaryattributevalue = lo_value_1->get_b( ).
          LOOP AT lo_value_1->get_ss( ) into lo_row_2.
            lo_row_3 = lo_row_2.
            IF lo_row_3 IS NOT INITIAL.
              lv_stringattributevalue = lo_row_3->get_value( ).
            ENDIF.
          ENDLOOP.
          LOOP AT lo_value_1->get_ns( ) into lo_row_4.
            lo_row_5 = lo_row_4.
            IF lo_row_5 IS NOT INITIAL.
              lv_numberattributevalue = lo_row_5->get_value( ).
            ENDIF.
          ENDLOOP.
          LOOP AT lo_value_1->get_bs( ) into lo_row_6.
            lo_row_7 = lo_row_6.
            IF lo_row_7 IS NOT INITIAL.
              lv_binaryattributevalue = lo_row_7->get_value( ).
            ENDIF.
          ENDLOOP.
          LOOP AT lo_value_1->get_m( ) into ls_row_8.
            lv_key_2 = ls_row_8-key.
            lo_value_2 = ls_row_8-value.
            IF lo_value_2 IS NOT INITIAL.
              lv_stringattributevalue = lo_value_2->get_s( ).
              lv_numberattributevalue = lo_value_2->get_n( ).
              lv_binaryattributevalue = lo_value_2->get_b( ).
              LOOP AT lo_value_2->get_ss( ) into lo_row_2.
                lo_row_3 = lo_row_2.
                IF lo_row_3 IS NOT INITIAL.
                  lv_stringattributevalue = lo_row_3->get_value( ).
                ENDIF.
              ENDLOOP.
              LOOP AT lo_value_2->get_ns( ) into lo_row_4.
                lo_row_5 = lo_row_4.
                IF lo_row_5 IS NOT INITIAL.
                  lv_numberattributevalue = lo_row_5->get_value( ).
                ENDIF.
              ENDLOOP.
              LOOP AT lo_value_2->get_bs( ) into lo_row_6.
                lo_row_7 = lo_row_6.
                IF lo_row_7 IS NOT INITIAL.
                  lv_binaryattributevalue = lo_row_7->get_value( ).
                ENDIF.
              ENDLOOP.
              " Skipping ls_row_8-value to avoid recursion
              LOOP AT lo_value_2->get_l( ) into lo_row_9.
                lo_row_10 = lo_row_9.
                IF lo_row_10 IS NOT INITIAL.
                  lv_stringattributevalue = lo_row_10->get_s( ).
                  lv_numberattributevalue = lo_row_10->get_n( ).
                  lv_binaryattributevalue = lo_row_10->get_b( ).
                  LOOP AT lo_row_10->get_ss( ) into lo_row_2.
                    lo_row_3 = lo_row_2.
                    IF lo_row_3 IS NOT INITIAL.
                      lv_stringattributevalue = lo_row_3->get_value( ).
                    ENDIF.
                  ENDLOOP.
                  LOOP AT lo_row_10->get_ns( ) into lo_row_4.
                    lo_row_5 = lo_row_4.
                    IF lo_row_5 IS NOT INITIAL.
                      lv_numberattributevalue = lo_row_5->get_value( ).
                    ENDIF.
                  ENDLOOP.
                  LOOP AT lo_row_10->get_bs( ) into lo_row_6.
                    lo_row_7 = lo_row_6.
                    IF lo_row_7 IS NOT INITIAL.
                      lv_binaryattributevalue = lo_row_7->get_value( ).
                    ENDIF.
                  ENDLOOP.
                  " Skipping lo_row_9 to avoid recursion
                  " Skipping lo_row_9 to avoid recursion
                  lv_nullattributevalue = lo_row_10->get_null( ).
                  lv_booleanattributevalue = lo_row_10->get_bool( ).
                ENDIF.
              ENDLOOP.
              lv_nullattributevalue = lo_value_2->get_null( ).
              lv_booleanattributevalue = lo_value_2->get_bool( ).
            ENDIF.
          ENDLOOP.
          LOOP AT lo_value_1->get_l( ) into lo_row_9.
            lo_row_10 = lo_row_9.
            IF lo_row_10 IS NOT INITIAL.
              lv_stringattributevalue = lo_row_10->get_s( ).
              lv_numberattributevalue = lo_row_10->get_n( ).
              lv_binaryattributevalue = lo_row_10->get_b( ).
              LOOP AT lo_row_10->get_ss( ) into lo_row_2.
                lo_row_3 = lo_row_2.
                IF lo_row_3 IS NOT INITIAL.
                  lv_stringattributevalue = lo_row_3->get_value( ).
                ENDIF.
              ENDLOOP.
              LOOP AT lo_row_10->get_ns( ) into lo_row_4.
                lo_row_5 = lo_row_4.
                IF lo_row_5 IS NOT INITIAL.
                  lv_numberattributevalue = lo_row_5->get_value( ).
                ENDIF.
              ENDLOOP.
              LOOP AT lo_row_10->get_bs( ) into lo_row_6.
                lo_row_7 = lo_row_6.
                IF lo_row_7 IS NOT INITIAL.
                  lv_binaryattributevalue = lo_row_7->get_value( ).
                ENDIF.
              ENDLOOP.
              LOOP AT lo_row_10->get_m( ) into ls_row_8.
                lv_key_2 = ls_row_8-key.
                lo_value_2 = ls_row_8-value.
                IF lo_value_2 IS NOT INITIAL.
                  lv_stringattributevalue = lo_value_2->get_s( ).
                  lv_numberattributevalue = lo_value_2->get_n( ).
                  lv_binaryattributevalue = lo_value_2->get_b( ).
                  LOOP AT lo_value_2->get_ss( ) into lo_row_2.
                    lo_row_3 = lo_row_2.
                    IF lo_row_3 IS NOT INITIAL.
                      lv_stringattributevalue = lo_row_3->get_value( ).
                    ENDIF.
                  ENDLOOP.
                  LOOP AT lo_value_2->get_ns( ) into lo_row_4.
                    lo_row_5 = lo_row_4.
                    IF lo_row_5 IS NOT INITIAL.
                      lv_numberattributevalue = lo_row_5->get_value( ).
                    ENDIF.
                  ENDLOOP.
                  LOOP AT lo_value_2->get_bs( ) into lo_row_6.
                    lo_row_7 = lo_row_6.
                    IF lo_row_7 IS NOT INITIAL.
                      lv_binaryattributevalue = lo_row_7->get_value( ).
                    ENDIF.
                  ENDLOOP.
                  " Skipping ls_row_8-value to avoid recursion
                  " Skipping ls_row_8-value to avoid recursion
                  lv_nullattributevalue = lo_value_2->get_null( ).
                  lv_booleanattributevalue = lo_value_2->get_bool( ).
                ENDIF.
              ENDLOOP.
              " Skipping lo_row_9 to avoid recursion
              lv_nullattributevalue = lo_row_10->get_null( ).
              lv_booleanattributevalue = lo_row_10->get_bool( ).
            ENDIF.
          ENDLOOP.
          lv_nullattributevalue = lo_value_1->get_null( ).
          lv_booleanattributevalue = lo_value_1->get_bool( ).
        ENDIF.
      ENDLOOP.
    ENDIF.
  ENDIF.
ENDIF.