Can't delete a table column
# 🤝help
w
Hi, guys, I have a table which I have been using for a few months, and a new column was added with a wrong name, but now I can't delete it. I try to delete through the interface, but nothing happens. Has anyone experienced this and know how to solve?
f
Just to understand it a bit better. When you right click on it, hit delete, it stays?
w
yes!
f
Can you try closing down your bot completely and then open it up again
w
how do I do this? I tried closing and reopening the tab, but it did not work
f
That was what I meant 🙂
Do you get any errors while deleting?
w
i tried refreshing, but still nothing happens, and no errors are shown
f
Hmm
It can be 2 things
Either it doesn't delete or the UI is not updating
That should show us if its been deleted or not
I think I have a curl of it laying around
Okay
You can actually just use this endpoint instead 🙂 https://botpress.com/docs/api-documentation/#list-tables
Heres the cUrl
Copy code
curl --request GET \
  --url https://api.botpress.cloud/v1/tables \
  --header 'Authorization: Bearer YOUR PAT' \
  --header 'x-bot-id: YOUR BOT ID'
In case you want to use the "get-table" endpoint
Copy code
curl --request GET \
  --url https://api.botpress.cloud/v1/tables/YourTableIDHere \
  --header 'Authorization: Bearer YOUR PAT' \
  --header 'x-bot-id: YOUR BOT ID'
w
I used the list-tables endpoints, and I can still see the column there
Copy code
"dt_next_retry_message": {
                        "type": "string",
                        "x-zui": {
                            "index": 7,
                            "searchable": true
                        },
                        "nullable": true,
                        "description": "Data/hora da próxima mensagem de retentativa"
                    }
f
Hmm
I am honestly not sure of what to do.
Maybe if you exported the table. Opened it in Excel, deleted the column, and then imported it back in
Just an idea
Probably just best to create a report and share it here