How to Combine DNS Records for Multiple Domains Efficiently

Hi, can I please have some help? I want to get information about MX records published by a table of domains. In order to do this, I want to combine all of the DNS records for a given domain into a single string in lower case, then run a function on that. I'm just having a bit of trouble with the setup of the DNS records since some domains have multiple and they may not be in the perfect order to just run a function on the first one. https://app.clay.com/workspaces/154918/workbooks/wb_3dz7XjW4G8vh/tables/t_b9g2BUczSBCm/views/gv_ZQfcSAGNEKoG The enrichments in question are "HTTP API", "DNS Records", and "ESP Type"

8 comments

Alan T.
·
·
I think in order to accomplish what I'm trying to do, I would need to combine all "data" fields under "Answer" for "HTTP API" into a single lower case string. Just not sure how to do that.
Tanvi R.
·
·
Hi Alan, thanks for reaching out! The reason your formula for DNS Records is not returning any output is because in the formula you are calling to an Array instead of a field within the array. Thus, the enrichment doesn't know which field within Answer to convert to lowercase. https://downloads.intercomcdn.com/i/o/w28k1kwz/1233272962/288ae4c7a4e68ea26cb3a75a5b1c/CleanShot%2B2024-10-29%2Bat%2B17_44_40-402x.png?expires=1730240100&signature=4d7b808edbd03bb1c2908d30c8ddc60c6ed01d0433218102ab9081cc1c2bd202&req=dSIkFct5n4hZW%2FMW1HO4zd0VjfwgKGVDRD7xs69saWJox7ofQA0FIYs42saT%0A22D5%0A Could you share what you're trying to achieve in the DNS Records column? It looks like the text fields within the Answer array are all lowercase. For the HTTP API column, it looks like the GET endpoint was run sucessfully as it is returning a 200 success message. The ESP Type column is returning "Other" because the DNS Records column is empty, so let's start with fixing the DNS Records column and then we can tackle the ESP Type column!
Alan T.
·
·
Yes-- the ESP Type column is working as expected, its just returning other currently because the DNS records column is not working. My goal is to combine all of the "data" fields of the array into a single string and save it in the "DNS Records" column. Is that possible in clay?
Alan T.
·
·
Also, the formula in "ESP Type" is case sensitive, so "DNS Records" does need to convert to lower case to ensure accurate output.
Bo (.
·
·
Yes that is possible and yes it's case sensitive, you would need to write this prompt! :) https://www.clay.com/university/lesson/how-to-use-ai-formulas https://downloads.intercomcdn.com/i/o/w28k1kwz/1233368862/6e15582df38acd8b358b4387824f/CleanShot+2024-10-30+at+_03KHghYyGE%402x.png?expires=1730250000&signature=d2be7c4daef8134a6ca0a7294f877a02e56b0e083d5407d2ec1d0d7e98390667&req=dSIkFcp4lYlZW%2FMW1HO4zXG4ZmJHvUzHekSkwOVkIUyuM%2FJGM1naAINJ7tTG%0AZ%2Bt0%0A
Alan T.
·
·
That did it! Thanks Bo!
Channeled
APP
·
·
Hi Alan T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Alan T.!