list_table_columns

Honeycode.Client.list_table_columns(**kwargs)

The ListTableColumns API allows you to retrieve a list of all the columns in a table in a workbook.

See also: AWS API Documentation

Request Syntax

response = client.list_table_columns(
    workbookId='string',
    tableId='string',
    nextToken='string'
)

Parameters

• workbookId (string) --

  [REQUIRED]

  The ID of the workbook that contains the table whose columns are being retrieved.

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

• tableId (string) --

  [REQUIRED]

  The ID of the table whose columns are being retrieved.

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

• nextToken (string) --

  This parameter is optional. If a nextToken is not specified, the API returns the first page of data.

  Pagination tokens expire after 1 hour. If you use a token that was returned more than an hour back, the API will throw ValidationException.

Return type

dict

Returns

Response Syntax

{
    'tableColumns': [
        {
            'tableColumnId': 'string',
            'tableColumnName': 'string',
            'format': 'AUTO'|'NUMBER'|'CURRENCY'|'DATE'|'TIME'|'DATE_TIME'|'PERCENTAGE'|'TEXT'|'ACCOUNTING'|'CONTACT'|'ROWLINK'|'ROWSET'
        },
    ],
    'nextToken': 'string',
    'workbookCursor': 123
}

Response Structure

• (dict) --

  • tableColumns (list) --

    The list of columns in the table.

    • (dict) --

      An object that contains attributes about a single column in a table

      • tableColumnId (string) --

        The id of the column in the table.

      • tableColumnName (string) --

        The name of the column in the table.

      • format (string) --

        The column level format that is applied in the table. An empty value in this field means that the column format is the default value 'AUTO'.

  • nextToken (string) --

    Provides the pagination token to load the next page if there are more results matching the request. If a pagination token is not present in the response, it means that all data matching the request has been loaded.

  • workbookCursor (integer) --

    Indicates the cursor of the workbook at which the data returned by this request is read. Workbook cursor keeps increasing with every update and the increments are not sequential.

Exceptions

• Honeycode.Client.exceptions.AccessDeniedException
• Honeycode.Client.exceptions.InternalServerException
• Honeycode.Client.exceptions.RequestTimeoutException
• Honeycode.Client.exceptions.ResourceNotFoundException
• Honeycode.Client.exceptions.ServiceUnavailableException
• Honeycode.Client.exceptions.ThrottlingException
• Honeycode.Client.exceptions.ValidationException