Recovering Lost Data from a Table after an HTTP API Request Error

I need to undo something I did did in a table, which wiped out an entire column of data for an HTTP API request. I’m getting the error below. How do I resolve this so that I can get back the data I had before? It also removed data for a column next to it that only runs if this column has a certain result. Will that data come back as well?

7 comments

Channeled
APP
·
·
Unfortunately, we don't have the ability to undo changes or recover data that has been removed from columns in our tables. Once the data disappears, it's gone from our system. To recover the data, you'll need to: 1. Re-create the necessary columns 2. Re-run the enrichments to fetch the data again For future reference, before making significant changes, we recommend turning off the auto-update feature. Make your changes, then turn it back on when you're done. This can help prevent unexpected data loss when modifying dependencies. If you need help recovering credits for this situation, please provide more details so we can look into it with you. If you need further assistance, please request to talk to a human in this chat.
Source: How to Undo Deletions and Restore Previous Table Versions in Databases | Clay
Dave S.
·
·
The auto-update feature was off! Why did it remove the data for the secondary column?
Channeled
APP
·
·
I apologize for the confusion. If auto-update was indeed turned off, the data in the secondary column shouldn't have been removed automatically. There are a few possibilities to consider: 1. The auto-update might have been off for the table but on for specific columns. Each column can have its own auto-update setting. 2. There might have been a manual action or formula change that affected the secondary column. To investigate further: 1. Check the table-level auto-update setting. 2. Review individual column settings, especially for the affected columns. 3. Look for any recent changes in formulas or dependencies between columns. If you need help identifying the cause or recovering the data, please request to talk to a person in this chat for more detailed assistance.
Sources: Table management settings | Documentation | Clay University Auto-update and Auto-dedupe Table
Dave S.
·
·
https://app.clay.com/workspaces/476916/workbooks/wb_FVwvdDHfoEr8/tables/t_CunATNqAEEFM/views/gv_xDcsppHPkjgT
Dave S.
·
·
I need to understand how to fix this invalid input in the hopes that when I do it will return the data that I had in this column before. I initiated a run for the column for it to only run rows that hadn’t run or had errors, and instead it wiped all data for all rows (not just those with errors) and replaced it with “invalid input”… If I have to re-run this column in it’s entirely it will cost me $300+, so that’s a big issue
Bo (.
·
·
Hey, Totally understand the concern. Clay doesn’t have version control, so we can’t fully undo changes — but if you walk me through exactly what happened (what updates you made, if anything was removed from the API, etc.), we can check if this was caused by a bug. If so, we’re happy to look into it further and can add some credits back if needed. Let’s figure this out together.
Channeled
APP
·
·