Clay Icon
Join the Community
02 Support

I'm using the Write to Table function and have JSON in 14 different co...

I'm using the Write to Table function and have JSON in 14 different columns. Any way to combine JSON for the 14 other columns in a single Write to Table column? Or, do I need 14 Write to Table columns?

11 comments

  • Avatar of Clay Team
    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 😉

  • Avatar of Kevin P.
    Kevin P.
    ·

    This shows a single column of JSON. What's the formula to have it take JSON from other columns as well?

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    Hey Kevin, thanks for reaching out! Taking a look

  • Avatar of Kevin P.
    Kevin P.
    ·

    you're awesome Arturo

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    Hmm, so you're looking to kind of "transpose" each topic into individual rows?

  • Avatar of Kevin P.
    Kevin P.
    ·

    ya, the topic that already has it's own JSON column

  • Avatar of Kevin P.
    Kevin P.
    ·

    it's fine, i can make 14 individual "send to table" columns if i need to

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    I know it's not ideal but not sure if it will read them as a list. Maybe using a formula to combine them in a single cell and then Write them over but not sure our integration can detect JSON as a list though

  • Avatar of Kevin P.
    Kevin P.
    ·

    yea, and the cell limits get reached quickly

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    Yup, also tested this out with the recent JSON format option for chatGPT but it's still quite a bit of data. That alternative of having several columns unfortunately seems like the best way for now, you can always duplicate the column to keep the settings and just change the one field