Request for List Format Output in Prospeo Reverse Domain Email Lookup

Benyamin Holley · 2024-12-30 19:22:35.814853+00

the prospeo reverse domain email lookup needs to output in a list format so I can feed it to another table for further enrichment/sequencing you can see how it outputs now, I would have to output them to separate columns and then feed to another table with the clay API. not ideal

Request for List Format Output in Prospeo Reverse Domain Email Lookup | Clay

6 comments

· Sorted by Oldest

Muhammad
·
·
You can still write it to another table by adding a new enrichment "write to other table" Then edit the column <> click on settings button right next to "Select a list from a column" Then just input the name of column in this way {{NAME OF COLUMN}} In your case it would be {{Find Email Addresses Associated with a Domain}}
2
👀2
Benyamin Holley
·
·
Awesome feedback Muhammad will implement. The fact that it's hidden behind that functionality tho still isn't good. Need parity with other similar workflows you can easily push to a separate table
Muhammad
·
·
agreed - thats a great feedback anyway
Arturo (Clay)
·
·
Hey Benyamin, thanks for reaching out and letting us know. This is perhaps Prospeo's default way of returning their records but yes, great feedback for us to check it out. I've relayed it over to the eng team in case we can handle the conversion so it displays as a list. In the meantime, you can also use formulas as a workaround. Here's a screenshot and the code that would help you achieve this (I used AI in a formula column to write it). The formula will merge all common fields so they turn into a JSON array/list, and will also remove duplicates in the process as this provider may sometimes return duped records themselves. https://downloads.intercomcdn.com/i/o/w28k1kwz/1316237573/37913f1a2e683f0a2c4235badf14/chrome_roWiZY4ttv.png?expires=1735590600&signature=199a5cd397b943248f4fc9de4b273dee2f19ab10d28a2a766570d38e9226e55b&req=dSMmEMt9moRYWvMW1HO4zRJAxySzrHggoNL7u%2F%2FC4QLcdNaPyUXDclN7std1%0ACAWS%0A Formula for write to table: JSON.parse(JSON.stringify(Object.values(_.groupBy({{Find Email Addresses Associated with a Domain}}, 'email')).map(group => group.reduce((acc, obj) => _.assign(acc, obj), {})))) You'll be able to continue as usual after adding the formula. Make sure to replace the column's name if it's different in your table of course. Let me know if you run into any issues!
Benyamin Holley
·
·
Arturo (Clay) and Muhammad thanks for the feedback, i implemented this fix and it worked my feedback still stands tho 😇
Channeled
APP
·
·
Hi Benyamin Holley! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Muhammad
·
·
You can still write it to another table by adding a new enrichment "write to other table" Then edit the column <> click on settings button right next to "Select a list from a column" Then just input the name of column in this way {{NAME OF COLUMN}} In your case it would be {{Find Email Addresses Associated with a Domain}}
2
👀2
Benyamin Holley
·
·
Awesome feedback Muhammad will implement. The fact that it's hidden behind that functionality tho still isn't good. Need parity with other similar workflows you can easily push to a separate table
Muhammad
·
·
agreed - thats a great feedback anyway
Arturo (Clay)
·
·
Hey Benyamin, thanks for reaching out and letting us know. This is perhaps Prospeo's default way of returning their records but yes, great feedback for us to check it out. I've relayed it over to the eng team in case we can handle the conversion so it displays as a list. In the meantime, you can also use formulas as a workaround. Here's a screenshot and the code that would help you achieve this (I used AI in a formula column to write it). The formula will merge all common fields so they turn into a JSON array/list, and will also remove duplicates in the process as this provider may sometimes return duped records themselves. https://downloads.intercomcdn.com/i/o/w28k1kwz/1316237573/37913f1a2e683f0a2c4235badf14/chrome_roWiZY4ttv.png?expires=1735590600&signature=199a5cd397b943248f4fc9de4b273dee2f19ab10d28a2a766570d38e9226e55b&req=dSMmEMt9moRYWvMW1HO4zRJAxySzrHggoNL7u%2F%2FC4QLcdNaPyUXDclN7std1%0ACAWS%0A Formula for write to table: JSON.parse(JSON.stringify(Object.values(_.groupBy({{Find Email Addresses Associated with a Domain}}, 'email')).map(group => group.reduce((acc, obj) => _.assign(acc, obj), {})))) You'll be able to continue as usual after adding the formula. Make sure to replace the column's name if it's different in your table of course. Let me know if you run into any issues!
Benyamin Holley
·
·
Arturo (Clay) and Muhammad thanks for the feedback, i implemented this fix and it worked my feedback still stands tho 😇
Channeled
APP
·
·
Hi Benyamin Holley! This thread was recently closed by our Support team. If you have a moment, please share your feedback: