Honeycode / Client / start_table_data_import_job

start_table_data_import_job

Honeycode.Client.start_table_data_import_job(**kwargs)

The StartTableDataImportJob API allows you to start an import job on a table. This API will only return the id of the job that was started. To find out the status of the import request, you need to call the DescribeTableDataImportJob API.

See also: AWS API Documentation

Request Syntax

response = client.start_table_data_import_job(
    workbookId='string',
    dataSource={
        'dataSourceConfig': {
            'dataSourceUrl': 'string'
        }
    },
    dataFormat='DELIMITED_TEXT',
    destinationTableId='string',
    importOptions={
        'destinationOptions': {
            'columnMap': {
                'string': {
                    'columnIndex': 123
                }
            }
        },
        'delimitedTextOptions': {
            'delimiter': 'string',
            'hasHeaderRow': True|False,
            'ignoreEmptyRows': True|False,
            'dataCharacterEncoding': 'UTF-8'|'US-ASCII'|'ISO-8859-1'|'UTF-16BE'|'UTF-16LE'|'UTF-16'
        }
    },
    clientRequestToken='string'
)

Parameters:

• workbookId (string) –

  [REQUIRED]

  The ID of the workbook where the rows are being imported.

  If a workbook with the specified id could not be found, this API throws ResourceNotFoundException.

• dataSource (dict) –

  [REQUIRED]

  The source of the data that is being imported. The size of source must be no larger than 100 MB. Source must have no more than 100,000 cells and no more than 1,000 rows.

  • dataSourceConfig (dict) – [REQUIRED]

    The configuration parameters for the data source of the import

    • dataSourceUrl (string) –

      The URL from which source data will be downloaded for the import request.

• dataFormat (string) –

  [REQUIRED]

  The format of the data that is being imported. Currently the only option supported is “DELIMITED_TEXT”.

• destinationTableId (string) –

  [REQUIRED]

  The ID of the table where the rows are being imported.

  If a table with the specified id could not be found, this API throws ResourceNotFoundException.

• importOptions (dict) –

  [REQUIRED]

  The options for customizing this import request.

  • destinationOptions (dict) –

    Options relating to the destination of the import request.

    • columnMap (dict) –

      A map of the column id to the import properties for each column.

      • (string) –

        • (dict) –

          An object that contains the properties for importing data to a specific column in a table.

          • columnIndex (integer) –

            The index of the column in the input file.

  • delimitedTextOptions (dict) –

    Options relating to parsing delimited text. Required if dataFormat is DELIMITED_TEXT.

    • delimiter (string) – [REQUIRED]

      The delimiter to use for separating columns in a single row of the input.

    • hasHeaderRow (boolean) –

      Indicates whether the input file has a header row at the top containing the column names.

    • ignoreEmptyRows (boolean) –

      A parameter to indicate whether empty rows should be ignored or be included in the import.

    • dataCharacterEncoding (string) –

      The encoding of the data in the input file.

• clientRequestToken (string) –

  [REQUIRED]

  The request token for performing the update action. Request tokens help to identify duplicate requests. If a call times out or fails due to a transient error like a failed network connection, you can retry the call with the same request token. The service ensures that if the first call using that request token is successfully performed, the second call will not perform the action again.

  Note that request tokens are valid only for a few minutes. You cannot use request tokens to dedupe requests spanning hours or days.

Return type:

dict

Returns:

Response Syntax

{
    'jobId': 'string',
    'jobStatus': 'SUBMITTED'|'IN_PROGRESS'|'COMPLETED'|'FAILED'
}

Response Structure

• (dict) –

  • jobId (string) –

    The id that is assigned to this import job. Future requests to find out the status of this import job need to send this id in the appropriate parameter in the request.

  • jobStatus (string) –

    The status of the import job immediately after submitting the request.

Exceptions

• Honeycode.Client.exceptions.AccessDeniedException

• Honeycode.Client.exceptions.InternalServerException

• Honeycode.Client.exceptions.ResourceNotFoundException

• Honeycode.Client.exceptions.ServiceUnavailableException

• Honeycode.Client.exceptions.ThrottlingException

• Honeycode.Client.exceptions.ValidationException

• Honeycode.Client.exceptions.RequestTimeoutException

• Honeycode.Client.exceptions.ServiceQuotaExceededException