Issue with Write to Column: HTTP 200 Error and Data Problems

·

hey support, i am having a tough time with my write to column, http says 200 but getting an error and the data in the http is all messed up, here is a link to the table, can you let me know what happened: https://app.clay.com/workspaces/263283/workbooks/wb_0sz6y6lDt66A6aUq88b/tables/t_0sz6y6lz5xZb9fMcnm3/views/gv_QzhsiWj3iRi4

Clay
APP
·
·
A 200 HTTP response doesn't guarantee your write to table operation worked correctly. The error and messed up data likely stem from JSON formatting issues in your HTTP request body. Try these fixes: 1. Delete and recreate the column - Remove the affected column, create a fresh one, and re-map your data. 2. Use Force Run in table settings to reprocess the operation. 3. Check JSON formatting - Ensure text is in quotes, remove extra commas, and verify proper syntax. Since you mentioned JSON issues, please copy and paste your JSON body into this chat so I can help troubleshoot the specific formatting problems.
Sources: Write to Other Table | Documentation | Clay University FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment? HTTP API integration overview | Documentation | Clay University
Griffin D.
·
·
https://app.clay.com/workspaces/263283/workbooks/wb_0sz6y6lDt66A6aUq88b/tables/t_0sz6y6lz5xZb9fMcnm3/views/gv_QzhsiWj3iRi4
Bo (.
·
·
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/hz281Tcl Let me know if you have any follow-up questions!