Delete rows in table

Delete rows by

• Row IDs
• Filtering the value in cell

Request

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

Response body

{
    "deleteBy": "columnValues",
    "rowIDs": [
        "625faf21edd66af68ccc44a4",
        "625fae99edd66af68ccc440e"
    ],
    "columnValues": {
        "id": "625fae99edd66af68ccc43f4",
        "values": [
            "fee9d5e02ae33eafb429e2b89a3d68c6",
            "38c7c85c287b6637258768bad7796863"
        ]
    }
}

Parameter description

Name	Type	Description	Required
deleteBy	string	rowIDs or columnValues	Y
rowIDs	array	Row IDs to delete
columnValues	object	Row filtering ploicy
∟ id	string	Column ID
∟ values	array	Column values to match

Python example

def table_delete_row(access_token, table_id, row_ids, column_values):
    headers = {'Authorization': access_token}
    data = {
        'deleteBy': 'rowIDs', # or 'columnValues',
        'rowIDs': row_ids,
        'columnValues': column_values
    }

    url = '%s/open/api/v1/tablenodes/%d/rows/' % (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']

# update the last 20 rows
col_id = [i['id'] for i in resp['detail']['columns'] if i['name'] == 'ID'][0]
delete_row_ids = []
delete_row_values = []
for row in resp['detail']['rows'][-20:-10]:
    delete_row_ids.append(row['id'])
for row in resp['detail']['rows'][-10:]:
    delete_row_values.append(row['cells'][col_id])

column_values = {
    'id': col_id,
    'values': delete_row_values
}
resp = ma.table_delete_row(access_token, table['id'],
                           delete_row_ids, column_values)

Response

Response body example

{
    "code": 0,
    "detail": {
        "id": 484,
        "projectID": 55,
        "deletedRowIDs": [
            "625e57fe9b6c276dbdbf8c29",
            "625e57fe9b6c276dbdbf8c2a"
        ]
    },
    "extra":null,
    "message": "OK",
    "requestID":null
}