Delete a custom column from a custom table

[giovanna]

I did a custom table with two "original" columns - Date and weekday_number - and previously i added a bigint custom column, but now i want to delete this bigint column and i cant find where to do this

[DRay]

Hi @giovanna,

Thank you for reaching out.

To delete a custom column from a custom table using the Datamodel API in Sisense, you need to use the Tables endpoint's PATCH operation. Since properties provided in the PATCH request's payload are replaced and not merged, you must include all the columns you want the table to have after the operation. This means you should first perform a GET request to retrieve the current table structure, make the necessary changes by omitting the column you wish to delete, and then send this updated structure as the payload in your PATCH request. Special attention should be given to the existing Column's oid property, as this is how Sisense distinguishes between existing and new columns. If the oid property is missing for a column, a new column will be created instead of recognizing it as an existing one to update or delete.

I hope that helps. Please keep us updated.

Have a great day!

[DRay]

Hello @giovanna,

I’m following up to see if the solution I offered worked for you.

If so, please click the 'Accept as Solution' button on the post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.