I’m trying to build a workflow where: • I run an HTTP API enrichment (Exa search) • From the results array, I want to extract up to 3 URLs whose url contains certain keywords (pricing, plans, product, solution, docs) • I need the output to be a true List column so I can run a downstream enrichment once per URL • If no URLs match, I want a fallback list containing the company’s Website URL The problem I’m running into: • The Formula Generator keeps emitting JSON.stringify, .join(), or JS-style logic, which collapses the output into a string, not a list • “Extract Values from Data” only lets me select Item (first/second/etc.), which returns a single value instead of the full list • I cannot seem to express “filter + limit + fallback” in a way that returns a List rather than text My question: What is the Clay-native, supported way to: 1. Filter an array returned from an API enrichment 2. Limit to N items 3. Apply a fallback while preserving the output as a List column suitable for looping enrichments? If this is not currently possible via Formula / Extract Values, I’d appreciate knowing the intended workaround (e.g. separate steps, transforms, or assumptions).
Clay supports referencing entire lists from enrichments using "Insert all items" which preserves the list structure for downstream enrichments. [1] However, the current documentation doesn't cover the specific filtering, limiting, and fallback logic you need while maintaining list format.
For complex array manipulation like filtering URLs by keywords, limiting results, and applying fallbacks, you might want to try Sculptor first - our built-in AI tool in the top-right corner that can help build workflows and set up automations for free.
What specific keywords are you filtering for in the URLs, and have you tried using Sculptor to help build this workflow?
If you still need help with filtering, limiting, and applying fallback logic in your workflow, I’m here to assist. Would you like to share more details about your current setup or any challenges you’re facing with Sculptor or formulas?
