João Teixeira

Commented on Understanding 'Remove Empty Values' in HTTP Enrich...·Posted in02 Support

Hi Gabriel, I figured it out. I was wrapping the actual value from the column I was referencing in quotes, so it wasn't being removed. Appreciate your help though, feel free to close this

Posted in 02 Support·

João Teixeira

Understanding 'Remove Empty Values' in HTTP Enrichment Columns

How exactly does the "Remove empty values" option for HTTP enrichment columns work?

5Comments

Commented on Request for Selective Field Return in Lookup Enric...·Posted in03 Feedback & Requests

João Teixeira

To be honest, from my experience, I'll be lucky if I can get any AI enrichment column to return the exact structure I want 75% of the times, and I want this to work every single time. I've just made it so its sending the full data to an external service (a n8n workflow) which I then use to extract only the relevant fields and then it passes it on

Commented on Request for Selective Field Return in Lookup Enric...·Posted in03 Feedback & Requests

João Teixeira

It's not that I can't return a specific set of fields, it's that I want to return only a specific set of fields, instead of all of the row's column/value pairs. So, I have this table here: Clay | Export to RecruitCRM setup in such a way that there's 3 columns that perform lookups to other tables within the worksheet ("Lookup Contact", "Lookup Company", "Lookup Job Openings"). It then has a 4th column, "Export Entities To RecruitCRM", which sends an HTTP request to an external webhook, sending the records that were looked up in the previous columns as the request's body. This means that it is essentially sending every column/value pair as key/value pairs in the corresponding record's value, including columns that the external service which serves the webhook doesn't need to know about. I know that I could theoretically configure the body of the request to only include the properties that I'd like for it to send, but to be honest doing so with Clay's formulas is rather clunky. If I could make it so the columns that lookup the records only return a specific set of fields, then only those would be sent in the HTTP request Let me know if I'm not explaining anything properly, happy to follow up, thanks!

Commented on Request for Selective Field Return in Lookup Enric...·Posted in03 Feedback & Requests

João Teixeira

I can't find the option to select which fields to return

Posted in 03 Feedback & Requests·

João Teixeira

Request for Selective Field Return in Lookup Enrichment Columns

It would be nice if we could select which fields to return from a given record when using the "Lookup From Another Table" enrichment columns, as some columns from said record are simply used as transformers/middleware.

8Comments

Commented on Handling Null Outputs in AI Enrichment Columns·Posted in02 Support

João Teixeira

Sounds sloppy. Are empty string values skipped in a waterfall? If so, I could just make the AI return an empty string when it can't fulfill the request, so that it gets skipped. For other results, I'd have to convert them to numbers somewhere else

Commented on Handling Null Outputs in AI Enrichment Columns·Posted in02 Support

João Teixeira

What if the result of the AI enrichment is supposed to be actually 0 sometimes? The formula wouldn't be able to tell them apart

Posted in 02 Support·

João Teixeira

Handling Null Outputs in AI Enrichment Columns

Is there a way to make a "Use AI" enrichment column return nothing/null/undefined when it can't fulfill the prompt, when it's final output is configured to be a number? It seems to get converted to 0 every time

7Comments

Commented on Clay Not Saving Connection Credentials in HTTP Hea...·Posted in02 Support

João Teixeira

No, I'd like to talk to a human

About

Country
My Company Website
Title