Issue with 'Write to Other Table' Feature Returning Invalid List Error

Hi, I don't understand why the feature 'Write to other table' is returning that isn't a valid list ? Table : https://app.clay.com/workspaces/11155/workbooks/wb_cdCqNYoB7Pma/tables/t_sPmxZeb9qyB7/views/gv_GAbrqM2VFz3o

6 comments

Mustafa A.
·
·
Check this: - Had the same questions, got it fiexd here Hey Mustafa! Thanks for reaching out. Happy to help✨. The reason why it's returning an error is because it's not in list format. List here refers to the data being structured as an array of objects. The workaround for this using "ChatGPT:Generate Text" to convert the field into a JSON array which can then be mapped into the write to table column to be added as new rows in a separate table. Here's a quick guide for using JSON mode in Chat GPT: https://www.loom.com/share/317de47023fb429a80022de0f4a5d6dc Also sharing an additional resource for using write to other table: https://www.loom.com/share/d46fd74ae9004d229142a2474ac61866?sid=440fafc1-5d4c-4ed4-bebe-449748573397 Let me know if this helps! (edited)
Mahdi G.
·
·
It seems a list for me, Idk why it returns that error, I want to get support approval before finding a workaround
Mahdi G.
·
·
I see the fix with GPT, thanks The only thing I don't get it when it works and when it doesn't for the column "Investor" or "Acquisition List" It look the same format for me, could you enlighten me on this ?
Mahdi G.
·
·
Thank Daniela! So from what you're saying should 'Acquired by Summary' of the row 4 work properly and send rows to other tables ?
Peter S.
·
·
This feature is not working as it used to and that list error is really annoying. I have a list that it pulled from a sale nav search. I was adding those to a table but it accidentally added one pull to a brand new table. So i am just trying to move the list that i already used credits on over to my working table. but it keeps giving me the error its not a list. but this is what Clay gives us. So now we have to use ChatGpt to reformat it? seems like the feature needs updating?
Peter S.
·
·
Yeah, apologies for getting frustrated. I will figure it out using your workaround.