Trouble parsing and writing company names to a table from JSON data in Clay. Need assistance.

I took a comma-separated list of company names and turned it into structure JSON. Now I'd like to parse the list of company names from the JSON data and write each one to a new row in a new table, but I'm having an error with write to table. Any help? Here's the table https://app.clay.com/workspaces/120716/tables/t_p5meh3H2URyn/views/gv_DZyX0DQyo8xX

✅1

9 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hey Jacob!! taking a look
Clay Team
APP
·
·
Ah, I see. It looks like it didn't output this in an actual list format. I'll re-prompt it so it does that and should work with Write to table after that
Clay S.
·
·
i've written the craziest thing to write an array to a table
Clay S.
·
·
lmk if you want me to dig up for you
Clay S.
·
·
it's not officially supported i think
Clay Team
APP
·
·
Here's what it looks like, is that what you needed, Jacob T.? There are different ways to get around that with JS like Clay mentioned, in this case it's just asking chatGPT to output JSON as a list of keys.
853e8378-8c2f-4c11-a797-2671a58ab2fb.png(81 kB)
Clay Team
APP
·
·
Just need to re-map Write to table to make sure it reads the list accordingly
Jacob T.
·
·
awesome thank you!