Delete columns in table

Delete columns

Request

curl -vvv -X DELETE "$API_HOST/open/api/v1/tablenodes/$table_id/columns/" -H "Content-Type: application/json" -d '$request_body'

Request body

{
    "columnIDs":[
        "625e1a9d853e450e5ecf408c",
        "625e1a9d853e450e5ecf408d"
    ]
}

Parameter description

Name	Type	Description	Required
columnIDs	array	The list of column IDs that need to be delelted	YES

Python example

def table_delete_column(access_token, table_id, column_ids):
    headers = {'Authorization': access_token}
    data = {
        'columnIDs': column_ids
    }

    url = '%s/open/api/v1/tablenodes/%d/columns/' % (API_HOST, table_id)
    response = requests.delete(url, headers=headers, json=data)
    return response.json()

# create table using csv
data = {
    'projectID': project['id'],
    'name': 'test-csv-upload',
    'skipFirstRow': True
}
resp = ma.create_table(access_token, data,
                       'data/create_table_columns.json',
                       'data/gd.csv')
table = resp['detail']
resp = ma.read_table(access_token, table['id'], '', '')
columns = resp['detail']['columns']

name_id = [i['id'] for i in resp['detail']['columns'] if i['name'] == 'Name'][0]
resp = ma.table_delete_column(access_token, table['id'], [name_id])

Response

Response body example

{
    "code": 0,
    "detail": {
        "tableNodeID": 484,
        "columnIDs": [
            "625e1a9d853e450e5ecf408c",
            "625e1a9d853e450e5ecf408d"
        ],
        "invalidedColumns": []
    },
    "extra":null,
    "message": "OK",
    "requestID":null
}