跳到主要内容

删除数据表中的列

使用该接口可以批量删除数据表中的列

请求​

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

请求体​

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

参数说明​

名称类型描述必需
columnIDsarray需要删除的列ID列表是

Python 示例​

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])

响应​

响应体示例​

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