Brice D.

After trying a number of free and paid APIs and finding them to lack coverage, I am getting better results with WhoisXMLAPI, which is fairly expensive for what we need but seems fast, reliable and to have broad TLD coverage. However, we are still seeing data gaps, like this example: codment.ink … which we don’t get a correct answer to, but do see full data here: https://www.whois.com/whois/codment.ink … so any inputs or recommendations would be appreciated.

Thanks, Bo (.. We’ll just burn the credits this month to get the clean URLs. Going forwards we’ll only need to do this for a handful of companies per month. It’s most a legacy data clean up.

Gabriel Not possible to use a formula. You would need a map of all of LinkedIn’s CompanyID --> CompanyName values. You must either be able to correctly parse the redirect from one to other, or you must use an enrich function that returns the “friendly” company profile URL with the human readable company name in it. LinkedIn is not doing a simple redirect either. They are running JS scripts that redirect. So the situation is also complicated by that.

It should come back with “https://www.linkedin.com/company/3pillar/” … but the value it returns is: “https://www.linkedin.com/uas/login?session_redirect=%2Fcompany%2F684004%2F”

As a test you can try running it on this value “https://www.linkedin.com/company/684004/”

Tomi F. The Find Redirect does not work as it pulls up a login page for LinkedIn

One problem with all the approaches is a lack of consistency in the industry taxonomies. And even when you have a formal taxonomy like SIC or NAICS, the lack of consistency in how the values are assigned. I find that you end up doing some mappings and guess work to put companies into the right industry buckets, for your specific organization’s taxonomy. The need for this mapping argues for my first approach, where you are doing the mapping / guessing in a Clay table, then once you’ve made a decision, you push the mapping out to your master data system via Zapier or some similar middleware routing.