.png){kind=logo}
Error Encountered When Writing to Table in Clay App
HEy I am getting this error with write to table, but no explanation https://app.clay.com/workspaces/16336/workbooks/wb_M6QCrsaUriQb/tables/t_z2QX2NWbxizv/views/gv_SBeKugXHEHm2
HEy I am getting this error with write to table, but no explanation https://app.clay.com/workspaces/16336/workbooks/wb_M6QCrsaUriQb/tables/t_z2QX2NWbxizv/views/gv_SBeKugXHEHm2
There could be a few reasons for the "write to table" error you're experiencing. The most common cause is an issue with your API key. To resolve this: 1. Check if your Clay API key is correct and properly connected. 2. Go to Settings > Connections and search for Clay. 3. Verify or update your API key. 4. Save changes and retry the action. If the error persists, it might be due to invalid data or configuration issues. Double-check that all columns and tables exist and are correctly set up. If you need more help, please request human assistance by clicking on "Talk to a person".
Hi Harvey, I just pinged our engineers to find out what was wrong here. Will get back to you. Thank you for flagging this.
Can you update me when possible? this have not been resolved on my end yet
Write to table is driving me insane haha... probably the faultiest clay enrichment i use. They are writing in rows I didn't even let them write in with conditional runs, and the row was based on a find people list that did not find any but still write through... https://app.clay.com/workspaces/16336/workbooks/wb_5G9Xhebcv5ze/tables/t_P7btrmBAWzhE/views/gv_hYdfa7ygQFbx
another weird one -- i have auto update off, but it's still running
Hey Harvey,
I see that those columns show "Run Conditions not met" - they appear to have processed earlier than the other rows. Is it possible they ended up running first?
For the second issue with auto-update off but still running, could you provide more details? I don't see the auto-update toggle in your screenshot, but it looks like the rows were somehow triggered. Could it be manually?
I've checked your workbook here in this view: https://app.clay.com/workspaces/16336/workbooks/wb_5G9Xhebcv5ze/tables/t_k5jjHxaH3B8e/views/gv_N5YpZQ57UAF5
not possible since I had it as a template - and i did SAVE NOT RUN.
it is attached to a find contacts list. the write to table runs after it is run. but again auto update is off, so i don't get how this happen
Could we: 1. Delete those rows 2. Update the write to table with a tag on the rows using the formula I'd add the run conditions saying if it's meeting all the conditions (from the run conditions), return true, otherwise return false, and pass that tag in the write to other table. That way we'd be able to pint point if that was passed or not. As of now, I just tried to run those rows and the update didn't pass over. Regarding the auto-update, which columns/rows would it be in? I don't see this.
Hmm i think i'm already doing all that and giving run condition to them
Take a look at this -- this didn't happened before but now it's creating the row even tho the list before it did not return anything. i didn't see this 1 month ago. places/lists that did not have any result were not allowing write to table to run because you have nothing
still giving error no explanation
harvey - Do you mind sending the link (url) to the table so we can take a look and which columns/rows exactly you're seeing this?
Same error. now it's not writing cells that HAS RESULT but writing the ons without.
Bo (. now it is writing more than the limit of rows I set: I did a look up multiple, limit 6 - write to table that 6. but some companies have more than 6 being wrote to on a different table https://app.clay.com/workspaces/16336/workbooks/wb_tCDwzKcFDKu9/tables/t_zCz6BhB7uwaj/views/gv_YQC5UPNC3jnQ See video for more context on all errors on this table:
is this table too complex that it's making write to table halucinating?
on the same/simillar table--now my look up table is showing this errorhttps://app.clay.com/workspaces/16336/workbooks/wb_vg3pGR3F3bqC/tables/t_iXsMpNWnhFn2/views/gv_e6orK2TzHXuf
can't select a table now...
still need help with this team! https://clayrunhq.slack.com/archives/C025KSBLPGX/p1742721471563389?thread_ts=1741966146.092719&cid=C025KSBLPGX The can't access to table and look up is fixed!
Hey - So we are currently working on bettering this Write to Other Table. For now, the issue is happening because of the structure of where the email is located. If you look into the website email extraction, we see it's inside of the email addresses with ssdn. It has an underscore, but inside of the enrichment, there is no underscore.
If you check the website email enrichment, it seems like it got changed. We triggered the row again to run according to the news. I did so in row one with Jacob Ireland. You can see it's actually working.
Regarding the second table where you see the issues of multiple people/results - it's because there's actually more than one repetition of that company in that previous day.
For the lookup error, this has happened because you're trying to access a table outside of the workspace you've been using. Can you make sure you're using the correct API? This would also be why you don't see any table.
got it. makes total sense now. Thanks for this!