I've got to assume that there is already a support thread on this, but my quick search didn't turn up an answer or even my exact use case. I am using a claygent to do some research and return an array of results with 3 fields per object in the array. Historically I used "write to table" to parse those out into unique rows in a new table for further enrichment and manipulation. The proposed "send table data" does not seem to recognize and portion of my claygent output as a list and will not fulfill the need that was previously available. Any advice or alternative suggestions?
Clay Support is sharing a file with you.
For your Claygent array output, try using the cell actions instead of Send Table Data. Click into the cell with your Claygent results, then in the Cell details panel, hover to the right of the list to see "Turn items into rows" - this should move each array item into its own row in another table. [1]
Before we dig deeper, have you tried using Sculptor? It's our built-in AI tool in the top-right corner that can help set up these workflows quickly. Give it a try and let me know if that helps solve your list parsing issue.
Clay Support is sharing a file with you.
For your Claygent array output, try using the cell actions instead of Send Table Data. Click into the cell with your Claygent results, then in the Cell details panel, hover to the right of the list to see "Turn items into rows" - this should move each array item into its own row in another table. [1]
Before we dig deeper, have you tried using Sculptor? It's our built-in AI tool in the top-right corner that can help set up these workflows quickly. Give it a try and let me know if that helps solve your list parsing issue.
Clay Support is sharing a file with you.
Looking at your screenshot, I see the issue - the input field under "Send row for each item in a list" is empty. You need to select which column contains your Claygent array results in that field. [1]
Click on that empty input field and select the column that has your Claygent output with the 3-field objects. Once you select the correct column containing your array, Send Table Data should recognize it as a list and let you flatten it into individual rows. [2]
The cell actions approach I mentioned earlier ("Turn items into rows") is another solid option if Send Table Data continues giving you trouble. [3]
Is that what you were looking for?
If you still need help with parsing your Claygent array output or using Send Table Data, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so we can continue troubleshooting?
there is no cell action "Turn items into rows" available anymore
You're right - the "Turn items into rows" cell action has been replaced. The new way to handle this is through Send Table Data with the "Send row for each item in a list" option.
If you're still having trouble getting it to recognize your Claygent output as a list, try Sculptor first - it can help set up these workflows quickly and might solve the parsing issue.
Did that answer your question?
no i did try sculptor and it was hallucinating fields in the send to data setup and send to data also gives an error saying input a valid list when i try to use the array
The "input a valid list" error usually means your Claygent output isn't formatted as a proper list. Try adding the array through the "Other data from this table" section instead of directly selecting the column.
You can also use Extract Data From Values to process your array data - add the column using the forward slash (/) command and apply this regex: [^,"]+"?[^,"]+ to split the values into a proper list format. [1]
Once it's formatted correctly as a list, Send Table Data should recognize it for the "Send row for each item in a list" option.
I’m sorry the issue with the array parsing is still causing trouble. Would you like to share more details about your Claygent output or the steps you’ve taken so far so I can assist further?
i think i was able to debug the prompt that was misformating the array
Great to hear you were able to debug the prompt causing the array misformatting. If you need any more help or have other questions, just let me know.
