Pulling in favicons

[Alan_Soon]

Hi! I’m new to Airtable and without much programming skills. This is what I need to do:

1. I have a column with company URLs
2. I’d like to automatically fill another column with favicons from those URLs

Is there an easy way to do this?

[Andy_Cloke]

Hi Alan,

I made a YouTube video showing you how to fetch company favicons using the Data Fetcher app.

I hope it’s helpful!

[Alan_Soon]

Andy, you’re so awesome. Thank you so much for this. This is going to open up a whole new universe for me. You’re very kind for doing this.

[Andy_Cloke]

No problem. Glad it was helpful!

[Alan_Soon]

Trying to make this work. I’ve followed your video… but I’m getting an error:

Request failed with status code 400: {“error”:“Unresolved domain name.”}

This is the URL I’m getting from:
http://favicongrabber.com/api/grab/TestDomain*?pretty=true

(Test = My test base, Domain = the cleaned URL)

What am I doing wrong?

[Andy_Cloke]

It sounds like the api simply is not find the domain name.

Have you confirmed it works with that domain name? You can test it by simple navigating to this URL in the browser:

http://favicongrabber.com/api/grab/DOMAIN_NAME?pretty=true

If that’s not the issue - make sure there are no spaces in the table or field names. That can sometimes cause issues.

[Alan_Soon]

Ok, I think I have an idea of what’s going on.

I have about 7,000 records. A number of these domains aren’t loading, and some are just slow. Perhaps that’s the problem.

Is there a way to skip to the next record when a URL isn’t functioning?

[Andy_Cloke]

Ah I see. At the moment there isn’t a way to skip to the next record - all requests is paused on error. Sorry about that! I will definitely add that to a future version of the app though.