Shayan H.

Interesting question… I have a table where each row represents a lead. There’s an HTTP API column that pushes that lead to our email outbound platform. Problem is when we have 10,000 leads, we hit concurrent request rate limits on the email outbound’s API. Even after setting auto-retries and rate limiting on the HTTP API Column settings, many rows fail because of the email outbound’s API. Ideally we collapse the 10,000 leads into a few hundred requests, where each requests holds a few hundred leads. Is there a way to collapse many rows into one and still keep all the variables specific to each lead intact? Maybe it looks something like creating the JSON object as a plain text column for each row, then pasting each row of that column together somehow? Thanks!

How do you do a Group by on rows in a table by an email? I.e. merge all rows that have the same email

Hey! I have a Clay table that’s receiving a JSON payload from a webhook every time a lead advances through a form. That is, we get partial submission data for every step. The problem is, there are 5 steps to the form, and so if they go throuhg the whole thing, we get 5 JSONs in a few minutes each with repeat data. How do I automatically merge these rows? The desired action is to 1) enrich their company information 2) send them an email if they abandon the form by pushing them out of Clay with an HTTP API enrichment to an emailing service